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

Last updated on SEPTEMBER 09, 2016

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

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