Series for implementing the Shipment and Consumption functionality available in 12.2.4.1

(Doc ID 2115879.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Customer is implementing the Shipment and Consumption functionality available in 12.2.4.1
They are following the Doc
Demantra PTP – Shipment vs. Consumption Forecasting White Paper for Release for 12.2.4 and Later. For 7.3.1 to 12.2.3 see MOS note 1630628.1 (Doc ID 1949957.1)
They mention that said doc does not identify the seeded Demantra series that needs to be modified and also does not explain what the changes are. They are looking for a list of seeded series that will be modified by this functionality and what are the changes for each of the series.

Here are some paragraphs copied from the white paper.

3.4 CONFIGURE PROMOTIONAL DATA SERIES UPDATES

3.4.1 FUNDING / BUDGET SERIES CHANGES --> Customer question: Are there any other series that were not mentioned here in 3.4.1? Example: Fund series?
Promotional Spending needs to be calculated based on Shipments for Off-Invoice and Bill-Back Allowances and on Consumption for Scan-Down Allowances. Validate that these Series are based on the correct values.
The pre-seeded “Buydown Spend” Series will need to be revised:
• Recommend adding three new series:
o Off-Invoice Spending calculated using Shipments during shipment time frame
o Bill-Back Spending calculated using Shipments during shipment time frame
o Scan-Down Spending calculated using Consumption during consumption time frame

• Modify the “Buydown Spend” Series to be the sum of these.

3.4.2 RETAILER SERIES CHANGES --> Customer question: Need to identify the series
Series that provide a Retailer-view of promotional activity (including Retail sales and profit) should be modified to use Consumption instead of Shipments.

Customer question: Are there any other series that is required to successfully implement Shipping and Consumption Planning?
 

Solution

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