Collections Fails With Planning ODS Load Process Failed When Waited For Workers ORA-0000
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 and later
Information in this document applies to any platform.
In RAC environment,when running collections the ODS load fails with the error below:
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
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
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