My Oracle Support Banner

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 later
Information in this document applies to any platform.


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?


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.