Autocreate Configuration Items is Running For Hours Not Creating the Star Numbers
(Doc ID 1335273.1)
Last updated on AUGUST 30, 2022
Applies to:
Oracle Configure to Order - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10] Information in this document applies to any platform.
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