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

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.

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

Cause

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