CE Bank Statement and Reconciliation – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Cash Management · all Cash Management reports

Overview

Application: Cash Management Description: Bank Statements - Bank Statement Details and Reconciliation

Provides equivalent functionality to the following standard Oracle Forms/Reports

This Blitz Report offers an extended set of parameters over and above the standard form/reports to search for specific reconciled transactions.

Sources: Bank Statement Detail Report (CEXSTMRR) Bank Statement Summary Report (CEXSTMSR) DB package: CE_CEXSTMRR_XMLP_PKG (required to initialize security)

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Bank Name, Bank Branch, Bank Account Name, Bank Account Number, Check Digits, Statement Date From, Statement Date To, Statement GL Date From, Statement GL Date To, Statement Number From, Statement Number To, Document Number From, Document Number To, Statement Currency, Statement Line Status, Statement Complete, Trx Date From, Trx Date To, Payer/Payee Name Like, Trx Type, Trx Number, Invoice Number, Trx Amount, Trx Currency, Display Reconciled Transactions, Transaction Cleared Date From, Transaction Cleared Date To

Oracle EBS Tables Used

gl_daily_conversion_types, gl_je_lines, ap_checks_all, ar_cash_receipt_history_all, ce_cashflows, fnd_currencies, ce_statement_lines, pay_assignment_actions, pay_pre_payments, pay_action_interlocks, ce_999_interface_v, xtr_settlement_summary, ce_reconciled_transactions_v, ce_reconciliation_errors_v, ce_bank_accts_gt_v, ce_statement_headers, hz_parties, xle_entity_profiles, gl_code_combinations, ce_statement_reconcils_all, ar_cash_receipts_all, iby_fndcpt_tx_extensions, ar_batches_all, hr_all_organization_units

Report Categories

Enginatics, R12 only

CE Cash in Transit, GL Account Distribution Analysis, CE Cleared Transactions, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), CE General Ledger Reconciliation, CE Transactions Available for Reconciliation, AR Customer Upload, GL Account Analysis (Drilldown)

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output CE Bank Statement and Reconciliation 04-Apr-2026 123137.xlsx
Blitz Report™ XML Import CE_Bank_Statement_and_Reconciliation.xml
SQL Source CE Bank Statement and Reconciliation.sql
Full Report on Enginatics www.enginatics.com/reports/ce-bank-statement-and-reconciliation/

Case Study: Streamlining Cash Reconciliation with Oracle Cash Management

Executive Summary

The CE Bank Statement and Reconciliation report is the cornerstone of cash visibility within Oracle E-Business Suite. It provides a unified view of bank statement activity and the corresponding system transactions (Payments and Receipts), enabling treasury and accounting teams to rapidly identify unreconciled items, monitor cash positions, and close the books with confidence.

Business Challenge

Cash reconciliation is often one of the most labor-intensive processes in finance. Discrepancies between the bank statement and the general ledger can arise from numerous sources:

The Solution

This report acts as a “Reconciliation Hub,” pulling data from the Bank Statement Interface tables and joining it with the reconciled system transactions. It effectively replicates and enhances the visibility provided by the standard Bank Statement Detail and Summary reports.

Key Features

Technical Architecture

The solution leverages the robust Oracle Cash Management schema, specifically the tables that handle the storage of bank statement files (MT940, BAI2) and their mapping to system transactions.

Critical Tables

Key Parameters

Functional Analysis

Use Cases

  1. Daily Reconciliation: Treasury analysts run this report daily to match the previous day’s bank feed against system activity.
  2. Period-End Close: The report serves as the supporting schedule for the Cash GL account balance, proving the “Adjusted Bank Balance” equals the “Book Balance.”
  3. Audit Defense: Provides a historical record of exactly which system transaction cleared a specific bank line item.

FAQ

Q: Does this report show transactions that are in the system but not on the bank statement? A: Primarily, this report focuses on the Bank Statement perspective (what is on the statement). However, by filtering for unreconciled system transactions (available in related reports), users can find the inverse.

Q: How are foreign currency transactions handled? A: The report includes columns for both the Transaction Currency (e.g., invoice currency) and the Bank Currency, allowing for validation of exchange rates used during clearing.

Q: Can this report handle manual reconciliation? A: Yes, whether the reconciliation was performed automatically by the AutoReconciliation program or manually by a user, the link is preserved in the CE_RECONCILED_TRANSACTIONS_V view.

© Enginatics GmbH