RXi: What-If Depreciation Analysis Is Showing Incorrect Depreciation Amount for JP-250DB (Doc ID 2045818.1)

Last updated on JANUARY 22, 2023

Applies to:

Symptoms

"RXi: What-If Depreciation Analysis" is showing incorrect depreciation amount for JP-250DB XX asset.  

After using revised rate, adjusted_cost should be kept in JP-250DB.  However, "RXi: What-If Depreciation Analysis" is calculating adjusted_cost incorrectly even if it is using revised rate.　　

This issue also does NOT occur on What-If Analysis Program from (N)Depreciation > What-If Analysis.

Steps to Reproduce
1.  2014-04 *** Addition
    
    Cost                               : 290000
    YTD depreciation                   : 0
    Accumulated depreciation           : 223385
    Date in Service                    : 02-DEC-2007
    Depreciation method                : JP-250DB 12
    Salvage value                      : 0
    Depreciation limit amount          : 1


2.  2014-12 *** Run RXi: What-If Depreciation Analysis

    ----------------------------------------------
    Begin Period : 2014-12
    ----------------------------------------------

    RX-only: What-If Depreciation Analysis
    ==================================================
    Cur Cost  Cur Method   Fiscal Year  New Depreciation  Period Name
    --------  -----------  -----------  ----------------  -----------
      290000  JP-250DB 12         2014              1155  2014-12
      290000  JP-250DB 12         2014              1155  2015-01
      290000  JP-250DB 12         2014              1155  2015-02
      290000  JP-250DB 12         2014              1150  2015-03
      290000  JP-250DB 12         2015              1099  2015-04
      290000  JP-250DB 12         2015              1099  2015-05
      290000  JP-250DB 12         2015              1099  2015-06
      290000  JP-250DB 12         2015              1099  2015-07
      290000  JP-250DB 12         2015              1099  2015-08
      290000  JP-250DB 12         2015              1099  2015-09
      290000  JP-250DB 12         2015              1099  2015-10
      290000  JP-250DB 12         2015              1099  2015-11
      290000  JP-250DB 12         2015              1099  2015-12
      290000  JP-250DB 12         2015              1099  2016-01
      290000  JP-250DB 12         2015              1099  2016-02
      290000  JP-250DB 12         2015              1101  2016-03
      290000  JP-250DB 12         2016               824  2016-04 <--Wrong
      290000  JP-250DB 12         2016               824  2016-05 <--Wrong
      290000  JP-250DB 12         2016               824  2016-06 <--Wrong
      290000  JP-250DB 12         2016               824  2016-07 <--Wrong
      290000  JP-250DB 12         2016               824  2016-08 <--Wrong
      290000  JP-250DB 12         2016               824  2016-09 <--Wrong
      290000  JP-250DB 12         2016               824  2016-10 <--Wrong
      290000  JP-250DB 12         2016               824  2016-11 <--Wrong
      290000  JP-250DB 12         2016               824  2016-12 <--Wrong
      290000  JP-250DB 12         2016               824  2017-01 <--Wrong



Complement
==================================================
2.  2014-12 *** What-If Analysis

    (N)Depreciation > What-If Analysis
    ----------------------------------------------
    Begin Period : 2014-12
    ----------------------------------------------

    What-If Analysis
    ==================================================
    Period   Fiscal                     New
    Name     Year          Cost Depreciation
    -------- ------- ---------- ------------
    2014-12  2014     290,000+       1,155+
    2015-01  2014     290,000+       1,155+
    2015-02  2014     290,000+       1,155+
    2015-03  2014     290,000+       1,150+
    2015-04  2015     290,000+       1,099+
    2015-05  2015     290,000+       1,099+
    2015-06  2015     290,000+       1,099+
    2015-07  2015     290,000+       1,099+
    2015-08  2015     290,000+       1,099+
    2015-09  2015     290,000+       1,099+
    2015-10  2015     290,000+       1,099+
    2015-11  2015     290,000+       1,099+
    2015-12  2015     290,000+       1,099+
    2016-01  2015     290,000+       1,099+
    2016-02  2015     290,000+       1,099+
    2016-03  2015     290,000+       1,101+
    2016-04  2016     290,000+       1,099+ <--Correct
    2016-05  2016     290,000+       1,099+ <--Correct
    2016-06  2016     290,000+       1,099+ <--Correct
    2016-07  2016     290,000+       1,099+ <--Correct
    2016-08  2016     290,000+       1,099+ <--Correct
    2016-09  2016     290,000+       1,099+ <--Correct
    2016-10  2016     290,000+       1,099+ <--Correct
    2016-11  2016     290,000+       1,099+ <--Correct
    2016-12  2016     290,000+       1,099+ <--Correct
    2017-01  2016     290,000+       1,099+ <--Correct

    -> This issue does not occur on What-If Analysis

Cause

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