R12: Process Impairments Fails with ORA-00001 Error After Depreciation Run Is Run without Closing Period

(Doc ID 2078618.1)

Last updated on NOVEMBER 17, 2015

Applies to:

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


Process Impairments fails with ORA-00001 error after Depreciation Run is run without closing period.
The log file does not have any effective error messages but ORA-00001 error for FA.FA_DEPRN_SUMMARY_U1 occurs in FND debug log.

FND debug log

Reproduced Steps

  1. Addition ***** 2015-04(APR-15)
    Book Type : FA_BOOK
    Book Class : CORPORATE
    Asset Number : FA_BOOK-01
    Cost : 100000
    YTD depreciation amount : 0
    Accumulated depreciation amount : 0
    DPIS : 01-APR-2015
    Depren method : STL-5
    Salvage value : 0
    Depreciation limit amount : 1 JPY


  2. Create Impairment ***** 2015-05(MAY-15)
    Impairment Date : 01-MAY-2015
    Impairment Loss : 2000
    Status : Previewed


  3. Depreciation Run without closing period

  4. Post Impairment
    Process Impairments fails with error.


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