Payables: R12: Invoices With Schedule Payment Holds Still Appear In The Invoice Hold Report After Being Paid
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms