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 MAY 02, 2023

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.


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

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