What-If Report Is Showing Wrong Amount for NBV Basis Method with Backdated DPIS at the Last Period of 1st Year (Doc ID 2616372.1)

Last updated on DECEMBER 02, 2019

Applies to:

Symptoms

What-If Depreciation Report is showing wrong depreciation amount for Depreciation Method using NBV basis(like JP-DB XXYR) with back-dated DPIS at the last period of 1st fiscal year.

Condition

• Depreciation Method using NBV basis(like JP-DB XXYR)
• Addition with back-dated DPIS and non depreciation reserve
• Go to the next period after addition

Steps to Reproduce
*Calendar is beginning of January

1.  2017-01 *** Addition

    Cost                       : 240000
    YTD depreciation           : 0
    Accumulated depreciation   : 0
    Date in Service            : 01-DEC-2016
    Depreciation method        : JP-DB 3YR (.536)
    Salvage value              : 10% (=24000)
    Depreciation limit amount  : 95%

2.  2017-01 *** Run Depreciation and go to the next period

3.  2017-02 *** Check the asset

    Cost                       : 240000
    YTD depreciation           : 20961
    Accumulated depreciation   : 20961
    Date in Service            : 01-DEC-2016
    Depreciation method        : JP-DB 3YR (.536)
    Salvage value              : 10% (=24000)
    Depreciation limit amount  : 95%

    FA_DEPRN_SUMMARY***
    PERIOD  COUNTER DEPRN_AMOUNT DEPRN_RESERVE DEPRN_ADJUSTMENT_AMOUNT
    ------- ------- ------------ ------------- -----------------------
    2016-12   24204            0             0                        
    2017-01   24205        20961         20961                   10720

4.  2017-02 *** Run What-If Depreciation Report

    What-If Depreciation Report ***
    Period   Fiscal                       New
    Name     Year    Depreciation Depreciation
    -------- ------- ------------ ------------
    2017-01  2017        20,961+      20,961+
    2017-02  2017        10,241+      10,241+
    2017-03  2017        10,241+      10,241+
    2017-04  2017        10,241+      10,241+
    2017-05  2017        10,241+      10,241+
    2017-06  2017        10,241+      10,241+
    2017-07  2017        10,241+      10,241+
    2017-08  2017        10,241+      10,241+
    2017-09  2017        10,241+      10,241+
    2017-10  2017        10,241+      10,241+
    2017-11  2017        10,241+      10,241+
    2017-12  2017          <477>        <477> <--- ### Wrong ###
    -------- ------- ------------ ------------
    2018-01  2018         5,231+       5,231+
    2018-02  2018         5,231+       5,231+
    2018-03  2018         5,231+       5,231+
    2018-04  2018         5,231+       5,231+
    2018-05  2018         5,231+       5,231+
    2018-06  2018         5,231+       5,231+
    2018-07  2018         5,231+       5,231+
    2018-08  2018         5,231+       5,231+
    2018-09  2018         5,231+       5,231+
    2018-10  2018         5,231+       5,231+
    2018-11  2018         5,231+       5,231+
    2018-12  2018         5,227+       5,227+

--> In 2017-12, the depreciation amount should be 10243, instead of -477

Cause

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