My Oracle Support Banner

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

Last updated on MAY 09, 2018

Applies to:

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


On : 12.2.3 version, Performance

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)

Improvement in Plan Archive Summary performance

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


To view full details, 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 a vibrant support community of peers and Oracle experts.