iProcurement Users Cannot Search and Find Newly Defined Master Items Which are Associated to Existing Mapped Categories When Using RDBMS 18.104.22.168
Last updated on MAY 24, 2018
Applies to:Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.
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
Operating Unit 101
Item Number 76-1234
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,
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)
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.
However the problem still occurs for new items added to existing categories.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms