Item Level Data with No Organization Context not Showing in APCC Reports
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.
In a VCP 22.214.171.124 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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms