R12: What-If Calculates Wrong Amount for JP-200DB Assets Which Does Not Use Revised Rate Next Year (Doc ID 2203762.1)

Last updated on NOVEMBER 15, 2016

Applies to:

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

Symptoms

What-If Analysis Program calculates wrong depreciation expense for JP-200DB assets.
This issue occurs at following conditions.

Reproduced Steps

  1. Addition ***** 2017-08(AUG-17)
    Book Type : FA_BOOK
    Asset Number : FA_BOOK-01
    Cost : 860000
    YTD depreciation amount : 20828
    Accumulated depreciation amount : 411052
    DPIS : 15-JAN-2013
    Depren method : JP-200DB 15
    Salvage value : 0
    Depreciation limit amount : 1 JPY


  2. Impairment ***** 2017-09(SEP-17)
    Impairment Date : 01-SEP-2017
    Impairment Loss : 1000


  3. Run Depreciation Run without period close.


  4. What-If Analysis Program ***** 2017-10(OCT-17)
    Book : FA_BOOK
    Currency : JPY
    Star Period : OCT-17
    Number of Period : 20
    Asset Number : FA_BOOK-01
    Analyze Fully Reserved Assets : Yes
    Calculate Extended Depreciation : Yes

    What-If Depreciation Report
    Period Fiscal New
    Name Year Depreciation Depreciation
    -------- ------- ------------ ------------
    OCT-17 2017 4,849+ 4,849+
    NOV-17 2017 4,849+ 4,849+
    DEC-17 2017 4,849+ 4,849+
    JAN-17 2017 4,849+ 4,849+
    FEB-17 2017 4,849+ 4,849+
    MAR-17 2017 4,853+ 4,853+
    APR-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    MAY-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    JUN-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    JUL-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    AUG-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    SEP-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    OCT-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    NOV-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    DEC-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    JAN-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    FEB-18 2018 4,516+ 4,516+ <- Incorrect should be 4527
    MAR-18 2018 4,512+ 4,512+ <- Incorrect should be 4524
    APR-19 2019 3,915+ 3,915+ <- Incorrect should be 3925
    MAY-19 2019 3,915+ 3,915+ <- Incorrect should be 3925

 

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