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