My Oracle Support Banner

After Upgrade To 12.2.4.1 - The Archive Plan Summary Not Completing (Doc ID 2059468.1)

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.

Symptoms

12.2.4.1

PROBLEM
-------------
We are upgrading to VCP 12.2.4.1. In our system testing instance, the 'Archive Plan Summary' is running very long and not completing.
We also ran Gather Schema Statistics for MSC Schema and retried, but the archive plan summary program is not completing. Hence, we are unable to test/use APCC.

Requests.sql output from Note 280295.1 shows the following

2424556 Archive Plan Summary - Time 1,307

Archive One Package
req_ID / TIME / trace_ID / parameters
2424559 / 443 / 8473 / msc_supply_pkg, 2054, 386011,
2424560 / 22 / 8491 / msc_exception_pkg, 2054, 386011,
2424561 / 1 / 8596 / msc_supplier_pkg, 2054, 386011,
2424562 / 337 / 8605 / msc_phub_cost_pkg, 2054, 386011,
2424563 / 1,301 / 8630 / msc_demand_pkg, 2054, 386011,
2424564 / 60 / 8658 / msc_resource_pkg, 2054, 386011,
2424565 / 625 / 9463 / msc_phub_excess_pkg, 2054, 386011,

STEPS
--------
run plan and APCC Loads

EXPECTED BEHAVIOR
----------------------------
will complete within reasonable time

BUSINESS IMPACT
---------------------
This is impacting our go-live in Nov 2015.

Cause

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
Symptoms
Cause
Solution
References


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.