PA:R12: Possible Data Corruption of Project Expenditures In AP And PO
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms