Missing Columns In SALES_PLAN_DATA Table,Why? What are the features for Platform Upgrade and Platform + Application Ugprade?
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.
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 22.214.171.124 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 126.96.36.199 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.
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