R12: What-If Analysis Program Calculates Wrong Amount for JP-250DB Assets Which Use Revised Rate Next Year (Doc ID 2203749.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-250DB assets.
This issue occurs at following conditions.

Reproduced Steps

  1. Addition ***** 2017-07(JUL-17)
    Book Type : FA_BOOK
    Asset Number : FA_BOOK-01
    Cost : 290600
    YTD depreciation amount : 3681
    Accumulated depreciation amount : 235376
    DPIS : 21-SEP-2011
    Depren method : JP-250DB 10
    Salvage value : 0
    Depreciation limit amount : 1 JPY


  2. Impairment ***** 2017-08(AUG-17)
    Impairment Date : 01-AUG-2017
    Impairment Loss : 1000


  3. What-If Analysis Program ***** 2017-09(SEP-17)
    Book : FA_BOOK
    Currency : JPY
    Star Period : SEP-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
    -------- ------- ------------ ------------
    SEP-17 2017 1,079+ 1,079+
    OCT-17 2017 1,079+ 1,079+
    NOV-17 2017 1,079+ 1,079+
    DEC-17 2017 1,079+ 1,079+
    JAN-17 2017 1,079+ 1,079+
    FEB-17 2017 1,079+ 1,079+
    MAR-17 2017 1,073+ 1,073+
    APR-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    MAY-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    JUN-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    JUL-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    AUG-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    SEP-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    OCT-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    NOV-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    DEC-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    JAN-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    FEB-18 2018 1,203+ 1,203+ <- Incorrect should be 1231
    MAR-18 2018 1,203+ 1,203+ <- Incorrect should be 1229
    APR-19 2019 1,203+ 1,203+ <- Incorrect should be 1231

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