My Oracle Support Banner

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.

Symptoms

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
feedback:

Contention was seen from the program - Update Configuration BOMs and Routings
The requests were having enq:TX-row lock contention from the below SQL :
4a6ywf16yxar5:
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

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.