Collections Fails With Planning ODS Load Process Failed When Waited For Workers ORA-0000
(Doc ID 1293236.1)
Last updated on OCTOBER 25, 2021
Applies to:Oracle Advanced Supply Chain Planning - Version 22.214.171.124 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
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