My Oracle Support Banner

ECM: Import Bank Statement issue with multiple Banks and Bank Accounts using MT940 (Doc ID 1613624.1)

Last updated on JULY 20, 2020

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.


Import Bank Statement is unable to process multiple Banks and Bank Accounts on the same Bank Statement for Layout = MT940.  A warning occurs:

Could not determine Bank ID (9450,142) TR_FORMAT.BankStatement.SWIFTFormatter.OnExecute Name:format_str PCPC:7632 Statement:160
Called from:BS_SWIFT_XFM.MAIN.GBL.default.1900-01-01.Step01.OnExecute Statement:39 (0,0)

Currently, when trying to load a Bank Statement for Layout = MT940, Import Bank Statement expects to receive a separate file and Run Control ID for each Bank being loaded. However, have a setup that has 100+ Banks, using 150+ different Bank ID/BICs. It is impossible to run the process over 150 times a day, 5 days a week.

As a fix, the Banks have agreed to provide the Bank ID/BIC as well as the Bank Account Number on the 25 tag using the below format, which will allow multiple banks to be loaded in a single file.

Tag/ Field name
Account Identification

1. Load a MT940 Bank Statement file where the 25 tag will be formatted as follows:


2. Run Import Bank Statement with the following criteria:

Layout = MT940
Layout Properties
SWIFT_BIC is left blank

3. Process will complete with the above warning




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.