What-If Is Showing Wrong Amount for Asset Which Impairment Is Posted in Current Year When Temporary Close in Last Period of Year (Doc ID 2125169.1)

Last updated on MARCH 16, 2023

Applies to:

Symptoms

What-If Report is showing wrong amount for asset which Impairment is posted in the current year when temporary close in the last period of the year.

Condition

• Depreciation method is JP-DB XXYR
• Impairment is posted in the current year
• Temporary close in the last period of the year
• After applying 22885112:R12.FA.B including FAWDPRB.pls 120.21.12010000.26 in R12.1

Steps to Reproduce
1.  2020-03 *** Addition

    Cost                        : 395400
    YTD depreciation            : 5962
    Accumulated depreciation    : 344345
    Date in Service             : 01-APR-2003
    Depreciation method         : JP-DB 19YR
    Salvage value               : 10%
    Depreciation limit amount   : 95%


2.  2020-06 *** Impairment

    Impairment amount   : 100


3.  2021-03 *** What-If Analysis

    ----------------------------------------------
    Start Period : 2021-03
    Analyze Fully Reserved Assets   : Yes
    Calculate Extended Depreciation : Yes
    ----------------------------------------------

    What-If Depreciation Report ***
    Period   Fiscal          New
    Name     Year    Depreciation
    -------- ------- ------------
    2021-03  2020            468   <-- Correct
    2021-04  2021            426
    2021-05  2021            426
    2021-06  2021            426
    2021-07  2021            426
    2021-08  2021            426
    2021-09  2021            426
    2021-10  2021            426
    2021-11  2021            426
    2021-12  2021            426
    2022-01  2021            426
    2022-02  2021            426
    2022-03  2021            420
    2022-04  2022            377
    2022-05  2022            377

    FA_BOOKS ***
    COST    ADJUSTED_COST  DEPRN_METHOD  EOFY_RESERVE  EOFY_ADJ_COST
    ------  -------------  ------------  ------------  -------------
    395400          10978  JP-DB 19YR          344882          17477
    395400           9438  JP-DB 19YR          344882              

    FA_DEPRN_SUMMARY ***
    PERIOD   COUNTER  DEPRN_AMOUNT  DEPRN_RESERVE  ADJUSTED_COST
    -------  -------  ------------  -------------  -------------
    2020-02    24239             0         344345          17477
    2020-03    24240           537         344882          17477
    2020-04    24241           480         345362          10978
    2020-05    24242           480         345842          10978
    2020-06    24243           480         346322          10978
    2020-07    24244           465         346787           9438
    2020-08    24245           465         347252           9438
    2020-09    24246           465         347717           9438
    2020-10    24247           465         348182           9438
    2020-11    24248           465         348647           9438
    2020-12    24249           465         349112           9438
    2021-01    24250           465         349577           9438
    2021-02    24251           465         350042           9438


4.  Run Depreciation WITHOUT closing the period (=Temporary close)


5.  2021-03 *** What-If Analysis

    ----------------------------------------------
    Start Period : 2021-03
    Analyze Fully Reserved Assets   : Yes
    Calculate Extended Depreciation : Yes
    ----------------------------------------------

    What-If Depreciation Report ***
    Period   Fiscal          New
    Name     Year    Depreciation
    -------- ------- ------------
    2021-03  2020            478     <--Wrong.  It should be 468
    2021-04  2021            425     <--Wrong.  It should be 426
    2021-05  2021            425     <--Wrong.  It should be 426
    2021-06  2021            425     <--Wrong.  It should be 426
    2021-07  2021            425     <--Wrong.  It should be 426
    2021-08  2021            425     <--Wrong.  It should be 426
    2021-09  2021            425     <--Wrong.  It should be 426
    2021-10  2021            425     <--Wrong.  It should be 426
    2021-11  2021            425     <--Wrong.  It should be 426
    2021-12  2021            425     <--Wrong.  It should be 426
    2022-01  2021            425     <--Wrong.  It should be 426
    2022-02  2021            425     <--Wrong.  It should be 426
    2022-03  2021            429     <--Wrong.  It should be 420
    2022-04  2022            377    
    2022-05  2022            377    

    FA_BOOKS ***
    COST    ADJUSTED_COST  DEPRN_METHOD  EOFY_RESERVE  EOFY_ADJ_COST
    ------  -------------  ------------  ------------  -------------
    395400          10978  JP-DB 19YR          344882          17477
    395400           5250  JP-DB 19YR          350510           9438

    FA_DEPRN_SUMMARY ***
    PERIOD   COUNTER  DEPRN_AMOUNT  DEPRN_RESERVE  ADJUSTED_COST
    -------  -------  ------------  -------------  -------------
    2020-02    24239             0         344345          17477
    2020-03    24240           537         344882          17477
    2020-04    24241           480         345362          10978
    2020-05    24242           480         345842          10978
    2020-06    24243           480         346322          10978
    2020-07    24244           465         346787           9438
    2020-08    24245           465         347252           9438
    2020-09    24246           465         347717           9438
    2020-10    24247           465         348182           9438
    2020-11    24248           465         348647           9438
    2020-12    24249           465         349112           9438
    2021-01    24250           465         349577           9438
    2021-02    24251           465         350042           9438
    2021-03    24252           468         350510           9438  <-- Actual value

Changes

Cause

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