R12.1 to R12.2: FAXWHTIF: What-If Analysis Program Is Showing Incorrect Depreciation Amount At The End Of The Year (Doc ID 1930156.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Assets - Version 12.1 and later
Information in this document applies to any platform.
FAXWHTIF - What-If Analysis Program

Consolidate Duplicate Doc 2026977.1 into

Symptoms

What-If Analysis Program (FAXWHTIF) is showing incorrect depreciation amount at the end of the year when FA_BOOKS.EOFY_RESERVE is null. 

&

is showing incorrect depreciation amount for the last period of the first year.

Steps to Reproduce

[Ex1]
1.  2014-05 *** [Tax Book]Add an asset

        Cost                               : 135500
        YTD depreciation                   : 0
        Accumulated depreciation           : 0
        Date in Service                    : 15-MAY-2014
        Depreciation method                : JP-STL 5YR
        Salvage value                      : 0
        Depreciation limit amount          : 1

        *Daily Prorate
        *Beginning of Jan
        *Deprn allocation code is "Daily" in Book Control


2.  2014-05 *** [Tax Book]Adjustment Salvage value via Tax Upload

        (1) Insert fa_tax_interface

            insert into fa_tax_interface(
                asset_number
                ,book_type_code
                ,salvage_value
                ,posting_status
            )values(
                &asset_number        --asset_number
                ,&book_type_code     --book_type_code
                ,1                   --salvage_value
                ,'POST'              --posting_status
            );

        (2) Run Upload Tax Book Interface


        (3) Check FA_BOOKS

            FA_BOOKS ***
            COST    SALVAGE_VALUE  EOFY_RESERVE
            ------  -------------  ------------
            135500              0             0
            135500              1              <--NULL


3.  2014-05 *** [Tax Book]Run What-If Analysis Program

        What-If Depreciation Report
        ===========================================
        Period   Fiscal                            
        Name     Year             Cost Depreciation
        -------- ------- ------------- ------------
        2014-06  2014         135,500        2,227
        2014-07  2014         135,500        2,302
        2014-08  2014         135,500        2,302
        2014-09  2014         135,500        2,227
        2014-10  2014         135,500        2,302
        2014-11  2014         135,500        2,227
        2014-12  2014         135,500        2,301 <---Correct Value
        2015-01  2015         135,500        2,302
        2015-02  2015         135,500        2,079
        2015-03  2015         135,500        2,302

        It's ONLY showing correct value before closing the period which is period of addition


4.  2014-05 *** [Tax Book]Run Depreciation with period closing


5.  2014-06 *** [Tax Book]Run What-If Analysis Program

        Current Behavior *** What-If Depreciation Report
        ===================================================
        Period   Fiscal                            
        Name     Year             Cost Depreciation
        -------- ------- ------------- ------------
        2014-06  2014         135,500        2,227
        2014-07  2014         135,500        2,302
        2014-08  2014         135,500        2,302
        2014-09  2014         135,500        2,227
        2014-10  2014         135,500        2,302
        2014-11  2014         135,500        2,227
        2014-12  2014         135,500        3,563 <---Wrong Value
        2015-01  2015         135,500        2,302
        2015-02  2015         135,500        2,079
        2015-03  2015         135,500        2,302

        Depreciation amount of 2014-12 should be 2,301, instead of 3,563.

 

[Ex2]

Supplement : This case is NOT reproduced when performing What-If Analysis on the first period of the year

1.  2015-03 *** Addition

    Cost                               : 633235044
    YTD depreciation                   : 20374343
    Accumulated depreciation           : 257728871
    Date in Service                    : 01-APR-2003
    Depreciation method                : JP-STL 26YR
    Salvage value                      : 10%  *63323505
    Depreciation limit amount          : 95%

2.  2015-03 *** Run Depreciation with period close and go to the next year.

3.  2015-04 *** Run What-If Analysis

    (N)Depreciation > What-If Analysis

    What-If Depreciation Report
    Period   Fiscal                
    Name     Year     Depreciation
    -------- -------  ------------
    2015-05  2015      1,852,213+  
    2015-06  2015      1,852,213+  
    2015-07  2015      1,852,213+  
    2015-08  2015      1,852,213+  
    2015-09  2015      1,852,213+  
    2015-10  2015      1,852,213+  
    2015-11  2015      1,852,213+  
    2015-12  2015      1,852,213+  
    2016-01  2015      1,852,213+  
    2016-02  2015      1,852,213+  
    2016-03  2015      1,852,207+  <-- Correct when performing on the first period of the year
    2016-04  2016      1,852,213+  
    2016-05  2016      1,852,213+  
    2016-06  2016      1,852,213+  
    2016-07  2016      1,852,213+  
    2016-08  2016      1,852,213+  
    2016-09  2016      1,852,213+  
    2016-10  2016      1,852,213+  
    2016-11  2016      1,852,213+  
    2016-12  2016      1,852,213+  
    2017-01  2016      1,852,213+  
    2017-02  2016      1,852,213+  
    2017-03  2016      1,852,207+  <-- Correct

 

4.  2015-05 *** Run What-If Analysis

    (N)Depreciation > What-If Analysis

    What-If Depreciation Report
    Period   Fiscal                
    Name     Year     Depreciation
    -------- -------  ------------
    2015-05  2015      1,852,213+  
    2015-06  2015      1,852,213+  
    2015-07  2015      1,852,213+  
    2015-08  2015      1,852,213+  
    2015-09  2015      1,852,213+  
    2015-10  2015      1,852,213+  
    2015-11  2015      1,852,213+  
    2015-12  2015      1,852,213+  
    2016-01  2015      1,852,213+  
    2016-02  2015      1,852,213+  
    2016-03  2015      261433285+  <-- Wrong. It is the last period of the first year.
    2016-04  2016      1,852,213+  
    2016-05  2016      1,852,213+  
    2016-06  2016      1,852,213+  
    2016-07  2016      1,852,213+  
    2016-08  2016      1,852,213+  
    2016-09  2016      1,852,213+  
    2016-10  2016      1,852,213+  
    2016-11  2016      1,852,213+  
    2016-12  2016      1,852,213+  
    2017-01  2016      1,852,213+  
    2017-02  2016      1,852,213+  
    2017-03  2016      1,852,207+  <-- Correct



    [Expected Behaivor]
    In 2016-03, depreciation amount should be 1,852,207, instead of 261433285.

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