Autocreate Configuration Items is Running For Hours Not Creating the Star Numbers (Doc ID 1335273.1)

Last updated on AUGUST 30, 2022

Applies to:

Symptoms

On : 11.5.10.2 version, Configuration Process

Concurrent request 'AutoCreate Configuration Items' runs for hours and doesn't complete. Autocreate
configuration items is not creating the Star numbers. Trace file shows the performance is due to the following
statement:

SELECT COMPONENT_SEQUENCE_ID, COMPONENT_ITEM_ID
FROM BOM_INVENTORY_COMPS_INTERFACE WHERE PARENT_BILL_SEQ_ID = :B1 FOR UPDATE OF ITEM_NUM

STEPS
--------
1. Submit 'AutoCreate Configuration Items'

Cause

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