Performance Import Items (INCOIN) with ICX_CAT_ENDECA_ITEM_ATTRIBUTES
(Doc ID 2088848.1)
Last updated on AUGUST 08, 2021
Applies to:Oracle Item Master - Version 12.2.4 and later
Information in this document applies to any platform.
INCOIN, Performance, MTL_ITEM_REVISIONS_INTERFACE, ICX_CAT_ENDECA_ITEM_ATTRIBUTES, POPULATE_ICX_ENDECA.SQL, ENDECA
Inventory Import Items program runs for a long time or does not complete. Item records are being created from interface table to base tables, but the process does not complete or has very slow performance
TKPROF trace files do not show slow performance on any ICX (iProcurement) or Endeca statements. The slowest performance is at statements like the following:
SELECT I.TRANSACTION_ID, I.TRANSACTION_TYPE, I.INVENTORY_ITEM_ID,
I.ORGANIZATION_ID , I.REVISION, ROWID
MTL_ITEM_REVISIONS_INTERFACE I WHERE I.PROCESS_FLAG = 2 AND I.SET_PROCESS_ID
= :B3 AND (I.ORGANIZATION_ID = :B2 OR :B1 = 1) AND NOT EXISTS (SELECT 'X'
FROM MTL_SYSTEM_ITEMS M WHERE M.ORGANIZATION_ID = I.ORGANIZATION_ID AND
M.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID) AND NOT EXISTS (SELECT 'X' FROM
MTL_SYSTEM_ITEMS_INTERFACE MI WHERE MI.ORGANIZATION_ID = I.ORGANIZATION_ID
AND MI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID AND PROCESS_FLAG = 4)
It seemed the same as described in [ Note 1956955.1 - Import Items Performance Issue On Update (Doc ID 1956955.1) ], but even after implementing the solution from this note the performance is still the same.
The customer uses only segment1 in mtl_system_items_b for the item number
STEPS TO REPRODUCE
1. Navigate to Inventory responsibility
2. Run item import for large number of items
- see the slow performance
Expect the process to complete in a timely manner
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