Continuous Data Collection Error "Planning ODS Load Process Failed When Waited For Workers Commit"

(Doc ID 2017810.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

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
 

Solution

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