R12: Process Impairments Fails with ORA-01476 Error for JP-STL-EXTND Asset Which Adjusted Cost Is 0 Amount (Doc ID 2078654.1)

Last updated on NOVEMBER 18, 2015

Applies to:

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

Symptoms

Process Impairments fails with ORA-01476 error for JP-STL-EXTND asset which Adjusted Cost is 0 amount.

Log file

 

Reproduced Steps

  1. Addition ***** 2015-08(AUG-15)
    Book Type : FA_BOOK
    Asset Number : FA_BOOK-01
    Cost : 401025000
    YTD depreciation amount : 0
    Accumulated depreciation amount : 401024999
    DPIS : 30-SEP-1990
    Depren method : JP-STL-EXTND
    Salvage value : 0
    Depreciation limit amount : 1 JPY
    Period when fully reserved : MAR-06
    First Period of Extend Depreciation : APR-07
    Earlier Depreciation Method : JP-DB 5YR
    Earlier Depreciation Limit : Amount
    Limit Amount : 1
    Percent : Null

     => Adjusted Cost is created as 0 amount.  ※Adjusted Cost= Earlier Depreciation Limit - 1  = 1-1  = 0

  2. Create Impairment ***** 2015-09(SEP-15)
    Book :  FA_BOOK
    Impairment Date :  01-SEP-2015
    Asset Number :  FA_BOOK-01
    Impairment Loss :  1

     

  3. Post Impairment
    Process Impairments fails with ORA-01476 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