R12: Fully Paid Invoice Shows Unpaid Status (Doc ID 1157940.1)

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.

Symptoms

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;

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