Performance Issue With Update Configuration BOMs And Routings Request
(Doc ID 2586891.1)
Last updated on OCTOBER 01, 2019
Applies to:Oracle Configure to Order - Version 12.1.3 and later
Information in this document applies to any platform.
Performance issue observed for Update Configuration Bom and Routings program.
The program should complete within 30 hrs for the classes submitted
Customer states they had their DBA team reviewed the Trace and provided this
Contention was seen from the program - Update Configuration BOMs and Routings
The requests were having enq:TX-row lock contention from the below SQL :
UPDATE BOM_OPERATION_SEQUENCES SET CONFIG_ROUTING_ID = :B2 , LAST_UPDATE_DATE
= :B1 WHERE ( OPERATION_SEQ_NUM, NVL(OPERATION_TYPE,1), ROUTING_SEQUENCE_ID)
IN (SELECT OPERATION_SEQ_NUM, NVL(OPERATION_TYPE,1), ROUTING_SEQUENCE_ID FROM
BOM_OP_SEQUENCES_INTERFACE WHERE BATCH_ID = :B3 ) AND IMPLEMENTATION_DATE IS
NOT NULL AND ( DISABLE_DATE IS NULL OR (DISABLE_DATE IS NOT NULL AND
DISABLE_DATE >= SYSDATE )) RETURNING ROUTING_SEQUENCE_ID INTO :O0
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