R12: CM: Swift940 Data Files Load Statement Fails With Multibyte Character Error
(Doc ID 1271209.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Cash Management - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]Information in this document applies to any platform.
Symptoms
When attempting to run SQL*Loader- SWIFT940 for a flat file,the following error occurs:
Log File shows the following errors:
-------------------------------------
CESLRPROSWIFT940 module: Run SQL*Loader- SWIFT940
Table "CE"."CE_STMT_INT_TMP", loaded when REC_ID_NO = 0X3a3230(character ':20')
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
REC_NO RECNUM
REC_ID_NO 1:3 3 WHT CHARACTER
SQL string for column : "ltrim(:rec_id_no, ':')"
COLUMN1 5:85 81 CHARACTER
Table "CE"."CE_STMT_INT_TMP", loaded when REC_ID_NO = 0X3a3231(character ':21')
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect
Record 671: Rejected - Error on table "CE"."CE_STMT_INT_TMP", column COLUMN1. Multibyte character error.
Table "CE"."CE_STMT_INT_TMP":
Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |