My Oracle Support Banner

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

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.