Revaluation: 2nd Retirement Expense Wrong and Is the Same Value as 1st Retirement Expense (Doc ID 2408367.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Symptoms

After performing full retirement and reinstatement for revaluated asset, when performing full retirement again with Date Retired
different from the first full retirement, the second Retirement Expense wrongly is the same value as the first Retirement Expense.

Steps to Reproduce
*Calendar is starting from JUL

1.  2014-10 *** Addition

    Cost                       : 1200000
    YTD depreciation           : 10000
    Accumulated depreciation   : 250000
    Date in Service            : 01-JUL-2011
    Depreciation method        : STL 10Year
    Salvage value              : 0
    Depreciation limit amount  :

2.  2015-07 *** Revaluation with 5%

3.  2016-07 *** Revaluation with 5%

4.  2017-07 *** Revaluation with 5%

5.  2018-05 *** 1st Full retirement
    
    Date Retired           : 31-MAR-2018       <---#### Date Retired is March ####
    Retirement Convention  : *Current Month

　　   *2 months worth of expense is generated because Date Retired is March and the current period is May.

6.  2018-05 *** Reinstatement

7.  2018-05 *** 2nd Full retirement
    
    Date Retired           : 01-APR-2018       <---#### Date Retired is April ####
    Retirement Convention  : *Current Month

• RETIREMENT EXPENSE in 2nd retirement should be -28940.63, instead of -57881.26
• RETIREMENT REVAL EXPENSE in 2nd retirement should be -18461.46, instead of -36922.92

Although Date Retired is April and the current period is May, two months worth of expense wrongly is generated and it is the same as the expense of 1st retirement.
One month worth of expense should be generated because Date Retired is April and the current period is May.

Cause

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