SFM Poor Performance in CSI_ITEM_INSTANCES When Processing IB Transactions
(Doc ID 1573273.1)
Last updated on JULY 14, 2020
Applies to:Oracle Installed Base - Version 184.108.40.206 and later
Information in this document applies to any platform.
Slow performance on this query and causes overall slow performance in SFM
SELECT INSTANCE_ID, QUANTITY, SERIAL_NUMBER, LOCATION_TYPE_CODE,
@ INSTANCE_USAGE_CODE FROM CSI_ITEM_INSTANCES WHERE INVENTORY_ITEM_ID = :B2 AND
((LOCATION_TYPE_CODE = 'WIP' AND WIP_JOB_ID = :B1 ) OR (INSTANCE_USAGE_CODE =
'IN_RELATIONSHIP' AND LAST_WIP_JOB_ID = :B1 ))
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