My Oracle Support Banner

Bank Statement Loader Logfile Showing Rows Not Loaded Because All WHEN Clauses Were Failed (Doc ID 2020243.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

 Explain the message in the Log File of the CESLRPROBAI2 module: Run SQL*Loader- BAI2 program. 

 The Program run successfully, and loads all the Data into the Interface tables but shows the message "Rows not loaded because all WHEN clauses were failed."

 

Example: CESLRPROBAI2 module: Run SQL*Loader- BAI2

BANK STATEMENT LOADER LOG SHOWING ROWS NOT LOADED BECAUSE ALL WHEN CLAUSE

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

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

 

 

 

Solution

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
Goal
Solution
References


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