R12.1 thru R12.2: YTD Depreciation Is Calculated Wrongly When Posting Impairment in the End of the Year (Doc ID 2119515.1)

Last updated on JANUARY 18, 2023

Applies to:

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

• FA: Annual Rounding = Always
• Adding with YTD depreciation
• Posting Impairment in the end of the year

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.

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.