My Oracle Support Banner

MSCNSW & MSCSDW: Huge Performance issues with Memory Based Snapshot Worker and Snapshot Delete Workers (Doc ID 1473026.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.