Planning ODS Load Takes A Long Time In MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT (Doc ID 1594361.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Goal

ODS load fails randomly.
ODS load log reports:

user defined exception.


ODS load worker logs report "timeout" as follows:

10-OCT 16:04:52 : Waiting for task to arrive
10-OCT 16:58:34 : IS_MONITOR_STATUS_RUNNING
10-OCT 16:58:34 : Concurrent Message : Timeout error.
10-OCT 16:58:34 : There is an Unknown Error in the Worker.
10-OCT 16:58:34 : Planning ODS Load process failed.

 

After we increased the timeout parameter for the ODS Load and resolved timeout error, we noticed that log file showed long time in MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT
There is not direct message but timestamps shows this taking over 45 mins to complete.

Main ODS Load Log file shows
20-OCT 23:42:47 : exchange part:-ALTER TABLE MSC_REGIONS EXCHANGE PARTITION REGIONS__1 WITH TABLE REGIONS_BEB INCLUDING INDEXES
20-OCT 23:42:50 : Calling Linking of Sales Order for 11i source ...
20-OCT 23:42:50 : Procedure MSC_CL_DEMAND_ODS_LOAD.LINK_SUPP_SO_DEMAND_EXT started.
21-OCT 00:33:24 : .. In procedure GET_START_END_OP ..
Procedure LOAD_SOURCING_HISTORY started.
,7 minutes elapsed.

Solution

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