My Oracle Support Banner

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 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

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 ))


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
Cause
Solution
References


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