My Oracle Support Banner

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

Last updated on AUGUST 25, 2020

Applies to:

Oracle Assets - Version 12.1.3 and later
Generic (Platform Independent)

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  XXXX
     Book Class  CORPORATE
     Asset Number  YYYY
     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 XXXX
    Book Class CORPORATE
    Asset Number ZZZZ
    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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
 Still Have Questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.