Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ISO20022 CAMT53 Bank Statement load and Import

User_B2NBHMay 31 2022

Full file log.txt (3.45 KB)Hello!

We trying to load a bank statement file in ISO20022 CAMT53 standard but it does not load and throws an error as below.

This is what we did:

1. Created a sample ISO20022 CAMT053 format bank statement file.

2. Run the ‘Load interface file for Import’ with parameter as ‘ISO20022 file format’

3. Choose the file from local directory

4. Submit the program.

This is the error we get(Attached log has details)

ISOLoaderAMImpl::load --> Number of header nodes for statement interface = 0

ISOLoaderAMImpl::load --> Parsing Error! There are no statements to load. Check the file format.

ISOLoaderAMImpl::load --> EXCEPTION while processing ISO file: JBO-CE:::CE_BS_FILE_PARSE_ERROR: <MESSAGE><NUMBER>CE-660228</NUMBER><TEXT>An error occurred while processing the data file. Check the log file, purge the error, correct the data file, and reprocess it.</TEXT><CAUSE></CAUSE><ACTION></ACTION><DETAILS></DETAILS><INCIDENT></INCIDENT></MESSAGE>

There is no specific error saying this line has the error.

Attached are the log and dat file.

Devadas

Comments
Post Details
Added on May 31 2022
2 comments
1,312 views