Analytics Catalog/Oracle Fusion ERP/Cash Management
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion ERP · CE

Cash Management reports

Every Cash Management report — logic, source tables, parameterized SQL, the data dictionary, a star-schema data model, and extraction patterns. 6 reports.

Cash Management data model

The module's conformed star — the fact every Cash Management report rolls up to, surrounded by the dimensions shared across the module. See the full Cash Management data model → — all star schemas, the model dictionary, use cases, and every bicc View Object this module exposes.

CE_BANK_ACCOUNTSconformedCE_LOOKUPSconformedAP_CHECKS_ALLconformedAR_CASH_RECEIPTS_ALLconformedCE_STATEMENT_HEADERS_INTfact · Cash Management grainAmount · Count
●— fact → dimension join

Reports

CE
Auto Reconciliation Execution Report
The outcome of the automatic bank-reconciliation run — which imported statement lines matched system transacti…
CE
Cash to General Ledger Reconciliation Report
Compares the general ledger cash account balance to the bank account balance for each account, listing the unr…
CE
Treasury-Loaded Bank Account Information Report
Bank account and statement information loaded into Cash Management from an external treasury system — daily ba…
CE
Transactions Available for Reconciliation Report
The system-side transactions — payments, receipts, and journals — available to match against imported bank sta…
CE
Cash Management Bank Statement Report
Bank account balances and transaction information for specific bank statements — opening and closing balance, …
CE
Cash in Transit Report
For a bank account, the transactions remitted to the bank but not yet cleared as of a date — payments and rece…