My Oracle Support Banner

R12: What-If Analysis Program Cannot Calculate Extended Depreciation Expense (Doc ID 2087472.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Assets - Version 12.1.3 and later
Generic (Platform Independent)

Symptoms

What-If Analysis Program cannot calculate extended depreciation expense for JP-STL and JP-DB assets even if Calculate Extended Depreciation are checked.

Example JP-STL

  1. Addition ***** 2020-12(DEC-20)
    Book Type : XXXXX
    Book Class : CORPORATE
    Asset Number : XXXXXX
    Cost : 1116019
    YTD depreciation amount : 29464
    Accumulated depreciation amount : 780764
    DPIS : 01-APR-2003
    Depren method : JP-STL 23YR
    Salvage value : 10% (111602)
    Depreciation limit amount : 95% (55801)

     

  2. Run Depreciation without Closing Period

  3. Run What-If Analysis Program
    Book : XXXXX
    Currency : JPY
    Start Period : DEC-20
    Number of Period : 120
    Asset Number : XXXXXX
    Analyze Fully Reserved Assets : Check
    Calculate Extended Depreciation : Check

    What-If Depreciation Report
    ===========================
    Period Fiscal New
    Name Year Depreciation Depreciation
    -------- ------- ------------ ------------
    FEB-27 2026 3,683 3,683
    MAR-27 2026 3,241 3,241
    APR-27 2027 0 0 <= Extended depreciation should be started.
    MAY-27 2027 0 0

Example JP-DB

  1. Addition ***** 2020-12(DEC-20)
    Book Type : XXXXX
    Book Class : CORPORATE
    Asset Number : XXXXXX
    Cost : 43609
    YTD depreciation amount : 1228
    Accumulated depreciation amount : 40686
    DPIS : 01-APR-2003
    Depren method : JP-DB 15YR
    Salvage value : 10% (4361)
    Depreciation limit amount : 95% (2181)

     

  2. Run Depreciation without Closing Period

  3. Run What-If Analysis Program
    Book  : XXXXX
    Currency : JPY
    Start Period : DEC-20
    Number of Period : 30
    Asset Number : XXXXXX
    Analyze Fully Reserved Assets : Check
    Calculate Extended Depreciation : Check

    What-If Depreciation Report
    ===========================
    Period Fiscal New
    Name Year Depreciation Depreciation
    -------- ------- ------------ ------------
    AUG-22 2022 28 28
    SEP-22 2022 18 18
    OCT-22 2022 0 0
    NOV-22 2022 0 0
    DEC-22 2022 0 0
    JAN-23 2022 0 0
    FEB-23 2022 0 0
    MAR-23 2022 0 0
    APR-23 2023 0 0 <= Extended depreciation should be started.

Changes

 

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
Changes
Cause
Solution
References


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