CE_BANK_ACCOUNTS

Bank statement reconciliation

A bank statement is loaded as a header (CE_STATEMENT_HEADERS_ALL) with lines (CE_STATEMENT_LINES). Cash Management matches each line against an AP payment (AP_CHECKS_ALL) or AR receipt — either automatically via configured matching rules (amount/reference tolerance) or manually by a treasury user — which is what moves a payment's status to Cleared and an AR receipt to Reconciled. An unmatched line either means the bank transaction hasn't been recorded on the Oracle side yet (e.g. a bank fee) or the matching rule's tolerance didn't find a confident match.

Cash positioning

Beyond reconciliation, Cash Management aggregates balances across every CE_BANK_ACCOUNTS row (plus in-transit AP payments and AR receipts) into a real-time cash position — what treasury uses to see available cash across all bank accounts without logging into each bank separately. This is a read/reporting capability rather than a transactional flow, so it doesn't generate its own accounting entries the way AP or AR do.