Cash Management Reconciliation

1) Run the program- Bank Statement Loader to load data in following Open Interface tables

CE_STATEMENT_HEADERS_INT_ALL (Stores Information about bank statement Header details)
CE_STATEMENT_LINES_INTERFACE (Stores Information about bank statement Line details)

2) Run the program- Bank Statement Import to load data in following Base tables from Interface tables.

CE_STATEMENT_HEADERS
CE_STATEMENT_LINES

3) Error information is stored in following tables while running Bank Statement Import

CE_HEADER_INTERFACE_ERRORS
CE_LINE_INTERFACE_ERRORS

4) Run the program- AutoReconciliation which in turn calls AutoReconciliation Execution Report (CEXINERR)
(AutoReconciliation --> CE_AUTO_BANK_REC.statement --> CE_AUTO_BANK_MATCH.match_process)

5) Error information is stored in following table while running AutoReconciliation Program

CE_RECONCILIATION_ERRORS

6) Reconciliation history or audit trail is stored in table- CE_STATEMENT_RECONCILS_ALL. Each row represents an action performed against a statement line.

7) Transactions from all the views below are consolidated into CE_AVAILABLE_TRANSACTIONS_V for bank statement reconcillation

CE_101_TRANSACTIONS_V -- GL journal entry lines 

CE_185_TRANSACTIONS_V -- Treasury Transactions

CE_200_TRANSACTIONS_V -- AP payments

CE_222_TRANSACTIONS_V -- AR cash receipts 

CE_260_TRANSACTIONS_V -- Bank statement lines available for reconciling bank errors

CE_801_TRANSACTIONS_V -- Payroll payments

References:
http://www.oracleerp4u.com/2010/10/cash-management-reconciliation.html