My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.