Demantra Custom Measures Are Not Getting Published To APCC (Doc ID 2201678.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3.8 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Demantra Demand Management / Export to APCC
When attempting to perform a workflow to Publish Data to APCC,
find that while rows are added to APCC fact table msc_demantra_f,
the custom measures declared in table msc_apcc_custom_measures (for example)
S&OP Forecast
Protection
S&OP Forecast Final
Financial Forecast
Baseline Forecast
Organization Destination Key
SOP Forecast Final Publish
SOP LL Fcst Final Publish
are not populating the corresponding columns in APCC fact table msc_demantra_f
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE23

EXPECTED BEHAVIOR
-----------------------------------
Expect that the custom measures declared in table msc_apcc_custom_measures would populate the corresponding ATTRIBUTE% columns in APCC fact table msc_demantra_f.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Create integration interface with standard series along with custom measures (additional series) to populate plan specific attributes (msc_demantra_f)

2. Create and run a workflow to Publish Data to APCC to publish plan specific S&OP-APCC Measures from Demantra to APCC using the new integration interface.

3. Observe that data is published to APCC (msc_demantra_f) but the ATTRIBUTE% columns are not populated.

Cause

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