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 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.


On : 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)

The log file shows:

 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


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.


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