My Oracle Support Banner

CS-ECM Batch Fail At Correlation Task (Doc ID 2738393.1)

Last updated on DECEMBER 21, 2020

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.


On : 8.0.7 version, Web UI

CS-ECM batch fail at correlation task

Hi team,

It is failing in one task (task 42) DT_Correlation 

Batch Name is:::ORACLECS
java.sql.SQLException: ORA-20007: ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575
--> ORA-00922: missing or invalid option
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 687
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 2223
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(
at oracle.jdbc.driver.T4CTTIoer11.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(
at com.ofss.ecm.corelation.execution.InitiateCorelation.preExecution(
at com.ofss.ecm.corelation.execution.InitiateCorelation.main(
Caused by: Error : 20007, Position : 0, Sql = BEGIN pkg_correlation.proc_corr_init (:1 ,:2 ,:3 ,:4 ); END;, OriginalSql = {call pkg_correlation.proc_corr_init (?,?,?,?)}, Error Msg = ORA-20007: ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575
ORA-06512: at "BADR_ATOM.PKG_CORRELATION", line 575


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.