In Advanced Planning Command Center MSC_ORDERS_F Table Is Not Getting Populated (Doc ID 2019285.1)

Last updated on DECEMBER 05, 2016

Applies to:

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

Symptoms

On : 12.2.4.1 version, Load and Summarization ETL

ACTUAL BEHAVIOR
---------------
APCC: MSC_ORDERS_F table is not getting populated.

We are observing that after ASCP plan publishes data to APCC tables MSC_ORDERS_F is not getting populated.

EXPECTED BEHAVIOR
-----------------------
Expect rows to be present in MSC_ORDERS_F

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ASCP plan with Publish KPI and data to APCC
2. Check MSC_ORDERS_F table
3. Note that there are no rows

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