My Oracle Support Banner

Performance Problem in Receipt Interface Due for IB Trackable Item (Doc ID 2360574.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle Installed Base - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

 Performance found in receipt interface with following expensive SQL

 

SELECT OOL.CONFIG_HEADER_ID CONFIG_SESSION_HDR_ID, OOL.CONFIG_REV_NBR
 CONFIG_SESSION_REV_NUM, OOL.CONFIGURATION_ID CONFIG_SESSION_ITEM_ID
FROM
MTL_MATERIAL_TRANSACTIONS MMT, MTL_UNIT_TRANSACTIONS MUT, OE_ORDER_LINES_ALL
 OOL, CSI_TRANSACTIONS_INTERFACE CTI WHERE MMT.TRANSACTION_ID =
 MUT.TRANSACTION_ID AND MMT.TRANSACTION_ID = NVL(CTI.MTL_TRANSACTION_ID,0)
 AND MMT.TRANSACTION_ACTION_ID = 1 AND MMT.TRANSACTION_SOURCE_TYPE_ID = 2
 AND MUT.INVENTORY_ITEM_ID = :B3 AND MUT.SERIAL_NUMBER = :B2 AND
 MMT.TRX_SOURCE_LINE_ID = OOL.LINE_ID AND CTI.ORDER_TYPE = 'SALES ORDER
 ISSUE' AND CTI.PROCESSED_FLAG IN ('N','R','PE') AND CTI.CREATION_DATE > :B1

 

 

Changes

 

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!


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