R12 CE: SWIFT940 Format File Loading from Bank Completes With A Warning

Last updated on DECEMBER 13, 2017

Applies to:

Symptoms

On : 12.1.2 version, Bank Statement Load and Import

When attempting to load bank statement with SWIFT940 format, the process completes but the concurrent ends with warning:

ERROR
-----------------------

Table "CE"."CE_STMT_INT_TMP", loaded when REC_ID_NO = 0X3a3230(character ':20')
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect

SQL string for column : "replace(decode(:column2, 'D', '-'||:column5, :column5), ',', '.') "

Table "CE"."CE_STMT_INT_TMP", loaded when REC_ID_NO = 0X3a3634(character ':64')
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect

Record 7: Discarded - failed all WHEN clauses.
Record 14: Discarded - failed all WHEN clauses.

Table "CE"."CE_STMT_INT_TMP":
 102 Rows successfully loaded.
 0 Rows not loaded due to data errors.
 736 Rows not loaded because all WHEN clauses were failed.
 0 Rows not loaded because all fields were null.

Changes

 Customer applied patch 24508234:R12.CE.B

Cause