The Process 'Msddempst Module: Populate Staging Table' Is Taking A Long Time on Parameter Eq_sales_tmp (Doc ID 1271495.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

 

The Populate Staging Table subprocess in Shipment and Booking History is taking a long time.

The steps to replicate are:

1) Access Demand Management System Administrator
2) Access Collections > Oracle Systems > Shipment and Booking History
3) Some of the parameters provided are:
---Instance = GIS
---Collection Group = All
---Collection Method= Complete
---History Collection Window = 30
4) execute the process Shipment and Booking History and one subprocess called 'Populate Staging Table' was launched but never finishes

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