My Oracle Support Banner

Poor Performance Of Memory Based Snapshot While Snapshotting Demand Schedule Items For Forecasts (Doc ID 2997009.1)

Last updated on JANUARY 10, 2024

Applies to:

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

Symptoms

While running an ASCP Plan from following navigation Advanced Supply Chain Planner (R) -> Supply Chain Plan -> Launch -> Enter the parameters appropriately and click submit, Memory Based Snapshot request is taking 200 mins for completion.

Log file shows the following message indicating that snapshot of demand schedule items for forecasts is taking majority of the time:

SCHEDULE_ITEMS_CUR8
Demand Schedule Items COUNTER = 7
....Selecting Demand Schedule Items (by Type) 2,453 188:15

 
Subsequently, trace file indicates the following query is running longer:

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


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