IAC Revaluation of Assets 'last_update_date' is Same as 'created_date' On IGI_IAC_Adjustments Table (Doc ID 1963886.1)

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.

Goal

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 ?
 

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