Missing Columns In SALES_PLAN_DATA Table,Why? What are the features for Platform Upgrade and Platform + Application Ugprade? (Doc ID 2173659.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Customer is planning to pull cost elements from EBS to Demantra using the standard "Download Plan
Scenario Data" workflow. However, On checking the supply_plan_data table, they are not able to see the columns:
PURCH_COST, TRANS_COST, CARRY_COST, MFG_COST. Customer is in VCP 12.2.4 and Demantra 12.2.4 build 117 .

The customer has done a platform upgrade recently from 7.3.1.3 to 12.2.4 build117. The customer has not done platform
+ application upgrade. Please clarify if this is the reason for the missing cost related columns in supply_plan_data.

1) The customer has done the platform upgrade from 7.3.1.3 to 12.2.4 build 117. Could be the reason for the missing cost
related columns in supply_plan_data?
2) If yes, do we have a patch to enable the cost functionality (bringing cost elements into S&OP)?
or any suggestions to bring cost funtionality
3) Can you please provide information on what are the features (list of features missed out) that will be missed out if we go for Platform upgrade only.

All the seeded worksheets related to cost element are also missing.

 

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