My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.