My Oracle Support Banner

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.


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

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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.