BOM_BILL_OF_MTLS_INTERFACE Table Growing (Doc ID 1303601.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Bills of Material - Version 12.0.6 to 12.0.6 [Release 12]
Oracle Configure to Order - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***

Symptoms

On R12.x in Production:
Item creation time has increased since upgrading to R12.
The BOM_BILL_OF_MTLS_INTERFACE table is having million rows and growing.
The reason is some process is creating records with null process_flag.
We would like to know if it is safe to purge these records for Item creation process to run faster.

-- Recent Changes
Upgrade to R12
Item creation is still occurring, just running 8 times slower

-- Duration
Item creation was an average of 1.5 seconds and now is 8.5 seconds.

Cause

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 hundreds of Community platforms