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.

Symptoms

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,
ap_invoices_all ai
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
(SELECT 1
FROM ap_invoice_lines_all ail
WHERE ail.invoice_id = aps.invoice_id
AND NVL(ail.cancelled_flag,'N')= 'Y'
)
and exists
(
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
)
);

 

 

 

Cause

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