Free Fusion SQLCash ManagementRead-only

Bank account master list

Internal bank accounts with currency and classification. Reference list for cash management and bank-rec scoping.

Get the free ITGC & reporting query pack by email All 20 free queries

Tables used

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.

SQLdba-cm-bank-accounts

SELECT ba.bank_account_id, ba.bank_account_name, ba.bank_account_num, ba.currency_code,
  ba.account_classification, ba.last_updated_by, ba.last_update_date
FROM ce_bank_accounts ba
ORDER BY ba.bank_account_name

A 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.

cmbankmaster

Unreconciled bank statement lines

Bank statement lines that have not been matched to a payment/receipt — flags bank rec backlog.

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.

Start a free 14-day trial Get the free query pack by email