MSCNSW & MSCSDW: Huge Performance issues with Memory Based Snapshot Worker and Snapshot Delete Workers
(Doc ID 1473026.1)
Last updated on MAY 02, 2023
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.1 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Engine Comp for Oracle RiskOpt
ACTUAL BEHAVIOR
---------------
When running a DRP or a Manufacturing Plan, the plan takes huge time to complete.
The Planning process gets stuck at the Memory Based Snapshot Worker and Snapshot Delete Worker for a very long time.
The log file of the Memory Based Snapshots indicate too many loops in BOM which are part of the business process and cannot be avoided.
The Snapshot process is taking huge time to resolve these loops.
EXPECTED BEHAVIOR
-----------------------
Expect the snapshot process resolves the loops quickly and the plan run times are lesser.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Application.
2. Run ASCP Plan.
NAV: Advanced Supply Chain Planner (R) -> Supply Chain Plan -> Launch
3. Review the plan results.
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 |