FA_IMPAIR_UPLOAD_WARN Error Cccurs When Attempting to Perform a Second Impairment for a Fully Reserved Asset with JP-STL-EXTND (Doc ID 2207850.1)

Last updated on NOVEMBER 27, 2016

Applies to:

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

Symptoms

The following error occurs during uploading impairment via WebADI when attempting to perform a second impairment for a fully reserved asset with JP-STL-EXTND.

Error
Impairment cannot be charged for asset &FA_ASSET_ID as the NBV after considering current month depreciation is either zero or less than impairment loss.
(= FA_IMPAIR_UPLOAD_WARN)

Steps to Reproduce

1.  2015-03 *** Addition of a fully reserved asset with JP-STL-EXTND

    Cost                                : 10000
    YTD depreciation                    : 0
    Accumulated depreciation            : 9999
    Date in Service                     : 01-APR-2000
    Depreciation method                 : JP-STL-EXTND
    Salvage value                       : 0
    Depreciation limit amount           : 1
    -- (T)Japan Asset Additional info
    First Period of Extend Depreciation : 2007-04
    Earlier Limit Amount                : 95%


2.  2015-05 *** Setting override

    Override Amount : -1


3.  2015-05 *** 1st impairment

    Impairment Amount : 1


4.  2015-05 *** After posting 1st impairment

    fa_deprn_summary ***
    period  counter deprn_amount ytd_deprn deprn_reserve impairment_reserve
    ------- ------- ------------ --------- ------------- ------------------
    2015-02   24179            0         0          9999                  0
    2015-03   24180            0         0          9999                  0
    2015-05   24182           -1        -1          9998                  1

    fa_books ***
    cost  adjusted_cost deprn_method rate period_counter_fully_extended
    ----- ------------- ------------ ---- -----------------------------
    10000           499 JP-STL-EXTND   60                         24180
    10000             0 JP-STL-EXTND   60                         24182


5.  2015-07 *** 2nd impairment with Preview

    Impairment Amount : 1


Result
FA_IMPAIR_UPLOAD_WARN error occurs:

fa_itf_impairments ***
net_book_value deprn_amount impairment_amount
-------------- ------------ -----------------
             0            1                 1


deprn_amount should be 0, instead of 1.  Because this is a fully reserved asset and must not depreciate it.

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