My Oracle Support Banner

TBAML ECM Batch Error At Task 28 (Doc ID 2820200.1)

Last updated on NOVEMBER 14, 2021

Applies to:

Oracle Financial Services Trade-Based Anti Money Laundering Enterprise Edition - Version 8.0.7 and later
Information in this document applies to any platform.


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(
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(




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.