PA:R12: Possible Data Corruption of Project Expenditures In AP And PO (Doc ID 2163169.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 
Purchase orders and AP invoices created for projects but not interfacing correctly to Project costing.
 
The problem is PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID for Supplier Invoices transaction should exist in AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_DISTRIBUTION_ID.

There are numerous transactions where the document distribution id does not exist in AP_INVOICE_DISTRIBUTIONS_ALL table at all.

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