Oracle Applications – How to find the receipt stuck in between stages?
- Oracle Applications – Receipt On Account & Unapplied – SQL Query
- Receipt Status – Oracle Applications
- Receipt API in Oracle Receivables
- Oracle Applications: The Concurrent Jobs Ran Yesterday and Failed – SQL script & Unix Shell Script
- Oracle Applications – Acoounts Receivables (AR) Tables Information.
Many times, the receipts are stuck in between stages.
If these are noticed, all the receipts are stuck, and invoices many not be closed.
Here is the sql to find the receipt stuck in between stages.
This is working code, verified in oracle 11i financial applications
Author: Jay
******************/
SELECT ab.org_id,
ab.name,
ab.batch_applied_status ,
ab.batch_date,
count(*)
FROM AR_PAYMENT_SCHEDULES_ALL aps, ar_batches_all ab
WHERE 1=1
—- uncomment this optional clause for faster response
—- and to_char(ab.batch_date,’DD-MON-YYYY’) >= ‘01-JAN-2008′
AND ab.batch_applied_status NOT IN ( ‘COMPLETED_APPROVAL’,‘PROCESSED’,‘COMPLETED_FORMAT’)
AND ab.type=‘CREATION’
AND aps.selected_for_receipt_batch_id = ab.batch_id
GROUP BY ab.org_id,ab.name,ab.batch_applied_status,ab.batch_date;
Comments
No comments yet.