R12: Fully Paid Invoice Shows Unpaid Status
Last updated on MARCH 08, 2017
Applies to:Oracle Payables - Version: 12.0.1 to 12.1.2 - Release: 12.0 to 12.1
Information in this document applies to any platform.
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,
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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms