What-If Report: Wrong Amount Is Calculated for JP-2X0DB Method Assets at the Last Period of the Year (Doc ID 2120105.1)

Last updated on MARCH 16, 2023

Applies to:

Symptoms

When user generates What-If Depreciation Report at the last period of the year,
wrong amount is calculated for the asset which uses JP-250DB or JP-200DB Depreciation method.
* Depreciation Amount for an open period is calculated (=Temporary close).

Condition

• What-If Depreciation Report is generated at the last period of the year
• Depreciation amount for the current open period is calculated(=Temporary close)
• Assets uses JP-250DB or JP-200DB depreciation method
• FA_BOOKS.RATE_IN_USE of current year is original rate

Steps to Reproduce

1. MAY-14 *** Addition

    Cost                       : 25388500
    YTD depreciation           : 0
    Accumulated depreciation   : 0
    Date in Service            : 08-MAY-2014
    Depreciation method        : JP-200DB 10
    Salvage value              : 0
    Depreciation limit amount  : 1

2. Run Depreciation with period close

3. MAR-19 *** Run What-If Analysis

    Asset      Period   Fiscal                        New
    Number     Name     Year    Depreciation Depreciation
    ---------- -------- ------- ------------ ------------
    MS0310-01  MAR-19   2018    176,926      176,926 <-- Correct
               APR-19   2019    141,544      141,544 <-- Correct
               MAY-19   2019    141,544      141,544 <-- Correct
               JUN-19   2019    141,544      141,544 <-- Correct
               JUL-19   2019    141,544      141,544 <-- Correct
               AUG-19   2019    141,544      141,544 <-- Correct
               SEP-19   2019    141,544      141,544 <-- Correct
               OCT-19   2019    141,544      141,544 <-- Correct
               NOV-19   2019    141,544      141,544 <-- Correct
               DEC-19   2019    141,544      141,544 <-- Correct
               JAN-20   2019    141,544      141,544 <-- Correct
               FEB-20   2019    141,544      141,544 <-- Correct
               MAR-20   2019    141,540      141,540 <-- Correct

4. MAR-19 *** Run Depreciation WITHOUT period close
* Depreciation amount for an open period is calculated

5. MAR-19 *** Run What-If Analysis
* The calculated new depreciation amount for MAR-19 is 141540 but it should be 176926
Also, the calculated new depreciation amount for next and later periods are incorrect.

    Asset      Period   Fiscal                        New
    Number     Name     Year    Depreciation Depreciation
    ---------- -------- ------- ------------ ------------
    MS0310-01  MAR-19   2018    141,540      141,540 <-- Incorrect
               APR-19   2019    142,133      142,133 <-- Incorrect
               MAY-19   2019    142,133      142,133 <-- Incorrect
               JUN-19   2019    142,133      142,133 <-- Incorrect
               JUL-19   2019    142,133      142,133 <-- Incorrect
               AUG-19   2019    142,133      142,133 <-- Incorrect
               SEP-19   2019    142,133      142,133 <-- Incorrect
               OCT-19   2019    142,133      142,133 <-- Incorrect
               NOV-19   2019    142,133      142,133 <-- Incorrect
               DEC-19   2019    142,133      142,133 <-- Incorrect
               JAN-20   2019    142,133      142,133 <-- Incorrect
               FEB-20   2019    142,133      142,133 <-- Incorrect
               MAR-20   2019    142,139      142,139 <-- Incorrect

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.