My Oracle Support Banner

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

Last updated on AUGUST 25, 2020

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
----------------------------------------
NOTE: In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
----------------------------------------

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

 

Changes

 

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
Changes
Cause
Solution
References


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