R12: Process Impairments Has Error with JP-STL-EXTND Assets Which Has Rollback Impairment (Doc ID 2096536.1)

Last updated on JANUARY 13, 2016

Applies to:

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

Symptoms

Process Impairments has error with JP-STL-EXTND asset which has Rollback Impairment.
When JP-STL-EXTND asset is run Rollback Impairment, the following columns are created with NULL value.

FA_BOOKS.EXTENDED_DEPRECIATION_PERIOD  :  NULL
FA_BOOKS.EXTENDED_DEPRN_FLAG           :  NULL

So, Process Impairments has error.

Reproduced Steps

  1. Addition ***** 2015-04(APR-15)
    Book Type : FA_BOOK
    Book Class : CORPORATE
    Asset Number : FA_BOOK-01
    Cost : 1000000
    YTD depreciation amount : 0
    Accumulated depreciation amount : 950000
    DPIS : 01-APR-2004
    Depren method : JP-STL-EXTND
    Salvage value : 0
    Depreciation limit amount : 1 JPY
  2. Impairment ***** 2015-05(MAY-15)
    Impairment Date : 31-MAY-2015
    Impairment Loss : 20
  3. Run Create Accounting

  4. Rollback Impairment
    The following columns are created with NULL value.

    FA_BOOKS.EXTENDED_DEPRECIATION_PERIOD : NULL
    FA_BOOKS.EXTENDED_DEPRN_FLAG : NULL

  5. Impairment ***** 2015-05(MAY-15)
    Impairment Date : 31-MAY-2015
    Impairment Loss : 20

    Process Impairments has error below.
    Process Impairments log
    User-Defined Exception
    Error: function fa_calc_deprn_basis1_pkg.faxcdb returned failure
    User-Defined Exception
    Error: function fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS returned failure
    User-Defined Exception
    Error: function fa_calc_deprn_basis1_pkg.CALL_DEPRN_BASIS returned failure
    Error: function FA_IMPAIRMENT_POST_PVT.process_post returned failure
    Module FAPIMP ended with error

 

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