How to modify the bank statement file from the bank for automatic processing of bank statement?

Summary:

We will need to process the bank statement file from the bank automatically in oracle cloud.

Content (required):

Hi Experts,

We are using ISO20022 MX CAMT053.001.02 Format and Process Electronic Bank Statement program to extract and import the file from the bank to oracle cloud. Then run Load and Import Bank Statement program to process the bank statement in Cash Management.

The Load and Import Bank Statement resulting in error with invalid bank account number. Upon checking the file from the bank has this format in bank account number Example values only ( 09 - bank code + 1004 - branch code + 123456 - bank account number + 20 -suffix)