Material Returns Are In Wrong Month Of Forecast In SPP Returns Forecast - Uses the Booking Date and not the Shipped Date (Doc ID 2110678.1)

Last updated on FEBRUARY 16, 2017

Applies to:

Oracle Service Parts Planning - Version 12.1.3 and later
Oracle Demantra Demand Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On a 12.1.3.9.1 Instance:

PROBLEM
-------------
The view MSD_PRODUCT_RETURN_HISTORY_V (table name is MSD_DEM_RETURN_HISTORY) is using the column BOOKED_DATE from table OE_ORDER_HEADERS_ALL instead of a date from OE_ORDER_LINES_ALL table.  This results in the return landing in the incorrect month of the Supply Demand Analysis.

Example:  A Sales Order is booked in October and shipped in December.  A return is processed on the order in December.  After collections and SPP Plan run, the return shows up in October instead of December.

EXPECTED BEHAVIOR
----------------------------
Return processed in December and should show up in December.

STEPS
------------
1. Book a Sales Order in October and ship in December
2. Process a return on the order in December
3. Run data collections and SPP Plan
4. Review Supply Demand Analysis
5. Find the return shows in October instead of December

Cause

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