ODS Load performance issue with repetitive load supply: not found for loading Item and Supplies data only by legacy collection. (Doc ID 2120610.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.8 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.9.1 VCP version, Data Collections ODS Load taking over 7 hours for loading Item and Supplies data only during legacy collection.

Planning ODS Load Worker log file takes hours for following:

load_supply: upd OH
Load supply: not found:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ASCP>Collections>Legacy



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