Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 09-May-2013***
On : 7.3.0 version, LoadData
Notice the planning parameters max_sales_date, last_date_backup get set to the last booked order date. Also shipment quantities of zero are inserted into the shipment history. This causes the forecast based on shipment to be wrong.
To clarify. We do two collection runs. One for shipments with selection criteria for certain order types. And another for bookings with select criteria for other order types.
When we do the collection for bookings the date parameters get set incorrectly and affect the forecast. Because the bookings go all the way out to 2012 the max_sales_date gets set incorrectly. Also records with actual_quantity with non null values come over along with the bookings records.
Expect max_sales_date to be set correctly when loading data into Demantra via Collect Shipment and Booking History
The issue can be reproduced at will with the following steps:
1. Demand Management System Administrator
2. Nav: Collections -> Oracle Systems -> Shipment and Booking History
3. Run Collect Shipment and Booking History
4. Check to Collect Bookings Booked Items Requested Date
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms