Unreconciled bank statement lines
Bank statement lines that have not been matched to a payment/receipt — flags bank rec backlog.
Tables used
ce_statement_lines ce_statement_headers ce_bank_accounts
Bind parameters
None — the statement runs as written; edit the literals in the WHERE clause to narrow it.
How to run it
Paste it into a BI Publisher data model as a SQL data set, or into QueryWell's Query Studio and run it against your pod with a reporting account. Results come back to a grid you can profile, chart and export with a SHA-256 hash.
SELECT sl.statement_line_id, sh.statement_number, sh.bank_account_id, ba.bank_account_name,
sl.line_number, sl.booking_date AS trx_date, sl.trx_type, sl.trx_amount, sl.trx_curr_code AS currency_code,
sl.recon_status AS status
FROM ce_statement_lines sl
JOIN ce_statement_headers sh ON sh.statement_header_id = sl.statement_header_id
JOIN ce_bank_accounts ba ON ba.bank_account_id = sh.bank_account_id
WHERE sl.recon_status IN ('UNRECONCILED','EXTERNAL') AND sl.booking_date >= SYSDATE - 90
ORDER BY sh.bank_account_id, sl.booking_date DESCA single read-only SELECT against Oracle Fusion Cloud's supported reporting surface. Column names and views can differ by release and by the roles your reporting account holds, so validate the result against a report you already trust before relying on it.
cmbankreconciliation
More Cash Management queries
Run it without the template cycle
QueryWell runs this and 81 other curated scripts against your own Fusion pod from one signed desktop app — grid, charts, profiling and hashed exports included. Perpetual licence, 14-day trial.