My Oracle Support Banner

ECM: MT940 - Bank Statement Import Sets RECON_TRANS_CODE to Blank (Doc ID 1913722.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


MT940 line which has the following:
61:140129CD123456,47NTRFNONREF//S0640291AAAAAAB/O FIRST CO.

Bank Statement Import expects the transaction date to follow the value date '140129' and is 4 characters long.

For this example, the bank statement line will have VALUE_DT as 01/29/2014, but RECON_TRANS_DT will be blank.  As a result Bank Statement Accounting will not create external transactions.


1. Navigate to Banking > Bank Statements > Import Bank Statements, and load MT940 bank statement file
2. Navigate to Banking > Reconcile Statements > Automatic Reconciliation, and run Automatic Bank Reconciliation
3. Navigate to Banking > Reconcile Statements > Process Statement Accounting, and run Bank Statement Accounting




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

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