My Oracle Support Banner

The "Planning ODS Load Worker" Programs Results In Timeout Error. (Doc ID 2325102.1)

Last updated on AUGUST 17, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.4 version, Data Collections

The "Planning ODS Load worker" programs result in Timeout error
 (Timeout parameter is set to 180 mins).

Problem query is run for each item but the item value is not provided as bind variable.

 This leads to the same query executed for 2 different items as 2 different queries leading to deterioration in performance.

Passing in the item value as bind variable may lead to improvement in performance.

This has become a critical issue for us as Collections has been failing very often.

1. Launch Data Collections
2. Find Item Suppliers collected slowly


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.