IAC Revaluation of Assets 'last_update_date' is Same as 'created_date' On IGI_IAC_Adjustments Table
Last updated on JULY 07, 2016
Applies to:Oracle Public Sector Financials (International) - Version 12.0.6 and later
Information in this document applies to any platform.
Table IGI_IAC_ADJUSTMENTS holds the accounting information.
Columns: LAST_UPDATE_DATE ; CREATION_DATE
When carrying out an IAC revaluation of an asset the 'last update date' is same as 'creation date' on IGI_IAC_ADJUSTMENTS table between the 'Preview' of the revaluation and the 'Run'. This causes inaccuracy if the Preview on an IAC revaluation is done one day, and the Run on that revaluation is done the next day.
The creation date should be the date that the preview was done, and updated date should be the date that the run was done on the IGI_IAC_Adjustments table ,same case of igi_iac_revaluations table for the same revaluation.
Is there a code fix code available so that the Revaluation 'Run' 'Last_update_date' will show the correct time and date on the IGI_IAC_Adjustments table ?
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