Purchasing Dimension/Fact Data Availability In APCC - No Data In Table MSC_ORDERS_F (Doc ID 2218373.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.5 version, Reports and Dashboards in Test

Users have applied Consolidated VCP #2 patching via patch 22493520. Users are trying to send ASCP plan data over to APCC. However there is no data populated in the tables MSC_ORDERS_F even though they state the concurrent request called Archive Plan Summary ran after the plan

EXPECTED BEHAVIOR
-----------------------
Expect the fact tables in APCC to be populated with the ASCP plan date

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ASCP plan with the following Launch parameters

Plan name = FTL_TKY
Launch Snapshot = Full Snapshot
Launch Planner = Yes
Anchor Date 30-NOV-2016
Archive Current Version of Plan Summary = No (believe this should be Yes)
Enable 24x7ATP is NULL
Release Reschedules is NULL
Snapshot Static Entries = Yes
Build Worksheets = No
Snapshot Source for Firm Planned Orders = FTL_TKY
Copy Plan Output to Simulation Plan = No
Enable Details in APCC = Yes

2. Even though Archive Plan Summary runs at the end of the ASCP plan, no data is found in the fact tables for APCC

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