In this Document
APPLIES TO:
Oracle iProcurement - Version 12.0.0 to 11.5.6 [Release 12 to 11.5]
Information in this document applies to any platform.
PURPOSE
This bulletin is to help in finding the reason the item is not displaying in iProcurement. The item could be from the Master Items, tied to a global blanket purchase agreement, or a bulkloaded item.
There are various causes of the item not showing up in iProcurement. This document will list some of the common known cases.
SCOPE
This document is intended for iProcurement users as well for supporting personnel.
DETAILS
Starting in Release 12.0, all the items entered in the Master Items form (in Oracle Inventory) are available in iProcurement and in the Professional Buyer's Work Center in Oracle Purchasing. There is no flag at the category code to enable the category in iProcurement. This restriction is done in the Content Zone.
The premise of displaying the items in iProcurement automatically depends on some conditions:
- iProcurement needs to be installed in the instance.
- Purchasing Category is mapped to Shopping Category. Not required and if not mapped the Content Zone needs to have the option to show Items With No Shopping Categories checked.
- The supplier item has a price
- Profile 'PO: Legal Requisition Type' is set properly
- The item is translated to the language using the globe
- Category is part of the Purchasing functional area in the default category set
- If using sourcing documents (GBPA, BPA), there is no expired lines or document
- The Inventory Organization associated with the Master/Organization Items:
1. Go to Purchasing responsibility tied to the Operating Unit.
Navigation: Setup > Financial Options > Supplier - Purchasing region
2. Check the Inventory Organization. This should belong to the same operating unit as the Master/Organization Items.
- Check in the Master Items if the item is Active. If the item is not active or the Purchased/Purchasable flag or Internally Ordered is not checked, the item will not show up in iProcurement search results.
Also, the translation has impact in the visibility of the item in iProcurement. The item will show up in the language once the description is translated using the globe in the Master Items form. The item is considered translated in the following condition:
In the table MTL_SYSTEM_ITEMS_TL the source_lang and the language will be the same.
Example:
source_lang = 'PTB'
language = 'PTB'
For BPA (local Blanket Purchase Agreement) and GBPA (Global Blanket Purchase Agreement):
1) The globe icon for translation is accessed in the Blanket in Core Purchasing responsibility.
2) In the Buyer Work Center (BWC) log using the language in which the item will be
uploaded.
For non catalog items set profile POR: Load One-Time Items in All Languages to Yes to translate in the installed languages in the instance.
In case the categories are not mapped, check the option Include Items Without Shopping Categories in the iProcurement Catalog Administration responsibility > Content Zone. Then, check if the items are showing up.
The SQL statements to determine if the item is available in iProcurement tables are available in Note 1437273.1 - Rel 12 Catalog Tables and Queries.
If the items are available in the tables icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp, and not displaying in the iProcurement search results, check if the extracted item is the one translated to the language. Another cause could be the content zone restriction.
To check content zone:
- Go to iProcurement Catalog Administration responsibility > Stores > Content Zones
- Check the content zone associated to the store
- Verify if there are any restrictions on the operating units, responsibilities, suppliers, and/or categories.
As long as the user has multiple responsibilities, the page will show the stores from all the responsibilities. If restricting by responsibility assign to the user only the responsibility which has the desired stores.
Note that iProcurement does not use MO: Security Profile neither HR: Security Profile. The profile MO: Operating Unit is still valid for iProcuremnt and iProcurement Catalog Administration responsibilities.
To restrict the search results by operating unit, the content zone is the place to execute the setup.
Multiple Content Zones with the same name would not display the items in iProcurement correctly. One content zone per same name is the usual.
To purge expired or inactive items for displaying in iProcurement run the concurrent process Purge Catalog InterMedia Index.
If clicking the Stores link in the Shop page is not returning any categories, check the category hierarchy which needs to be built in order to be available for category browse. The category hierarchy is configured in iProcurement Catalog Administration responsibility > Schema >Category Hierarchy.
To map the shopping categories automatically from purchasing categories set profile option 'POR:Autocreate Shopping Category and Mapping' to Yes.
In case of multiple operating units check the Item Master Organization defined by OU:
1. Go to Inventory responsibility > Setup > Organizations > Parameters
2. Choose the organization which belongs to the operating unit.
3. Check the Item Master Organization
4. Now go to Purchasing responsibility > setup > Organizations > Financial Options
5. Choose same operating unit above
6. Click Supplier-Purchasing tab
7. Check if the inventory organization is the one associated to the Item Master Organization assigned in step 3. 
