What-If Report: Wrong Amount Are Calculated for JP-2X0DB Method Assets in the Revised Rate Periods (Doc ID 2143279.1)

Last updated on JUNE 03, 2016

Applies to:

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

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 in Revised Rate Periods.
* Depreciation Amount for an open period is calculated (=Temporary close).

Conditions:

Steps to Reproduce

Case:76230

1. MAR-12 *** Addition

  Cost                       : 7400000
  YTD depreciation           : 0
  Accumulated depreciation   : 0
  Date in Service            : 09-MAR-2012
  Depreciation method        : JP-250DB 15
  Salvage value              : 0
  Depreciation limit amount  : 1

2. Run Depreciation with period close to FEB-21

3. MAR-21 *** Run What-if analysis report.

  Period   Fiscal               New
  Name     Year    Depreciation Depreciation
  -------- ------- ------------ ------------
  MAR-21   2020          23,540       23,540
  APR-21   2021          23,486       23,486 <------Check
  MAY-21   2021          23,486       23,486
  JUN-21   2021          23,486       23,486
  JUL-21   2021          23,486       23,486
  AUG-21   2021          23,486       23,486
  SEP-21   2021          23,486       23,486
  OCT-21   2021          23,486       23,486
  NOV-21   2021          23,486       23,486
  DEC-21   2021          23,486       23,486
  JAN-22   2021          23,486       23,486
  FEB-22   2021          23,486       23,486
  MAR-22   2021          23,480       23,480
  APR-22   2022          23,486       23,486

4. Run Depreciation WITHOUT period close (temporary close)

5. MAR-21 *** Run What-if analysis report.

  Period   Fiscal               New
  Name     Year    Depreciation Depreciation
  -------- ------- ------------ ------------
  MAR-21   2020          23,540       23,540
  APR-21   2021          23,542       23,542 <------This should be 23,486
  MAY-21   2021          23,542       23,542
  JUN-21   2021          23,542       23,542
  JUL-21   2021          23,542       23,542
  AUG-21   2021          23,542       23,542
  SEP-21   2021          23,542       23,542
  OCT-21   2021          23,542       23,542
  NOV-21   2021          23,542       23,542
  DEC-21   2021          23,542       23,542
  JAN-22   2021          23,542       23,542
  FEB-22   2021          23,542       23,542
  MAR-22   2021          23,540       23,540
  APR-22   2022          23,542       23,542

Case:81134

1. APR-15 *** Addition

  Cost                       : 13740000
  YTD depreciation           : 0
  Accumulated depreciation   : 0
  Date in Service            : 17-APR-2015
  Depreciation method        : JP-200DB 10
  Salvage value              : 0
  Depreciation limit amount  : 1

2. Run Depreciation with period close to FEB-21

3. MAR-21 *** Run What-if analysis report.

  Period   Fiscal               New
  Name     Year    Depreciation Depreciation
  -------- ------- ------------ ------------
  MAR-21   2020          75,035       75,035
  APR-21   2021          75,039       75,039
  MAY-21   2021          75,039       75,039
  JUN-21   2021          75,039       75,039
  JUL-21   2021          75,039       75,039
  AUG-21   2021          75,039       75,039
  SEP-21   2021          75,039       75,039
  OCT-21   2021          75,039       75,039
  NOV-21   2021          75,039       75,039
  DEC-21   2021          75,039       75,039
  JAN-22   2021          75,039       75,039
  FEB-22   2021          75,039       75,039
  MAR-22   2021          75,036       75,036 <-----Check
  APR-22   2022          75,039       75,039


4. Run Depreciation WITHOUT period close (temporary close)

5. MAR-21 *** Run What-if analysis report.

  Period   Fiscal               New
  Name     Year    Depreciation Depreciation
  -------- ------- ------------ ------------
  MAR-21   2020          75,035       75,035
  APR-21   2021          75,039       75,039
  MAY-21   2021          75,039       75,039
  JUN-21   2021          75,039       75,039
  JUL-21   2021          75,039       75,039
  AUG-21   2021          75,039       75,039
  SEP-21   2021          75,039       75,039
  OCT-21   2021          75,039       75,039
  NOV-21   2021          75,039       75,039
  DEC-21   2021          75,039       75,039
  JAN-22   2021          75,039       75,039
  FEB-22   2021          75,039       75,039
  MAR-22   2021          75,035       75,035 <-----This should be 75,036
  APR-22   2022          75,039       75,039

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