My Oracle Support Banner

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

Last updated on DECEMBER 13, 2017

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.



Changes

 Customer applied patch 24508234:R12.CE.B

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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