R12 CE: SWIFT940 Format File Loading from Bank Completes With A Warning (Doc ID 2337319.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Cash Management - Version 12.1.2 and later
Information in this document applies to any platform.

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.