My Oracle Support Banner

R12: Process Impairments Fails with ORA-00001 Error After Depreciation Run Is Run without Closing Period (Doc ID 2078618.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.


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.


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

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