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:

Symptoms

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.

Cause

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