Bank Statements MT940 transaction code (Doc ID 1426633.1)

Last updated on JULY 19, 2022

Applies to:

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)

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

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.