My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.