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

Last updated on JULY 02, 2023

Applies to:

Symptoms

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.
IS_MONITOR_STATUS_RUNNING
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.


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

BUSINESS IMPACT
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.

ORGANIZATION_ID ORG CALENDAR_C MIN(BCD.C MAX(BCD.C
--------------- --- ---------- --------- ---------
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

Changes

Cause

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