Item Level Data with No Organization Context not Showing in APCC Reports (Doc ID 2058468.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.

Symptoms

In a VCP 12.2.4.1 Instance:
APCC- History data published at Item level with no organization context not showing in reports

Unable to see data in OBIEE reports which has been published at Item level(with no organization context) to APCC using "Publish DM Measures to APCC" workflow. The data is available in the MSC_DEMANTRA_ODS_F table, but the MSC_APCC_ITEMS_D table has no combination of "-23453" organization ID for Items published from Demantra.

The issue when creating a new OBIEE query is:
Do not have Organization level mapped within Demantra and all data is at Item-Country-Demand Class-SalesChannel level only. Here are the steps followed:
1. Run standard workflow "Publish DM-APCC Measures" to push historical(ODS) and forecasting measures into APCC tables.
2. Run "Refresh APCC Mview" request to refresh data in APCC item, calendar and other tables.
3. Create a new query using "Advanced Planning" subject area in APCC-OBIEE application to view ITEM, HISTORY data.
4. Run the query, NO RESULTS show up.

Debugging the standard code seems to be indicating that MSC_DEMANTRA_ODS_F is linked to MSC_APCC_ITEMS_D dimension table and requires ITEM-ORG combinations to exist in MSC_APCC_ITEMS_D table. Here though do not have any org code in Demantra to MSC_DEMANTRA_ODS_F table has org code as "-23453", but MSC_APCC_ITEMS_D table does not seem to carry a combination of items published from Demantra and org code "-23453" which causes the report to not show any results. Question is why MSC_APCC_ITEMS_D does not carry this combination?

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