Memory Based Snapshot Running Long On INSERT INTO MSC_SUBST_CUR_TEMP (SQL ID: 237FVJZCZRTS8 )
(Doc ID 3037485.1)
Last updated on JULY 26, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and laterInformation in this document applies to any platform.
Symptoms
Running the MSCNSPWL64 module: Memory Based Snapshot 64 bit Linux, the following SQL is taking a long time to complete for the following SQL ID: 237FVJZCZRTS8
The expectation is that the Memory Based Snapshot program should be more efficient running the above SQL.
The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain Planner
2. Navigation: Supply Chain Plan > Launch
3. Enter the necessary parameters to run the plan
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 |