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.
Symptoms
Import Bank Statement is unable to process multiple Banks and Bank Accounts on the same Bank Statement for Layout = MT940. A warning occurs:
WARNING
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
:25:
Account Identification
[BIC]/[IAccNr]
STEPS
1. Load a MT940 Bank Statement file where the 25 tag will be formatted as follows:
:25:300002/00111174
2. Run Import Bank Statement with the following criteria:
Layout = MT940
Layout Properties
CODE_MAP_GROUP = SWIFT
SWIFT_BIC is left blank
SWIFT_HEADER = N
3. Process will complete with the above warning
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 |