Bank Statement Open Interface
Before you can reconcile transactions against a bank statement, you need to enter the bank statement information into Cash Management. If your bank provides account statements in a flat file, using a defined format like BAI or SWIFT940, you can use the Bank Statement Open Interface to load this information into Cash Management.
To use Bank Statement Open Interface:
1. Create an import program to map the structure of the bank statement file to the Cash Management bank statement open interface tables.
- You must develop a separate import program for each unique bank statement file structure.
- Import programs are generally developed by your System Administrator or an Oracle consultant.
- Import programs are usually written in SQL*Loader. However, depending on the complexity of a bank file, you might choose to use one of a variety of other programming languages.
Note: Cash Management documentation refers to the import program as a SQL*Loader script.
2. Use your SQL*Loader scripts whenever needed to populate the bank statement open interface tables (see below).
Bank Statement
Open Interface
Tables
The Bank Statement Open Interface consists of two bank statement open interface tables:
- Bank Statement Headers Interface Table--contains the bank statement header information. The table is named CE_STATEMENT_HEADERS_INT_ALL.
- Bank Statement Lines Interface Table--contains the bank statement transaction lines. The table is named CE_STATEMENT_LINES_INTERFACE.
Note: Once you run your SQL*Loader script to populate the open interface tables, you can use Cash Management's AutoReconciliation Import program to validate and transfer the bank statement information into the Cash Management bank statement tables for reconciliation. The bank statement tables are named CE_STATEMENT_HEADERS_ALL and CE_STATEMENT_LINES. Once the information in the interface tables has been successfully transferred to the bank statement tables, you can purge the interface tables.
See Also
Bank Statement Headers Interface Table
Bank Statement Lines Interface Table
Loading Bank Statement Open Interface
Bank Statement Validation
Importing Bank Statements
Correcting Bank Statement Interface Errors
Reconciling Bank Statements Automatically
System Parameters
Archiving and Purging Imported Bank Statements