R12: Fully Paid Invoice Shows Unpaid Status
(Doc ID 1157940.1)
Last updated on JULY 27, 2020
Oracle Payables - Version 12.0.1 to 12.1.2 [Release 12.0 to 12.1] Information in this document applies to any platform.
On 12.0.6, Invoice Workbench search for "Unpaid" status brings back invoices that show Amount Paid = invoice amount.
The AP List diagnostic output shows the amount_remaining is null and payment_status_flag = P in the table AP_PAYMENT_SCHEDULES_ALL.
Running this query returned rows:
select apsa.invoice_id, aia.invoice_num, apsa.org_id, aia.temp_cancelled_amount from AP_PAYMENT_SCHEDULES_ALL apsa, ap_invoices_all aia where apsa.invoice_id = aia.invoice_id and apsa.amount_remaining is NULL and apsa.payment_status_flag <> 'Y' and aia.cancelled_date is null;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!