Master Item Not Shown In iProcurement Item Search (Doc ID 2858674.1)

Last updated on FEBRUARY 02, 2025

Applies to:

Symptoms

Version 12.2.x  iProcurement

Master item created in Item form is not shown in iProcurement.
When Search for an Item in iProcurement No data is returned.

Once source document created (ex. BPA) Item gets searched fine.

STEPS
----------------------
The issue can be reproduced at will with the following steps:
1. Create Item in Master Item form
    - Assure list price entered, purchasing item, assign Purchasing category
    - Profile POR: Autocreate Shopping Category and Mapping is enabled Y
2. Search for this item in iProcurement (iProcurement Home page -> Search ex 'TESt%' in Main store)

QUERY to check data shows no data created for iProcurement tables;

For Inventory Item Data:
  SQL> SELECT inventory_item_id FROM mtl_system_items_b mi WHERE segment1 like '%&item_number%';
       -- This shows data exists fine
For ICX/iProcurement table:
  SQL> SELECT count(*) FROM icx_cat_items_ctx_hdrs_tlp WHERE inventory_item_id = &inventory_item_id;
  SQL> SELECT count(*) FROM icx_cat_items_ctx_dtls_tlp WHERE inventory_item_id = &inventory_item_id;
       -- No data created in above ICX tables
 * However once source document created (ex. BPA) Item gets searched fine.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.