My Oracle Support Banner

Continuous Data Collection Error "Planning ODS Load Process Failed When Waited For Workers Commit" (Doc ID 2017810.1)

Last updated on SEPTEMBER 22, 2021

Applies to:

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


When running Continuous data collection form planning server , the request ' Continuous data collection ' ended with error as below :-

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.

- although the Continues data collection request ended with error , all of Continuous Collection Workers requests ended normally
- by checking some data after the data collection , the onhand data was updated by the collection end date, which means the process worked as expected
- this issue is on the Production environment , we are collecting the onhand data through continues data collection every 2 hours


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.