My Oracle Support Banner

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

Last updated on JULY 27, 2020

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;

Changes

 

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
Changes
Cause
Solution
 Collaborate with and learn from your peers, industry experts and Oracle Support Product Specialists using the "My Oracle Support" Payables Community!
References


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