Bank statements import and reconciliation in EBS Oracle

As you may know, bank statements manual input and reconciliation is a demanding task.
You won’t have to bother anymore after setting up bank statements import and reconciliation.

This example uses EBS Oracle 12.0.6. and the file format imported is SWIFT MT940.

Here are a few steps to setup and submit the actual request for

bank statement import.

Using a Cash Management responsibility navigate to:

Setup -> Bank Statements -> Bank Statement Transaction Codes

You have to set the transaction codes for receipts to TRFC, for Payments to TRFD, for miscelaneous payments to COMD, as those are the codes used by Oracle in its standard implementation for SWIFT940 format.

To set up the bank statement mappings go to:

Setup -> Bank Statements -> Bank Statement Mappings

Create a new mapping based on SWIFT940.ctl control file. This must be customized in order to map to your bank statement format, for example specifying a word used in all transaction lines. In my example this word is “Numar”.

After this, all you have to do is to load your file on the Oracle server (path will be specified in the Directory Path field on the request) and submit the request.

Notice that the Mapping Name is the name of the mapping created previously.

Oracle also supports BAI format for import.

Tip: check patch nr. 8965556

SWIFT format

http://martin.hinner.info/bankconvert/swift_mt940_942.pdf

http://www.csob.cz/WebCsob/Firmy/Korporace-Instituce/w1se/w1se_MT940_en.pdf

BAI format

https://businessonline.huntington.com/common/cms/help/BAI1Technical%20Ref%20Manual.pdf

Finally, there’s another very important peculiarity of what does Cialis that brings it so high above its alternatives. It is the only med that is available in two versions – one intended for use on as-needed basis and one intended for daily use. As you might know, Viagra and Levitra only come in the latter of these two forms and should be consumed shortly before expected sexual activity to ensure best effect. Daily Cialis, in its turn, contains low doses of Tadalafil, which allows to build its concentration up in your system gradually over time and maintain it on acceptable levels, which, consequently, makes it possible for you to enjoy sex at any moment without having to time it.