My Oracle Support Banner

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 DECEMBER 04, 2019

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 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 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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.