Need To Delete Records On Projects Tables Where Date Is Incorrect

(Doc ID 2390621.1)

Last updated on APRIL 24, 2018

Applies to:

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

Goal

In 2012 an iExpense report was submitted but on 1 line, the date was mistakenly put in as 2021. When the expense report was passed to AP, the mistake was identified and the date was changed to 2012 so it is correct in AP and GL.
In Projects, the change ($4.25) was credited so the net is $0.00 but the records still exist in the Projects tables.

Customer found data in these tables:

PA_EXPENDITURE_ITEMS_ALL
PA_EXPENDITURES_ALL
PA_EXPENDITURE_COMMENTS
 

Solution

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