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 AUGUST 21, 2020

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

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.