JP-DB: What-If Is Showing Wrong Amount for Asset Which Is Added in Previous Year When Temporary Close in the Last Period of the Year (Doc ID 2121124.1)

Last updated on MARCH 15, 2023

Applies to:

Symptoms

After performing temporary close in the last period of the year, What-If Report is showing incorrect depreciation amount for an asset with JP-DB XXYR which is added in previous year.

Condition

• JP-DB XXYR
• Performing What-If Report except year of addition  *This issue is NOT reproduced in year of addition
• Set "Start Period" in What-If form to a current period
• Temporary close in the last period of the year
• Set profile option of "FA: Annual Rounding" to "Always"

Steps to Reproduce
////////////////FY2014///////////////////////////
1.  2015-03 *** Addition
    
    Cost                               : 1190928
    YTD depreciation                   : 19767
    Accumulated depreciation           : 1106001
    Date in Service                    : 01-APR-2003
    Depreciation method                : JP-DB 10YR
    Salvage value                      : 10%
    Depreciation limit amount          : 95%

////////////////FY2015///////////////////////////
2.  2016-03 *** What-If Analysis

    Start Period : 2016-03
    Analyze Fully Reserved Assets   : Yes
    Calculate Extended Depreciation : Yes

    What-If Depreciation Report ***
    Period   Fiscal          New
    Name     Year    Depreciation
    -------- ------- ------------
    2016-03  2015          1,427    <--Correct
    2016-04  2016          1,133
    2016-05  2016          1,133
    2016-06  2016          1,133
    2016-07  2016          1,133
    2016-08  2016          1,133
    2016-09  2016            792
    2016-10  2016              0
    2016-11  2016              0
    2016-12  2016              0
    2017-01  2016              0
    2017-02  2016              0
    2017-03  2016              0
    2017-04  2017            992
    2017-05  2017            992


    fa_books ***
    cost     adjusted_cost  deprn_method  eofy_reserve  eofy_adj_cost
    -------  -------------  ------------  ------------  -------------
    1190928         -35965  JP-DB 10YR         1107800         -14399

    fa_deprn_summary ***
    period   counter  deprn_amount  ytd_deprn  deprn_reserve  adjusted_cost
    -------  -------  ------------  ---------  -------------  -------------
    2015-02    24179             0      19767        1106001         -14399
    2015-03    24180          1799      21566        1107800         -14399
    2015-04    24181          1427       1427        1109227         -35965
    2015-05    24182          1427       2854        1110654         -35965
    2015-06    24183          1427       4281        1112081         -35965
    2015-07    24184          1427       5708        1113508         -35965
    2015-08    24185          1427       7135        1114935         -35965
    2015-09    24186          1427       8562        1116362         -35965
    2015-10    24187          1427       9989        1117789         -35965
    2015-11    24188          1427      11416        1119216         -35965
    2015-12    24189          1427      12843        1120643         -35965
    2016-01    24190          1427      14270        1122070         -35965
    2016-02    24191          1427      15697        1123497         -35965


3.  2016-03 *** Run Depreciation WITHOUT closing the period *Temporary close


4.  2016-03 *** After temporary close, perform What-If Analysis again

    Start Period : 2016-03
    Analyze Fully Reserved Assets   : Yes
    Calculate Extended Depreciation : Yes

    What-If Depreciation Report ***
    Period   Fiscal          New
    Name     Year    Depreciation
    -------- ------- ------------
    2016-03  2015         <2,101>   <--Wrong. It should be 1,427
    2016-04  2016          1,194    <--Wrong. It should be 1,133
    2016-05  2016          1,194    <--Wrong. It should be 1,133
    2016-06  2016          1,194    <--Wrong. It should be 1,133
    2016-07  2016          1,194    <--Wrong. It should be 1,133
    2016-08  2016          1,194    <--Wrong. It should be 1,133
    2016-09  2016          1,194    <--Wrong. It should be 792
    2016-10  2016          1,194    <--Wrong. It should be 0
    2016-11  2016          1,194    <--Wrong. It should be 0
    2016-12  2016            433    <--Wrong. It should be 0
    2017-01  2016              0
    2017-02  2016              0
    2017-03  2016              0
    2017-04  2017            992
    2017-05  2017            992

    fa_books ***
    cost     adjusted_cost  deprn_method  eofy_reserve  eofy_adj_cost
    -------  -------------  ------------  ------------  -------------
    1190928         -53089  JP-DB 10YR         1124924         -35965

    fa_deprn_summary ***
    period   counter  deprn_amount  ytd_deprn  deprn_reserve  adjusted_cost
    -------  -------  ------------  ---------  -------------  -------------
    2015-02    24179             0      19767        1106001         -14399
    2015-03    24180          1799      21566        1107800         -14399
    2015-04    24181          1427       1427        1109227         -35965
    2015-05    24182          1427       2854        1110654         -35965
    2015-06    24183          1427       4281        1112081         -35965
    2015-07    24184          1427       5708        1113508         -35965
    2015-08    24185          1427       7135        1114935         -35965
    2015-09    24186          1427       8562        1116362         -35965
    2015-10    24187          1427       9989        1117789         -35965
    2015-11    24188          1427      11416        1119216         -35965
    2015-12    24189          1427      12843        1120643         -35965
    2016-01    24190          1427      14270        1122070         -35965
    2016-02    24191          1427      15697        1123497         -35965
    2016-03    24192          1427      17124        1124924         -35965

Changes

Cause

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