CE Bank Branches – 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

This Report is the repository of all bank branches covering both internal and external bank accounts and will list the bank branches along with an indication of usage: -Internal -Supplier -Customer

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 Name, Show Internal Usage, Show Supplier Usage, Show Customer Usage

Oracle EBS Tables Used

ce_bank_accounts, iby_ext_bank_accounts, iby_pmt_instr_uses_all, iby_external_payees_all, ap_suppliers, iby_external_payers_all, ce_bank_branches_v, ce_banks_v, fnd_territories_vl

Report Categories

Enginatics, R12 only

AP Supplier Upload, AP Suppliers, AR Customer Upload, AR Customers and Sites, AP Invoices and Lines, AP Accounted Invoice Aging, AP Suppliers Revenue Summary, AR Miscellaneous Receipts

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 Branches 02-Aug-2024 090909.xlsx
Blitz Report™ XML Import CE_Bank_Branches.xml
SQL Source CE Bank Branches.sql
Full Report on Enginatics www.enginatics.com/reports/ce-bank-branches/

Executive Summary

The CE Bank Branches report serves as a master directory of all bank branches defined in the system, covering both internal (company-owned) and external (supplier/customer) banks. It provides a clear view of the banking network relationships, indicating whether a branch is used for internal treasury operations, supplier payments, or customer receipts. This report is vital for Master Data Management (MDM) teams to maintain a clean and accurate banking hierarchy.

Business Challenge

As organizations grow, the number of bank branches in the system can proliferate, leading to:

Maintaining a clean “Golden Source” of bank branch data is critical for payment processing efficiency.

Solution

This report lists every bank branch along with its parent Bank and its usage flags.

Key Features:

Architecture

The report queries CE_BANK_BRANCHES_V and CE_BANKS_V for the core branch data. It joins to IBY (Payments) tables to determine usage.

Key Tables:

Impact

© Enginatics GmbH