My Oracle Support Banner

ATP Based on Planning Output - Does Not Remove Planned Order upply From The ATP Plan When Sales Order Demand Is Changed/Canceled (Doc ID 1220593.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Global Order Promising - Version 12.1.2 and later
Information in this document applies to any platform.


When a Sales Order is entered and Planned Order supply created, then if Sales Order demand is removed, the supply is kept in the plan.

  Steps to Reproduce
Item A (make item) does not have any supply or demand. Then create a sales order line and add a line qty of 100. if the ATP details is checked then the pegging information explodes and provides the component details.

Step 2: Add a scheduled ship date and save it. This creates records in the tables MSC_SUPPLIES and MSC_DEMANDS. There is a sales order entry in MSC_DEMAND for 100 units and a planned order in MSC_SUPPLIES for 100 units.

Step 3: If the request date is now removed or the line is cancelled, then the demand in the MSC_DEMAND is removed, but the offsetting supply in MSC_SUPPLIES is not deleted. This creates an overstatement of supply.

Step 4: When we create a new sales order (before the collections and the ATP plan is run) the supply created in the previous steps shows up and the item does not explode in the pegging details form.

Is this the design of ATP?

We would prefer to have the demand removed from the plan, so that we can drill down to the details of the BOM for this make item when ATP is checked.


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.