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

Last updated on DECEMBER 14, 2015

Applies to:

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

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 : FA_JP-STL_BK
    Book Class : CORPORATE
    Asset Number : FA_JP-STL_BK-01
    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 : FA_JP-STL_BK
    Currency : JPY
    Start Period : DEC-20
    Number of Period : 120
    Asset Number : FA_JP-STL_BK-01
    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 : FA_JP-DB_BK
    Book Class : CORPORATE
    Asset Number : FA_JP-DB_BK-01
    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  : FA_JP-DB_BK 
    Currency : JPY
    Start Period : DEC-20
    Number of Period : 30
    Asset Number : FA_JP-DB_BK-01
    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.

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