My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.