Continuous Data Collection errors with Planning ODS Load process failed when waited for workers' acknowledgment of COMMIT

(Doc ID 2307439.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

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

Symptoms

On : 12.2.6.2 version, Data Collections, Continuous Collections

While running Continuous Collections,

The request MSCAUTP: Continuous Collections completes with the error as given below:

06-SEP 10:21:44 : Planning ODS Load process failed when waited for workers'
acknowledgment of COMMIT.
06-SEP 10:21:44 : ORA-0000: normal, successful completion
06-SEP 10:21:44 : Please check the log files of Planning ODS Load Workers.

Also  the request MSCAUTPW: Continuous Collection Workers contains the message 'Planning ODS Load process failed.'. No other error messages.

It was also seen that there is no issues in RAC set up.

 

Cause

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