My Oracle Support Banner

Bank Statements MT940 transaction code (Doc ID 1426633.1)

Last updated on JUNE 28, 2019

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)

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

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
Goal
Solution
 Patch Wizard
 Have more questions?


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