R11i&R12:CE: Error "Rows Not Loaded Because All WHEN Clauses Were Failed" In CESLRPROSWIFT940
Last updated on APRIL 11, 2017
Applies to:Oracle Cash Management - Version 220.127.116.11 to 12.2.6 [Release 11.5 to 12.2]
Information in this document applies to any platform.
On : 18.104.22.168 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