Memory Based Snapshot Running Longer For Constrained And Uncontrained Plans (Doc ID 2286625.1)

Last updated on JULY 14, 2017

Applies to:

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

Symptoms

On : 12.2.5.1 version, Memory Based Planner in PROD:

After applying patch Mandatory 12.2.5 VCP Consolidated Patch 2 for R12.SCP_PF.C.Delta.6 (22493520) + VCP Cumulative Update Patch #6 (25515083) the performance of the Memory Based Snapshot is taking longer to complete.- currently using 64 bit Linux Snapshot MSCNPL64.ppc 120.11.12020000.19.1220500.13 from one off patch 25515083 - this is CUM patch #6 on 12.2.5.

Details
=======
A. Most recent - Snapshot worker Unconstrained plan - no loops
MSCNSWWL64 module: Memory Based Snapshot Worker 64 bit Linux
Selecting BOD 1,204,643 48:07

B. Most recent - Snapshot worker Constrained plan - no loops
MSCNSWWL64 module: Memory Based Snapshot Worker 64 bit Linux
Selecting BOD 1,204,643 21:56

C. Trace file indicates problem SQL:

SQL ID: 40zgn141sg8dy Plan Hash: 2840343645

select uom_code ,NVL(full_pegging,2) into :b0,:b1
from msc_system_items where (((organization_id=:b2 and sr_instance_id=:b3) and
 inventory_item_id=:b4) and plan_id=:b5)

EXPECTED BEHAVIOR
-----------------------
Expected Unconstrained plan to be done with Snapshot concurrent requests in 20 minutes and 10 minutes for Constrained plan

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (R) Advanced Supply Chain Planner
2. (N) Supply Chain Plan / Names
3. Query the Plan and click launch

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