The "Planning ODS Load Worker" Programs Results In Timeout Error.
(Doc ID 2325102.1)
Last updated on APRIL 04, 2025
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.
Symptoms
On : 12.2.4 version, Data Collections
ACTUAL BEHAVIOR
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.
STEPS
1. Launch Data Collections
2. Find Item Suppliers collected slowly
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 |