TBAML ECM Batch Error At Task 28
(Doc ID 2820200.1)
Last updated on MAY 12, 2023
Applies to:
Oracle Financial Services Trade-Based Anti Money Laundering Enterprise Edition - Version 8.0.7 and laterInformation in this document applies to any platform.
Symptoms
TBAML ECM batch error at task 28.
-----------------------------------------------
We see below error in task log (fccdm_FCCMINFO_1628509971108_20210605_1Task28)
Query to get Runskey>>select N_RUN_SKEY from FCC_BATCH_RUN where V_BATCH_RUN_ID = ?
setString(1, FCCMINFO_1628509971108_20210605_1)
2021/09/09 17:31:03:::runskey::7064
2021/09/09 17:31:03:::filters::"$RUNSKEY"="7064"[]"$MISDATE"="to_date(^20210605^,^yyyyMMdd^)"
2021/09/09 17:31:03:::sql:::{call PKG_FCC_DM.FccDMSameDBSchemaDI(?, ?, ?)}
2021/09/09 17:31:03:::dataMovementCode::TBAML_EVENT_ENTITY_MAP_DCCEE::runskey::7064::filters::"$RUNSKEY"="7064"[]"$MISDATE"="to_date(^20210605^,^yyyyMMdd^)"
java.sql.SQLException: ORA-20111: Insert into final target table failed
ORA-06512: at "OFSAAFCCM.PKG_FCC_DM", line 526
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |