Archive Plan Summary / Archive One Package Concurrent Performance Issue During MSC_ITEM_PKG Updates (Doc ID 2042121.1)

Last updated on DECEMBER 05, 2016

Applies to:

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

Symptoms

On : 12.2.3 version, Performance

ACTUAL BEHAVIOR
---------------
Plan Archive Summary performance is too long

Plan Archive Summary jobs are running for hours causing the daily plans to be inaccessible in APCC until late in the afternoon. There appears to be an issue with one particular Archive One Package that updates the msc_item_pkg table. Although it could be a data volume issue, it appears to be some sort of design change or missing index.

Concurrent program: Archive One Package
Parameters: msc_item_pkg, [plan_id], [plan_run_id]
Database Package:
msc_item_pkg.populate_details (Line 1327)


EXPECTED BEHAVIOR
-----------------------
Improvement in Plan Archive Summary performance

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Responsibility > Advanced Supply Chain Planner.
2. Run a Plan
3. The Archive Plan summary runs at the end integrating with APCC and takes a long time


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