My Oracle Support Banner

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 later
Information 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


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