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

Last updated on OCTOBER 21, 2015

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."

 

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

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