R11i&R12:CE: Error "Rows Not Loaded Because All WHEN Clauses Were Failed" In CESLRPROSWIFT940 (Doc ID 2253942.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Cash Management - Version 11.5.10.2 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Bank Statement Load and Import

When attempting to run SQL*Loader- SWIFT940,
the following error occurs.


 Rows not loaded because all WHEN clauses were failed.

The issue can be reproduced at will with the following steps:

1. Responsibility: Cash Management
Production and Test instances
This issue is occurring in R12 & 11i both instances.

2. Path: Other -> Requests -> Run
3. Run SQL*Loader- SWIFT940 (CESLRPROSWIFT940)
Arguments
/u02a/esapascomn/temp//17439_2017.04.10_MT940IRDE.dat

The log file shows:

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

Total logical records skipped: 0
Total logical records read: 157
Total logical records rejected: 0
Total logical records discarded: 3

WORKAROUND: None

The issue has the following business impact:
Due to this issue, users cannot load the transactions.

The users need to load statements at the earliest.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms