R12 FAXWHTIF: Depreciation What-If Analysis Calculates Wrong Depreciation Amount with Divide Depreciation By Days (Doc ID 1671589.1)

Last updated on MARCH 04, 2019

Applies to:

Symptoms

When attempting to What-If Analysis for STL 1 month asset on Book Controls with Divide Depreciation being "By Days", depreciation amount is wrong.

Steps to Reproduce:
1.  (N)Setup > Asset System > Book Controls

    - Depreciation Calendar : *Monthly
    - Prorate Calendar      : *Daily
    - Divide Depreciation   : By Days  *****Point*****


2.  Apr-2013 *** Add an asset

    Cost                      : 20000
    YTD depreciation          : 0
    Accumulated depreciation  : 0
    Date in Service           : 15-APR-2013
    Depreciation method       : STL 1 month
    Salvage value             : 0
    Depreciation limit amount : 0
    Prorate Convention        : *Monthly


3.  Apr-2013 *** Run Depreciation without period close

    FA_DEPRN_SUMMARY ***
    PERIOD    PERIOD_COUNTER   DEPRN_AMOUNT   YTD_DEPRN   DEPRN_RESERVE
    -------   --------------   ------------   ---------   -------------
    2013-03            24159           0.00        0.00            0.00
    2013-04            24160       20000.00    20000.00        20000.00


4.  Apr-2013 *** What-If Analysis

    (N)Depreciation > What-If Analysis
    Analyze Fully Reserved Assets : Yes

    What-If Report
    =======================================
    Period   Fiscal  Life                       New
    Name     Year    (Mos) Depreciation Depreciation
    -------- ------- ----- ------------ ------------
    2013-04  2013       1     19,726.03    19,726.03  *Wrong
    2013-05  2013       1        273.97       273.97  *Wrong
    2013-06  2013       1          0.00         0.00

    * Depreciation should be 20,000.00 because Depreciation method is STL 1 months.


    Expected Behavior on What-If Report
    =======================================
    Period   Fiscal  Life                       New
    Name     Year    (Mos) Depreciation Depreciation
    -------- ------- ----- ------------ ------------
    2013-04  2013       1     20,000.00    20,000.00 *Correct
    2013-05  2013       1          0.00         0.00 *Correct
    2013-06  2013       1          0.00         0.00

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.