How to Improuve Performance on Delete Supply Chain Cost Rollup

(Doc ID 2368517.1)

Last updated on MARCH 02, 2018

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

On : 12.1.3 version, Cost Maintenance

Delete Supply Chain Cost Rollup Data performances can be very poor

Sometimes, the Delete Supply Chain Cost Rollup Data performances are very poor.

When I checked the tables which are purged during this process, I see they contain lots of records.
For example, CST_SC_BOM_STRUCTURES contain more than 30,000,000 records.

Solution

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