My Oracle Support Banner

MSCPDCW - Planning ODS Load Program Completes With Timeout Error (Doc ID 375345.1)

Last updated on JULY 02, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
MSCPDCW module: Planning ODS Load Worker


On 11.5.9 in Production:
When attempting to run Data Collections, the following error occurs:

Linking of Sales Order line to its Parent Sales orders is successful.....
176.6 minutes elapsed.
The Request id : 267646 has Phase : COMPLETE and Status: ERROR
Concurrent Message : Timeout error.
There is an Unknown Error in the Worker.
Planning ODS Load process failed.

The issue can be reproduced at will with the following steps:
Launch Collections as normally done
The Planning ODS Load Workers all fail

The issue has the following business impact:
Due to this issue, users cannot complete data collections and complete a plan for the users

Verified the issue in the log file as noted below:
The logfiles provided all show the workers in error with the timeout message

Calendar details shows there is 1.5 years until the end of the calendars for most orgs.                                                            Today's date being Jul 1 2006.

--------------- --- ---------- --------- ---------
118 000 XXX STD 29-DEC-03 04-JAN-08
119 050 050 CLNDR 29-DEC-03 31-DEC-07
120 051 051 CLNDR 29-DEC-03 31-DEC-07
121 344 XXX STD 29-DEC-03 04-JAN-08
122 457 456 CLNDR 27-DEC-04 29-DEC-08
123 052 052 CLNDR 29-DEC-03 31-DEC-07
125 234 234 CLNDR 27-DEC-04 05-JAN-09
126 065 065 CLNDR 27-DEC-04 29-DEC-08
127 XSQ XXX STD 29-DEC-03 04-JAN-08
128 580 XXX STD 29-DEC-03 04-JAN-08
129 087 087 CLNDR 27-DEC-04 29-DEC-08

This is too short a timeframe and should be extended 9-10 years from the plan end date ..approx
2017 in this case




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

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