Chaining Error : The ‘To Date’ Cannot Exceed the Furthest Out ‘Sales Date’
Last updated on MARCH 30, 2017
Applies to:Oracle Demantra Demand Management - Version 7.1.1 to 7.2 [Release 7 to 7.2]
Information in this document applies to any platform.
This problem can occur on any platform.
On 7.2 in Production:
Created a new item for an Existing Location and selected an existing Item from that location as a
From, To and Start Date were populated by default, no changes made. But when clicked at 'Chain',
it gives an error message:
'The To-Date cannot exceed furthest out sales date'.
Confirmed the source (item-location combination ) has sales data upto '31-Dec-07' in sales_data table.
time_sig : 08-OCT-07
max_sales_date: 31-DEC-2007 (From Sys_Params)
The ‘To Date’ can not exceed the furthest out ‘Sales Date’.
1. Open chaining Management.
2. Create a new item for an Existing Location and enter as target.
3. Select an existing Item from that location as a source.
4. Click on Chain. Get the error message.
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