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

Integrating BAI and SWIFT MT940 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) with the Bank File source system, 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) or a SWIFT MT940 format bank file (which uses a SWIFTMT940 file format) 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 or SWIFTMT940 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.