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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!