iProcurement Users Cannot Search and Find Newly Defined Master Items Which are Associated to Existing Mapped Categories When Using RDBMS 11.2.0.1 (Doc ID 1633427.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

iProcurement users cannot search and find newly defined master items which are associated to existing mapped categories.

STEPS TO REPRODUCE
1. Verify a Purchasing Category is mapped to a Shopping Category
- The Default Category Set for Purchasing functional areas is 'Inventory' or any other
- All categories are listed in the list of Valid Categories for the category set
- Enforce list of valid categories is enabled

POR: Autocreate Shopping Category and Mapping Y

3. Add a new item in master items and associate the item to the existing purchasing category that is mapped to shopping category
Example:
Operating Unit 101
Item Number 76-1234
Responsibility iProcurement


4. Search for the new item in iProcurement the new item is not found in the iProcurement search results
- the item has ip_category_id -2 even though the purchasing category is mapped to a shopping category.

SELECT invitems.segment1, icxitems.*
FROM icx_cat_items_ctx_hdrs_tlp icxitems,
  mtl_system_items_b invitems,
  financials_system_params_all fsp
WHERE icxitems.inventory_item_id = invitems.inventory_item_id
  AND invitems.segment1 = '76-1234'
  AND fsp.inventory_organization_id = invitems.organization_id
  AND fsp.org_id = icxitems.org_id
  AND fsp.org_id = 101

5. Run Rebuild Intermedia Index
6. Retest the search and still the item is not found
7. Update the item description in item master for an item that is visible in iProcurement search results
8. Search for the item in iProcurement and see the item description still remains the same as before, rather than showing the newly updated item description from master items. (This holds true whether the item is on a source document or not)

WORKAROUNDS
a) Run this script

Initially POR: Autocreate Shopping Category and Mapping = N. Then it was changed to Y.

After setting the context, the following script fixed all 270 EXISTING items that were not mapped to ip categories.

BEGIN
ICX_CAT_UTIL_PVT.setCommitParameter(FND_API.G_TRUE);
ICX_CAT_UTIL_PVT.setBatchSize(100);
ICX_CAT_UTIL_PVT.getPurchasingCategorySetInfo;
ICX_CAT_UTIL_PVT.setWhoColumns(null);
ICX_CAT_POPULATE_MI_PVT.upgradeR12MIs(sysdate-85,'AAAdd+AEvAAAAVBAAA','AAAdd+AE0AAB+qfAAV');
END;

However the problem still occurs for new items added to existing categories.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms