My Oracle Support Banner

R12: CE: When Try To Upload The Bank Statement SWIFT MT940 File Into Oracle, Partially Loaded and Maximum Records Are Not Getting Loaded Into CE_STMT_INT_TMP. (Doc ID 2930365.1)

Last updated on FEBRUARY 24, 2023

Applies to:

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

Symptoms

 Bank Statement MT940 File, All Records Are Not Getting Loaded Into CE_STMT_INT_TMP - Loaded Successfully till 50 Records, Then Ignored Remaining.

Observe that many MT940 statements are not getting loaded. It seems either it is partially loading or not loading any statement lines.

ERROR
-----------------------
Rejected - Error on table "CE"."CE_STMT_INT_TMP#"
Record 70: Rejected - Error on table "CE"."CE_STMT_INT_TMP#", column COLUMN1.
Multibyte character error.

Record 71: Rejected - Error on table "CE"."CE_STMT_INT_TMP#", column COLUMN1.
Multibyte character error.

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

 The issue can be reproduced at will with the following steps:

1. Run the Bank Statement Loader Program.

2. Select the parameters of Path which means file location and File Name which means received from Bank.

3. Identify the Error details in the Log file of the program.

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.