FA_BOOKS.LAST_UPDATE_DATE Is NOT Updated When Posting Impairment (Doc ID 2687370.1)

Last updated on JULY 02, 2020

Applies to:

Symptoms

FA_BOOKS.LAST_UPDATE_DATE is NOT updated when posting impairment.
FA_BOOKS.LAST_UPDATE_DATE should be updated and should be same as FA_BOOKS.DATE_INEFFECTIVE when the asset has been adjusted.


Steps to Reproduce
Post impairment on (N)Assets > Impairment > Create and Post


Current behavior

FA_BOOKS:
DATE_EFFECTIVE        DATE_INEFFECTIVE      LAST_UPDATE_DATE    
--------------------  --------------------  --------------------
01-APR-2013 21:52:24  20-APR-2013 02:07:26  20-APR-2013 02:07:26
20-APR-2013 02:07:26  26-DEC-2013 20:18:25  20-APR-2013 02:07:26 <---LAST_UPDATE_DATE is NOT updated
26-DEC-2013 20:18:25                        26-DEC-2013 20:18:25 <---New record created by impairment

*LAST_UPDATE_DATE(= 20-APR-2013 02:07:26) is NOT updated.


Expected behavior

FA_BOOKS:
DATE_EFFECTIVE        DATE_INEFFECTIVE      LAST_UPDATE_DATE    
--------------------  --------------------  --------------------
01-APR-2013 21:52:24  20-APR-2013 02:07:26  20-APR-2013 02:07:26
20-APR-2013 02:07:26  26-DEC-2013 20:18:25  26-DEC-2013 20:18:25 <---*Expected behavior
26-DEC-2013 20:18:25                        26-DEC-2013 20:18:25

*LAST_UPDATE_DATE should be updated and should be the same as DATE_INEFFECTIVE(= 26-DEC-2013 20:18:25).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.