My Oracle Support Banner

Collections Fails With Planning ODS Load Process Failed When Waited For Workers ORA-0000 (Doc ID 1293236.1)

Last updated on MARCH 26, 2024

Applies to:

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


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.

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


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.