My Oracle Support Banner

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 06, 2019

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.


On a Instance:

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.

Return processed in December and should show up in December.

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


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.