Purchasing Dimension/Fact Data Availability In APCC - No Data In Table MSC_ORDERS_F
(Doc ID 2218373.1)
Last updated on MARCH 08, 2017
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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!