Free Fusion SQLAccounts ReceivableRead-only

Unapplied cash receipts

Receipts that landed in AR but have not been applied to an invoice — often a clearance backlog risk.

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

Tables used

ar_cash_receipts_all hz_cust_accounts hz_parties

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-ar-unapplied-receipts

SELECT
  cr.cash_receipt_id,
  cr.receipt_number,
  cr.receipt_date,
  cr.amount,
  cr.currency_code,
  cust.party_name        AS customer_name,
  cr.status,
  cr.created_by,
  cr.creation_date
FROM   ar_cash_receipts_all cr
LEFT   JOIN hz_cust_accounts ca ON ca.cust_account_id = cr.pay_from_customer
LEFT   JOIN hz_parties        cust ON cust.party_id  = ca.party_id
WHERE  cr.status = 'UNAPP'
  AND  cr.receipt_date >= SYSDATE - 180
ORDER  BY cr.receipt_date DESC

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.

arreceiptscash

AR adjustments by user (last 90 days)

Who has been writing down receivables and by how much — useful for analyst review.

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