Failure Of Task 50 In Oracle_KYC_Event_Processing (ECM )batch Of 8.0.8 Version (Doc ID 2834782.1)

Last updated on JANUARY 25, 2022

Applies to:

Symptoms

Executing the batch Oracle_KYC_Event_Processing , but the batch got failed at the Task 50 .

LOG FILE

-----------------------
Filename = correlationFCCMINFO_1642360346924_20220110_1Task50
See the following error:

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

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4274)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at com.ofss.ecm.corelation.execution.InitiateCorelation.preExecution(InitiateCorelation.java:180)
at com.ofss.ecm.corelation.execution.InitiateCorelation.main(InitiateCorelation.java:113)
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 "FCCMATOM.PKG_CORRELATION", line 575
ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 575
--> ORA-00922: missing or invalid option
ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 687
ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 2223
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 19 more
Exception in thread "main" java.sql.SQLException: ORA-20007: ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 575
ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 575
--> ORA-00922: missing or invalid option
ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 687
ORA-06512: at "FCCMATOM.PKG_CORRELATION", line 2223
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)

Changes

Cause

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