My Oracle Support Banner

MSCPDCW - Planning ODS Loader Worker - Log Shows Long Time For Operation - Procedure MSC_CL_ROUTING_ODS_LOAD.LOAD_ROUTING_OPERATIONS started. (Doc ID 2988753.1)

Last updated on NOVEMBER 26, 2023

Applies to:

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

Symptoms

There is a performance issue seen in log for Planning ODS Loader Worker - a Child program of Planning ODS Load.

Most of the time is consumed for procedure MSC_CL_ROUTING_ODS_LOAD.LOAD_ROUTING_OPERATIONS.

Example : Entire Planning ODS Load took 45 minutes while the procedure MSC_CL_ROUTING_ODS_LOAD.LOAD_ROUTING_OPERATIONS took around 35 minutes.

Log shows

MSCPDCW: Planning ODS Load Worker
+---------------------------------------------------------------------------+

.....

17-MAR 00:48:57 : Procedure MSC_CL_ROUTING_ODS_LOAD.LOAD_ROUTING_OPERATIONS started.
17-MAR 01:02:08 : routing operations loaded
17-MAR 01:02:08 : Procedure alter_temp_table started.
17-MAR 01:02:08 : MSC_CL_EXCHANGE_PARTTBL.Initialize successful
17-MAR 01:02:08 : Profile value of MSC_REGEN_STATS: 1
17-MAR 01:02:08 : v_temp_tbl_ct: 1
17-MAR 01:11:36 : Alter index: ALTER INDEX MSC."ROUTING_OPERATIONS_U1_DEP" LOGGING
17-MAR 01:11:36 : UNIQUE index creation on temporary table ROUTING_OPERATIONS_DEP has completed with SUCCESS.
17-MAR 01:18:32 : Alter index: ALTER INDEX MSC."ROUTING_OPERATIONS_N2_DEP" LOGGING
17-MAR 01:24:13 : Alter index: ALTER INDEX MSC."ROUTING_OPERATIONS_N1_DEP" LOGGING
17-MAR 01:24:14 : NONUNIQUE index creation on temporary table ROUTING_OPERATIONS_DEP has completed with SUCCESS.
17-MAR 01:24:14 : End alter_temp_table
17-MAR 01:24:14 : 35.3 minutes elapsed.

  

Launch Planning Data Collection request set from Advanced Supply Chain Planner (R) / Collection / Oracle Systems / Standard Collection and observe the timing for the requests and check the log files

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.