My Oracle Support Banner

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

Last updated on MARCH 04, 2019

Applies to:

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

Symptoms

----------------------------------------
NOTE: In the images.examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
----------------------------------------

 

In JP-200DB or JP-250DB asset with revised rate, What-If Report is showing incorrect depreciation amount after performing run Depreciation without period close in the last period of the year.

Steps to Reproduce
* The calendar is the begining of April
1.  2020-02 *** Addition
    
    Cost                               : 13270000
    YTD depreciation                   : 493020
    Accumulated depreciation           : 12583312
    Date in Service                    : 14-APR-2011
    Depreciation method                : JP-250DB 10
    Salvage value                      : 0
    Depreciation limit amount          : 1
    NBV at switch                      : 1771332

2.  2020-03 *** What-If Analysis
 
    (N)Depreciation > What-If Analysis
    Parameter :
    ----------------------------------------------
    Start Period : 2020-03
    ----------------------------------------------
 
    What-If Depreciation Report ***
    Period   Fiscal           New
    Name     Year     Depreciation
    -------- -------  ------------
    2020-03  2019          49,302 <-- Correct
    2020-04  2020          49,302 <-- Correct
    2020-05  2020          49,302 <-- Correct
    2020-06  2020          49,302 <-- Correct
    2020-07  2020          49,302 <-- Correct
    2020-08  2020          49,302 <-- Correct
    2020-09  2020          49,302 <-- Correct
    2020-10  2020          49,302 <-- Correct
    2020-11  2020          49,302 <-- Correct
    2020-12  2020          49,302 <-- Correct
    2021-01  2020          49,302 <-- Correct
    2021-02  2020          49,302 <-- Correct
 
3.  2020-03 ***Run Depreciation without period close.
 
    FA_DEPRN_SUMMARY ***
    COUNTER  DEPRN_AMOUNT  YTD_DEPRN  DEPRN_RESERVE  ADJUSTED_COST
    -------  ------------  ---------  -------------  -------------
      24238             0     493020       12583312        1771332
      24239         49302     542322       12632614        1771332
      24240         49302     591624       12681916        1771332

4.  2020-03 *** What-If Analysis
 
    (N)Depreciation > What-If Analysis
    Parameter :
    ----------------------------------------------
    Start Period : 2020-03
    ----------------------------------------------
 
    What-If Depreciation Report ***
    Period   Fiscal          New
    Name     Year    Depreciation
    -------- ------- ------------
    2020-03  2019         49,231 <-- Wrong.  It should be 49,302.
    2020-04  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-05  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-06  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-07  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-08  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-09  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-10  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-11  2020         49,228 <-- Wrong.  It should be 49,302.
    2020-12  2020         49,228 <-- Wrong.  It should be 49,302.
    2021-01  2020         49,228 <-- Wrong.  It should be 49,302.
    2021-02  2020         49,228 <-- Wrong.  It should be 49,302.

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
Cause
Solution
 1. Fixed Files
 2. Recommended Patches
 3. Solution Steps
References


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