Payables: R12: Invoices With Schedule Payment Holds Still Appear In The Invoice Hold Report After Being Paid
(Doc ID 2063663.1)
Last updated on NOVEMBER 13, 2015
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Invoices with schedule payment holds still appear in the Invoice Hold report after being paid.
Steps to reproduce the issue are :
1. Using Payables Manager responsibility
2. Navigate to Other > Requests
3. Click on Single Request
4. Enter Request Name (Invoice On Hold Report)
5. Enter Parameters
6. Click Ok
7. Click on Submit
The identification query for the transactions is :
SELECT aps.invoice_id, aps.payment_num, 'N' process_flag
FROM ap_payment_schedules_all aps,
WHERE ai.invoice_id = aps.invoice_id
AND NVL(aps.hold_flag,'N') = 'Y'
AND NVL(aps.payment_status_flag,'N') = 'Y'
AND NVL(ai.payment_status_flag,'N') = 'Y'
AND aps.amount_remaining = '0'
AND NOT EXISTS
FROM ap_invoice_lines_all ail
WHERE ail.invoice_id = aps.invoice_id
AND NVL(ail.cancelled_flag,'N')= 'Y'
select 1 from ap_invoice_distributions_all aid
where aid.invoice_id = aps.invoice_id
having sum(aid.amount) =
select sum(aip.amount) from ap_invoice_payments_all aip
where aip.invoice_id = aps.invoice_id
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document