My Oracle Support Banner

ASCP: Sales Order Changes Not Collected In Net Change Mode (Doc ID 2705338.1)

Last updated on SEPTEMBER 07, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

12.2.4.1


PROBLEM
-------------
Net Change collections is not removing unscheduled sales orders form msc_sales_orders

STEPS
---------
Allocated ATP based on planning data

Net change during the week 2 x per day 11 am / 8pm PST
-- ATP plan runs 2x per day at same time as collections
Then run data collections with complete refresh on weekend

1. Sales order entered

2. Run net change and plan

3. Unschedule the sales order
-- at that time you see msc_alloc_demands has been updated for the unschedule so that:
-- ALLOCATED_QUANTITY = 0 and OLD_ALLOCATED_QUANTITY = previous value

4. Run net change and plan

5. Then see plan still has the sales order even when it has been unscheduled
-- msc_alloc_demands has been reset and has demand quantity
-- in Order Mgmt we see order is still unscheduled.

OWC findings
file uploaded dc_so.zip
OE_ODR_LINES_SN.csv - has 2 lines
line_id / SO #
80471974 - NO SCHEDULE SHIP DATE - 73816519.Bulk Order Pre-Season-Shanghai.ORDER ENTRY(2.1)
80471973 -HAS SHIP DATE - 73816519.Bulk Order Pre-Season-Shanghai.ORDER ENTRY(1.1)

MRP_AN2_SALES_ORDERS_V.csv - has only 80471973

Ran query
select * from mrp_ad_sales_orders_v where demand_id = 80471974
-- no records
select * from mrp_ad_order_lines_all where line_id = 80471974
-- no records


BUSINESS IMPACT
----------------------
Cannot use Net Change Collections

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.