Archive Plan Summary / Archive One Package Concurrent Performance Issue During MSC_ITEM_PKG Updates
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]
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
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