Collections Fails With Planning ODS Load Process Failed When Waited For Workers ORA-0000

(Doc ID 1293236.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

In RAC environment,when running collections the ODS load fails with the error below:

MSCPDC module: Planning ODS Load

All Workers have completed.
Planning ODS Load process failed when waited for workers' acknowledgment of COMMIT.
ORA-0000: normal, successful completion
Please check the log files of Planning ODS Load Workers.
Truncated Source AD Tables Successfully

One of the ODS Load Workers has the below error message

Purge Batch Size is set to : .
dp enabled orgs present
User-Defined Exception
Sending message :-9999999 to monitor.


STEPS
1. Navigate to Advanced Supply Chain Planning > Collections > Collect From Oracle Systems > Standard Collections
2. Launch the data collections
3. See that ODS process fails with the said error

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