CE Cash in Transit – 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 in Transit
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Cash in Transit
Applicable Templates:
- Pivot: Cash in Transit - Pivot: Bank Account Currency, Bank Account, In Transit Type, Operating Unit, Third Party (Supplier/Customer) with drill down to details
- Cash In Transit Detail - Detail Extract
Source: Cash in Transit (CEXCSHTR) DB package: CE_CEXCSHTR_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, Transaction Type, Payroll Business Group, AP/AR Operating Unit, As Of Date
Oracle EBS Tables Used
ce_bank_accounts, ce_bank_branches_v, ap_checks_all, ce_bank_acct_uses_all, ce_security_profiles_gt, ce_system_parameters, iby_payment_methods_vl, ap_payment_history_all, ar_receipt_methods, ar_payment_schedules_all, hz_cust_accounts, hz_parties, ar_cash_receipts, ar_cash_receipt_history_all, ce_999_interface_v, ce_bank_accts_gt_v, ce_statement_recon_gt_v, gl_sets_of_books, pay_ce_reconciled_payments, pay_pre_payments, pay_assignment_actions, pay_payroll_actions, pay_org_payment_methods_f, pay_payment_types, pay_action_interlocks
Report Categories
Related Reports
CE Cleared Transactions, CE General Ledger Reconciliation, AR Miscellaneous Receipts, GL Account Distribution Analysis, AP Invoice Payments, AP Invoice Payments 11g, AR Cash Receipt Upload, AR Transactions and Payments, AR Customer Upload
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 | Example |
| Blitz Report™ XML Import | CE_Cash_in_Transit.xml |
| SQL Source | CE Cash in Transit.sql |
| Full Report on Enginatics | www.enginatics.com/reports/ce-cash-in-transit/ |
Executive Summary
The CE Cash in Transit report provides a detailed view of cash flows that have been recorded in the subledgers (AP/AR) but have not yet cleared the bank. This “float” is a critical component of liquidity management. The report allows Treasury Managers to see the pipeline of incoming receipts and outgoing payments, enabling more accurate cash positioning and forecasting.
Business Challenge
Between the time a check is printed or a receipt is recorded and the time it actually clears the bank, the cash is “in transit.”
- Liquidity Blind Spots: Ignoring in-transit cash can lead to overdrafts (if outgoing payments clear faster than expected) or idle cash (if receipts are delayed).
- Reconciliation Delays: Large volumes of aged in-transit items often indicate lost checks, failed transmissions, or reconciliation process breakdowns.
- Forecasting Accuracy: To know how much cash will be available tomorrow, you must know what is currently in the banking pipeline.
Solution
This report aggregates all uncleared transactions from AP, AR, and Payroll, presenting them by Bank Account and Transaction Type.
Key Features:
- Multi-Source Aggregation: Combines data from Accounts Payable (Payments), Accounts Receivable (Receipts), and Payroll into a single view.
- Aging Analysis: Helps identify old items that should have cleared by now (e.g., uncashed checks > 90 days).
- Drill-Down: Provides details on the specific Third Party (Supplier/Customer) and transaction numbers.
Architecture
The report queries the CE_AVAILABLE_TRANSACTIONS_V (or similar union views) which pulls data from AP_CHECKS_ALL, AR_CASH_RECEIPTS, and PAY_PRE_PAYMENTS.
Key Tables:
AP_CHECKS_ALL: Uncleared payments.AR_CASH_RECEIPTS: Uncleared receipts.PAY_PRE_PAYMENTS: Uncleared payroll payments.CE_BANK_ACCOUNTS: The bank account associated with the transactions.
Impact
- Cash Visibility: Provides the “missing link” between book balance and bank balance.
- Risk Management: Highlights potential fraud or operational issues (e.g., uncashed checks).
- Working Capital Optimization: Allows for tighter management of cash buffers by understanding the exact timing of flows.
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