Bank Statements MT940 transaction code (Doc ID 1426633.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Cash Management - Version 12.1.2 and later
Information in this document applies to any platform.

Goal


When using (How To Create New Bank Statement Mapping Template To Requirement, Latest Patch [ID 563476.1]) to map the MT940 file , while uploading the bank Statements application is not capturing the right transaction code

For example the below line, which is showing the TRX_CODE as (NMSC)

:61:1111011101C31719,00NMSCNONREF//0171 ECC0001506 REGULARCLEARING

After uploading the application is showing the TRX_CODE as (MSCC) and also is not showing the value date ,using the below mapping table


HEADER
Column Name Rec id Position Format
STATEMENT_NUMBER 28 1
BANK_ACCOUNT_NUM 25 1
CONTROL_BEGIN_BALANCE 60 5
STATEMENT_DATE 62 3
CURRENCY_CODE 60 4
CONTROL_END_BALANCE 62 5

LINES
Column Name Rec id Position Format
TRX_DATE 61 1
BANK_ACCOUNT_TEXT 61 9
AMOUNT 61 5
CUSTOMER_TEXT 61 1
BANK_TRX_NUMBER 61A 7
TRX_TEXT 61A 1
TRX_CODE 61 6
CURRENCY_CODE 61A 1
Exchange_Rate 61A 1
INVOICE_TEXT 61A 1
ORIGINAL_AMOUNT 61A 1
CHARGES_AMOUNT 61A 1

From the attached file (page 80) the application should show the transaction code as NMSC (When the first character of subfield 6 Transaction Type Identification Code is 'N' or 'F', the remaining characters may contain one of the following codes)


Solution

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