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

Last updated on JULY 06, 2016

Applies to:

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

Symptoms

What-If Analysis report calculates wrong amount when executed at the last period of fiscal year with temporary closed status.

Conditions

Steps to reproduce

1. APR-08 *** Additions

  Cost                      : 1827598
  YTD depreciation          : 0
  Accumulated depreciation  : 0
  Date in Service           : 11-APR-2008
  Depreciation method       : JP-STL 15YR
  Salvage value             : 0
  Depreciation limit amount : 1

2. Run Depreciation with period close

3. MAR-21 *** Run What-If Report

  Period   Fiscal               New
  Name     Year    Depreciation Depreciation
  -------- ------- ------------ ------------
  MAR-21   2020          10,205       10,205 <-----Check.
  APR-21   2021          10,204       10,204
  MAY-21   2021          10,204       10,204
  JUN-21   2021          10,204       10,204
  JUL-21   2021          10,204       10,204
  AUG-21   2021          10,204       10,204
  SEP-21   2021          10,204       10,204

4. Run Depreciation WITHOUT period close (temporary close)

5. MAR-21 *** Run What-If Report

  Period   Fiscal               New
  Name     Year    Depreciation Depreciation
  -------- ------- ------------ ------------
  MAR-21   2020        -112,244     -112,244 <-----Incorrect. this should be 10,205
  APR-21   2021          10,204       10,204
  MAY-21   2021          10,204       10,204
  JUN-21   2021          10,204       10,204
  JUL-21   2021          10,204       10,204
  AUG-21   2021          10,204       10,204
  SEP-21   2021          10,204       10,204

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