How To Reduce Number Of Records in the MSC_SALES_ORDERS Table?
(Doc ID 2963106.1)
Last updated on JULY 25, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
Running the ATP Data Collections with the Sales Order parameter set to Net Change Refresh causes the table MSC_SALES_ORDERS to grow very large.
The same can occur when running the Planning Data Collection with
(a) Collection Method = Net Change Refresh or
(b) Collection Method = Complete Refresh and Sales Order parameter = No (which triggers a Net Change Refresh of Sales Orders)
How to reduce number of records within MSC_SALES_ORDERS table?
Solution
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
Goal |
Solution |
References |