R12: What-If Analysis Program Shows Wrong Amount for JP-STL-EXTND in Last Period When Extended Flag Is Not Used (Doc ID 2179449.1)

Last updated on AUGUST 25, 2020

Applies to:

Symptoms

What-If Analysis Program shows wrong amount for JP-STL-EXTND in last period.
This issue occurs when user does not check "Calculate Extended Depreciation".

Reproduced Steps

1. MAR-16 *** Addition
   

   Cost	: 6328152
   YTD depreciation	: 384764
   Accumulated depreciation	: 6011744
   Date in Service	: 01-APR-2003
   Depreciation method	: JP-STL 13YR
   Salvage value	: 10%
   Depreciation limit amount	: 95%

   
   
   
2. APR-17 *** Run Extended Depreciation
   

   Fist Period

   : APR-17

   
   
   
3. APR-17 *** Run What-If Analysis Program
   

   Book	: FA_BOOKS
   Currency	: JPY
   Start Period	: APR-17
   Number of period	: 70
   Assets Number	: FA_BOOKS-01
   Analyze Fully Reserved Asses	: Yes
   Calculate Extended Depreciation	: No

   
   What-If Depreciation Report
   ===========================
   Period Fiscal New
   Name Year Depreciation Depreciation
   -------- ------- ------------ ------------
   OCT-21 2021 5,273+ 5,273+
   NOV-21 2021 5,273+ 5,273+
   DEC-21 2021 5,273+ 5,273+
   JAN-21 2021 5,273+ 5,273+
   FEB-21 2021 5,273+ 5,273+
   MAR-21 2021 6,017,025+ 6,017,025+ <= 60th period
   APR-22 2022 0+ 0+
   MAY-22 2022 0+ 0+
   

   In this assets case, the amount should be calculated below.

   Period Fiscal New
   Name Year Depreciation Depreciation
   -------- ------- ------------ ------------
   MAR-21 2021 5,278+ 5,278+ <= 60th period
   APR-22 2022 2+ 2+ <= 61th period

   This assets should be ended at 61th period.

   
   
   

Cause

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