1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Account Reconciliation Data
  4. Integrating BAI, SWIFT MT940 or CAMT.053 Format Bank File Transactions and Balances

Integrating BAI, SWIFT MT940 or CAMT.053 Format Bank File Transactions and Balances

As an integration mechanism, Data Management provides an adapter-based framework that enables Account Reconciliation customers to:

  • add a Bank file as a source system (identified with an application type "Data Source").

  • associate either a BAI format bank file (which uses a Bank Administration Institute file format) or a SWIFT MT940 format bank file (which uses a SWIFT MT940 file format) or CAMT.053 (which is a "Bank to Customer" file in XML format), and then stage transactions to be loaded to an Account Reconciliation target application.

    Specific Data Management functions, such adding locations and member mappings, are handled using the standard Data Management workflow process. The loading of the data is also executed in Data Management.

  • associate either a BAI format bank file (which uses a Bank Administration Institute file format), SWIFT MT940 format bank file, or a CAMT.053 file with the Bank File source system, and then stage balances to be loaded to an Account Reconciliation target application. Balances are end of day bank balances either posted once a month or on a daily basis.

    Specific Data Management functions, such adding locations and member mappings, are handled using the standard Data Management workflow process. The loading of the data is also executed in Data Management.

  • add a target application for each Transaction Matching data source as needed, and then map the dimensions from a file-based source system (including a BAI file, SWIFT MT940 file or CAMT.053 file) to the Transaction Matching target application in the import format. In this way a customer can easily import data from any source system by way of a file format and push it to a Transaction Matching target application. Specific Data Management functions, such adding locations and member mappings, are handled using the standard Data Management workflow process.

    When creating a target application for Transaction Matching, in the Import Format, select Amount field from the target application instead of Data to load data correctly.