R12: Wrong Adjusted_Cost While Extending Assets With Impairment (Doc ID 1951769.1)

Last updated on MARCH 24, 2016

Applies to:

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

Symptoms

When impairment assets change to JP-STL-EXTND, ADJUSTED_COST is incorrect.
ADJUSTED_COST should be based on book value which include impairment in this operation.
This issue occurred with both JP-STL XX YR assets and JP-DB XX YR assets.

 Ex. JP-STL XX YR

  1. Addition ***** 2014-02(FEB-14)
     
     Book Type  FA_BOOKS
     Book Class  CORPORATE
     Asset Number  FA_BOKKS-01
     Cost  10000
     YTD depreciation amount  9000
     Accumulated depreciation  9000
     DPIS  01-APR-2005
     Depren method  JP-STL 29YR
     Salvage value  10%
     Depreciation limit amount  95%

     

  2. Impairment ***** 2014-03(MAR-13)
    Impairment Date  :  31-MAR-2014
    Impairment Loss  :  600

  3. Run Extended Depreciation ***** 2014-04(APR-14)
     
    TRANSACTION
    HEADER_ID_IN
    COSTADJUSTED_COSTDEPRN_METHOD
    CODE
    ALLOWED_DEPRN
    LIMIT_AMOUNT
    365394 10000 9000 JP-STL 29YR 500
    365414 10000 -655 JP-STL 29YR 500
    365424 10000 944 JP-STL-EXTND 1

      Expected behavior
     ------------------------
      ADJUSTED_COST = COST - DEPRN_RESERVE - IMPAIRMENT_RESERVE - ALLOWED_DEPRN_LIMIT_AMOUNT
                                    = 10000 - 9055 - 600 - 1
                                    = 344

 Ex. JP-DB XX YR

  1. Addition ***** 2014-02(FEB-14)
     
    Book Type FA_BOOKS
    Book Class CORPORATE
    Asset Number FA_BOOKS-02
    Cost 10000
    YTD depreciation amount 9000
    Accumulated depreciation 9000
    DPIS 01-APR-2005
    Depren method JP-DB 29YR
    Salvage value 10%
    Depreciation limit amount 95%

     

  2. Impairment ***** 2014-03(MAR-13)
    Impairment Date  :  31-MAR-2014
    Impairment Loss  :  600

  3. Run Extended Depreciation ***** 2014-04(APR-14)
     
    TRANSACTION
    HEADER_ID_IN
    COSTADJUSTED_COSTDEPRN_METHOD
    CODE
    ALLOWED_DEPRN
    LIMIT_AMOUNT
    365425 10000 9000 JP-DB 29YR 500
    365445 10000 -730 JP-DB 29YR 500
    365455 10000 869 JP-STL-EXTND 1

      Expected behavior
     -----------------------
      ADJUSTED_COST = COST - DEPRN_RESERVE - IMPAIRMENT_RESERVE - ALLOWED_DEPRN_LIMIT_AMOUNT
                                    = 10000 - 9130 - 600 - 1
                                    = 269

 

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