YTD Depreciation Is Calculated Wrongly When Posting Impairment in the End of the Year (Doc ID 2119515.1)

Last updated on MARCH 23, 2016

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When adding with YTD depreciation and posting Impairment in the end of the year for the first year,  YTD depreciation is calculated wrongly ignoring initial YTD depreciation.

Condition

Steps to Reproduce
1.  2016-02 *** Addition with YTD and Reserve Depreciation
    
    Cost                               : 100000
    YTD depreciation                   : 30000
    Accumulated depreciation           : 50000
    Date in Service                    : 01-FEB-2015
    Depreciation method                : JP-200DB 10
    Salvage value                      : 0
    Depreciation limit amount          : 1


2.  2016-03 *** Run Depreciation WITHOUT period close

    Deprn Summary ***
    period   counter  deprn_amount  ytd_deprn  deprn_reserve  impairment_reserve
    -------  -------  ------------  ---------  -------------  ------------------
    2016-01    24190             0      30000          50000                   0
    2016-02    24191          1333      31333          51333                   0
    2016-03    24192          1337      32670 <--OK    52670                   0

    Fa_books ***
    cost    adjusted_cost  deprn_method  rate
    ------  -------------  ------------  ----
    100000          47330  JP-200DB 10    0.2


3.  2016-03 *** Post Impairment

    Impairment Loss: 500

    [Result]
    Deprn Summary ***
    period   counter  deprn_amount  ytd_deprn  deprn_reserve  impairment_reserve
    -------  -------  ------------  ---------  -------------  ------------------
    2016-01    24190             0      30000          50000                   0
    2016-02    24191          1333      31333          51333                   0
    2016-03    24192          1337      16000 <-Wrong  52670                 500

    Fa_books ***
    cost    adjusted_cost  deprn_method  rate
    ------  -------------  ------------  ----
    100000          80000  JP-200DB 10    0.2
    100000          46830  JP-200DB 10    0.2


Current behavior
ytd_deprn
    = trunc(adjusted_cost * rate)
    = trunc(80000 * 0.2 )
    = 16000


Expected behavior
ytd_deprn should be 32670, in stead of 16000.


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