How To Add Attributes At Different Levels Of Custom Demantra Hierachies That Are Imported Into APCC? (Doc ID 1981533.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

We are upgrading from VCP from 12.1.3.8 to 12.2.4.1

We have set up the "MSC: Additional Item Hierarchy in APCC" profile to import a custom Product hierarchy. After running "Refresh APCC materialized Views" the MSC_APCC_CUSTOM_HIER table was loaded with the custom hierarchy data. We would like to know if there is a provision to import/add attributes at different levels in the hierarchy e.g. we have a level "XYZ Group" in Demantra and have defined some attributes to capture certain flags at this level. How do we add these flags in APCC custom hierarchy?

In the 12.1.3.8 production environment, we have a custom materialized view defined to capture this hierarchy along with the level attributes. This MV serves as our Product dimension in APCC for S&OP Reports.

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