My Oracle Support Banner

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

Last updated on JUNE 07, 2018

Applies to:

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

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

 

SOURCE_TYPE  ADJUSTMENT_TYPE  FL  ADJUSTMENT_AMT  COUNTER
-----------  ---------------  --  --------------  -------
RETIREMENT   COST             CR         1326150    24215
RETIREMENT   EXPENSE          DR       -57881.26    24215 <--- 2 months worth of expense is generated
RETIREMENT   NBV RETIRED      DR      1094624.96    24215
RETIREMENT   RESERVE          DR       231525.04    24215
RETIREMENT   REVAL EXPENSE    DR       -36922.92    24215 <--- 2 months worth of expense is generated
-----------  ---------------  --  --------------  -------
RETIREMENT   COST             DR         1326150    24215
RETIREMENT   EXPENSE          DR        57881.26    24215
RETIREMENT   NBV RETIRED      CR      1094624.96    24215
RETIREMENT   RESERVE          CR       231525.04    24215
RETIREMENT   REVAL EXPENSE    DR        36922.92    24215
RETIREMENT   REVAL RESERVE    CR          886150    24215
RETIREMENT   REVAL RESERVE    DR          886150    24215
-----------  ---------------  --  --------------  -------
RETIREMENT   COST             CR         1326150    24215
RETIREMENT   EXPENSE          DR       -57881.26    24215 <--- It is the same as the expense of 1st retirement
RETIREMENT   NBV RETIRED      DR      1094624.96    24215
RETIREMENT   RESERVE          DR       231525.04    24215
RETIREMENT   REVAL EXPENSE    DR       -36922.92    24215 <--- It is the same as the expense of 1st retirement


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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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