Migrated/Upgraded Invoices Have No Lines In The Work Bench and/or Stuck in Needs Revalidation Status (Doc ID 1585972.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

 

Changes

Determine number of affected invoices:

select invoice_id
from ap_invoices_all aia
where Invoice_id NOT IN
(Select aila.invoice_id from ap_invoice_lines_all aila)
AND aia.HISTORICAL_FLAG = 'Y'
AND aia.PAYMENT_STATUS_FLAG <> 'Y';

Dists_Arch data contains valid distributions while upgraded invoice in R12 contains no distributions and lines.

 

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