MSCNSW & MSCSDW: Huge Performance issues with Memory Based Snapshot Worker and Snapshot Delete Workers

(Doc ID 1473026.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.


On : 12.1.3 version, Engine Comp for Oracle RiskOpt

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.

Expect the snapshot process resolves the loops quickly and the plan run times are lesser.

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.


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