ECM: Import Bank Statement issue with multiple Banks and Bank Accounts using MT940
Last updated on MARCH 09, 2017
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
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
CODE_MAP_GROUP = SWIFT
SWIFT_BIC is left blank
SWIFT_HEADER = N
3. Process will complete with the above warning
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 hundreds of Community platforms