R12: What-If Analysis Program Calculates Wrong Amount for Impaired JP-STL-EXTND Assets (Doc ID 2203750.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 amount for impaired JP-STL-EXTND assets.
In FND debug log, What-If Analysis Program could calculate correctly.
However this program inserts wrong amount FA_WHATIF_ITF.

Reproduced Steps

  1. MAR-14 *** Addition
     Book : FA_BOOK
     Asset Number : FA_BOOK-01
     Cost : 636869
     YTD depreciation : 52536
     Accumulated depreciation : 601581
     Date in Service : 01-APR-2003
     Depreciation method : JP-STL 10YR
     Salvage value : 10%
     Depreciation limit amount : 95%


  2. Run Extended Depreciation *** APR-15

  3. Impairment *** JAN-17
    Impairment Date : 01-JAN-2018
    Impairment Loss : 100


  4. Run What-If Analysis Program *** MAR-17
    Book : FA_BOOK
    Currency : JPY
    Star Period : MAR-17
    Number of Period : 3
    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
    -------- ------- ------------ ------------
    MAR-17 2017 231+ 231+ <= Should be 524
    APR-18 2018 228+ 228+ <= Should be 527
    MAY-18 2018 228+ 228+ <= Should be 527

    FND debug log
    FA.PLSQL.faxcde 1 fadpdp(8888*********): perd_deprn_exp has the value of 527
    --------------- - ----------------------------------------------------------
    FA.PLSQL.faxcde 1 perd_bonus_deprn_amount has the value of
    FA.PLSQL.faxcde 1 year_deprn_exp has the value of 5797
    FA.PLSQL.faxcde 1 adj_rec_cost has the value of 636868
    FA.PLSQL.faxcde 1 perd_prod has the value of 0
    FA.PLSQL.faxcde 1 year_prod has the value of 0
    FA.PLSQL.faxcde 1 fadpdp(8): perd_deprn_exp has the value of 527
    FA.PLSQL.faxcde 1 perd_bonus_deprn_amount has the value of
    FA.PLSQL.faxcde 1 year_deprn_exp has the value of 5797


    FA_WHATIF_ITF
    REQUEST_ID ASSET_ID PERIOD_NAME DEPRECIATION NEW_DEPRECIATION
    2073251 907518 MAR-17 231 231
    2073251 907518 APR-18 228 228
    2073251 907518 MAY-18 228 228

     

 

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