JP-DB: What-If Is Showing Incorrect Depreciation Amount When Temporary Close in the Last Period of the Year (Doc ID 2075699.1)

Last updated on NOVEMBER 09, 2015

Applies to:

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

Symptoms

When the profile option of "FA: Annual Rounding" is set to "Always", What-If Report is showing incorrect depreciation amount for asset with JP-DB XXYR which has a partial retirement within the current year after performing run Depreciation without period close in the last period of the year.

Condition
- Profile option of "FA: Annual Rounding" is set to "Always"
- Asset with JP-DB XXYR
- Performing a partial retirement within the current year
- Performing run Depreciation without period close in the last period of the year

Steps to Reproduce
* Calendar is the beginning of April
1.  2019-04 *** Addition
    
    Cost                               : 21202520
    YTD depreciation                   : 0
    Accumulated depreciation           : 19578792
    Date in Service                    : 07-FEB-2008
    Depreciation method                : JP-DB 10YR
    Salvage value                      : 10%
    Depreciation limit amount          : 95%


2.  2019-05 *** Partial retirement & Calculate Gains and Losses
    
    Date Retired        : 01-MAY-2019
    Cost Retired        : 10000
    Prorate Convention  : *Following Month


3.  2020-03 *** Run What-If Analysis

    What-If Depreciation Report*****
    Period   Fiscal                                     New
    Name     Year             Cost Depreciation Depreciation
    -------- ------- ------------- ------------ ------------
    2020-03  2019      21,192,520       27,859       27,859  <--Correct
    2020-04  2020      21,192,520       22,122       22,122
    2020-05  2020      21,192,520       22,122       22,122
    2020-06  2020      21,192,520       22,122       22,122
    2020-07  2020      21,192,520       22,122       22,122
    2020-08  2020      21,192,520       22,122       22,122
    2020-09  2020      21,192,520       22,122       22,122
    2020-10  2020      21,192,520       22,122       22,122
    2020-11  2020      21,192,520       22,122       22,122
    2020-12  2020      21,192,520       22,122       22,122
    2021-01  2020      21,192,520       22,122       22,122


4.  2020-03 *** Run Depreciation without period close

    fa_deprn_summary ***
    counter  deprn_amount  ytd_deprn  deprn_reserve
    -------  ------------  ---------  -------------
      24238         27861     278636       19848168
      24239         27861     306497       19876029
      24240         27859     334356       19903888  <--2020-03


5.  2020-03 *** Run What-If Analysis

    What-If Depreciation Report*****
    Period   Fiscal                                     New
    Name     Year             Cost Depreciation Depreciation
    -------- ------- ------------- ------------ ------------
    2020-03  2019      21,192,520       27,864       27,864  <--Wrong
    2020-04  2020      21,192,520       22,121       22,121  <--Wrong
    2020-05  2020      21,192,520       22,121       22,121  <--Wrong
    2020-06  2020      21,192,520       22,121       22,121  <--Wrong
    2020-07  2020      21,192,520       22,121       22,121  <--Wrong
    2020-08  2020      21,192,520       22,121       22,121  <--Wrong
    2020-09  2020      21,192,520       22,121       22,121  <--Wrong
    2020-10  2020      21,192,520       22,121       22,121  <--Wrong
    2020-11  2020      21,192,520       22,121       22,121  <--Wrong
    2020-12  2020      21,192,520       22,121       22,121  <--Wrong
    2021-01  2020      21,192,520       22,121       22,121  <--Wrong

 

    Expected behavior
    It should be the same value as between non-closing period and temporary closing period
    What-If Depreciation Report*****
    Period   Fiscal                                     New
    Name     Year             Cost Depreciation Depreciation
    -------- ------- ------------- ------------ ------------
    2020-03  2019      21,192,520       27,859       27,859  <--Correct
    2020-04  2020      21,192,520       22,122       22,122
    2020-05  2020      21,192,520       22,122       22,122
    2020-06  2020      21,192,520       22,122       22,122
    2020-07  2020      21,192,520       22,122       22,122
    2020-08  2020      21,192,520       22,122       22,122
    2020-09  2020      21,192,520       22,122       22,122
    2020-10  2020      21,192,520       22,122       22,122
    2020-11  2020      21,192,520       22,122       22,122
    2020-12  2020      21,192,520       22,122       22,122
    2021-01  2020      21,192,520       22,122       22,122


Cause

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