My Oracle Support Banner

BOM_BILL_OF_MTLS_INTERFACE Table Growing (Doc ID 1303601.1)

Last updated on JANUARY 30, 2022

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.


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.


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

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