The "Planning ODS Load Worker" Programs Results In Timeout Error.

(Doc ID 2325102.1)

Last updated on NOVEMBER 06, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
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.

EXPECTED BEHAVIOR
Expect the problem procedure to perform properly with bind variable reference

STEPS
The issue can be reproduced at will with the following steps:
1. Launch Data Collections
2. Find Item Suppliers collected slowly

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, all downstream processes are impacted and waiting for collection to complete so users may get into their workbench and complete their job.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms