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

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