Extending Table for Additional Item Attributes in Older Versions of APCC

(Doc ID 2068006.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

In a VCP 12.2.3 Instance:
There are some custom item attributes which are stored as PIM attributes in item master in Oracle EBS. These attributes are not collected into VCP (ASCP, APCC, or Demantra) as part of standard collection.
For cases when these custom PIM attributes are required in APCC for reporting, one option is to use up to 30 CUSTOM attribute columns in the MSC_APCC_ITEM_D table.  However, this new functionality is only available for the following code lines:

12.1 -   VCP 12.1.3.9.1+

12.2  -  VCP 12.2.4.1+

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