Changed Internal Item Number In Item Master Does Not Reflect In iProcurement Search
(Doc ID 1086055.1)
Last updated on FEBRUARY 16, 2019
Applies to:
Oracle iProcurement - Version 12.0.6 to 12.1.1 [Release 12 to 12.1]Information in this document applies to any platform.
Symptoms
After changing the internal item number in item Master search in iprocurement for the new internal item number does not show any result. Search for the description or the old internal item number finds the item.
STEPS TO REPRODUCE (with a generic item example)
- Login to Core Purchasing
- Navigate to Items > Master Items
- Change the internal Item number from i.e. AS1234 to BC1234 for the item "Test rename"
- Login to iProcurement
- Search for BC1234
No results found - Search for "Test rename"
This search finds the item "Test rename" with internal Item BC1234 shown as the internal item number - Search for AS1234
This search finds the item "Test rename" with internal Item BC1234 shown as the internal item number
The internal Item number was updated but the intermedia index of iProcurement still has the old item number.
You can use the following sql to verify:
SELECT inventory_item_id FROM mtl_system_items_b mi WHERE segment1 like '&changed_number';
Enter the changed internal item number
SELECT * FROM icx_cat_items_ctx_dtls_tlp WHERE inventory_item_id = &inventory_item_id ORDER BY ctx_desc DESC;
Enter the inventory_item_id from the last statement.
Enter the changed internal item number
SELECT * FROM icx_cat_items_ctx_dtls_tlp WHERE inventory_item_id = &inventory_item_id ORDER BY ctx_desc DESC;
Enter the inventory_item_id from the last statement.
The output will show in the CTX_DESC column the old internal item number.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| STEPS TO REPRODUCE (with a generic item example) |
| Cause |
| Solution |
| References |