CE General Ledger Cash Account Usage – 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: Cash Account Usage
This report details the General Ledger Cash Accounts assigned to Bank Accounts, and their usage.
The following templates are available: Pivot: Bank Accounts, Assigned Cash Accounts - Pivot by Bank Account, Cash Account showing cash account usage within each bank account. Pivot: Cash Account, Assigned Bank Accounts - Pivot by Cash Account, Bank Account, showing cash account usage within each bank account.
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
Legal Entity, Bank Name, Bank Branch, Bank Account Name, Bank Account Number, Bank Account Currency, Cash Account
Oracle EBS Tables Used
ce_bank_accounts, xle_entity_profiles, gl_ledgers, hz_parties, gl_code_combinations_kfv, ce_bank_acct_uses_all, ce_security_profiles_v, ce_gl_accounts_ccid, dual
Report Categories
Related Reports
CE General Ledger Reconciliation, IBY Payment Process Request Details, CE Cleared Transactions, AR Customer Upload, CE Bank Account Balances, AR Miscellaneous Receipts, AR Unapplied Receipts Register, AR Transactions and Payments
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 General Ledger Cash Account Usage 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | CE_General_Ledger_Cash_Account_Usage.xml |
| SQL Source | CE General Ledger Cash Account Usage.sql |
| Full Report on Enginatics | www.enginatics.com/reports/ce-general-ledger-cash-account-usage/ |
Executive Summary
The CE General Ledger Cash Account Usage report is a configuration audit tool that maps Bank Accounts to their corresponding General Ledger (GL) Cash Accounts. In Oracle, a single bank account can be linked to multiple GL accounts (e.g., for different currencies or operating units), and conversely, a GL account might be shared. This report visualizes these relationships to ensure that cash activity is being booked to the correct ledger accounts.
Business Challenge
The link between the Bank Account (Treasury) and the GL Account (Accounting) is defined in the Bank Account Setup.
- Mispostings: If a bank account is mapped to the wrong GL account, cash transactions will be recorded in the wrong place, causing reconciliation nightmares.
- Segregation of Duties: Ensuring that specific bank accounts map to specific GL accounts is often a compliance requirement.
- Complexity: In multi-org environments, the mapping rules can become complex and hard to visualize one screen at a time.
Solution
This report provides a matrix view of Bank Accounts and their assigned GL Cash Accounts.
Key Features:
- Bi-Directional Pivot: Can be viewed by Bank Account (showing all GL accounts used) or by GL Account (showing all Bank Accounts linked).
- Currency Visibility: Shows the currency of both the bank account and the GL account to ensure alignment.
- Legal Entity Context: Groups accounts by Legal Entity to validate ownership.
Architecture
The report queries CE_BANK_ACCOUNTS and joins to CE_GL_ACCOUNTS_CCID (or CE_BANK_ACCT_USES_ALL) to retrieve the accounting flexfield segments.
Key Tables:
CE_BANK_ACCOUNTS: Bank account definitions.CE_BANK_ACCT_USES_ALL: The usage assignment (which links the bank account to a specific Org and GL Account).GL_CODE_COMBINATIONS: The GL account details.
Impact
- Configuration Accuracy: Validates that the Treasury-to-GL mapping is correct.
- Reconciliation Readiness: Ensures that the “GL Balance” used in reconciliation reports is pulling from the correct combination of accounts.
- System Cleanup: Helps identify unused or incorrectly mapped GL accounts.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH