My Oracle Support Banner

Depreciation Process Ended With ORA-00001 and APP-OFA-47661 (Doc ID 802973.1)

Last updated on MARCH 09, 2020

Applies to:

Oracle Assets - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FADEPR

Symptoms


The Depreciation process ended with ORA-00001, APP-OFA-47661 in the period of impairment.

ERROR:

APP-FND-01564: ORACLE error 1 in fadaid .
Cause: fadaid failed due to ORA-00001: unique constraint (FA.FA_DEPRN_DETAIL_U1) violated .
The SQL statement being executed at the time of the error was: and was executed from the file .
APP-OFA-47661: Error: Unable to insert into FA_DEPRN_DETAIL table .
Cause: You have a database problem. 
Action: Contact your system administrator. .
Distribution ID: XXXXXX.
Distribution ID: XXXXXX.
Error: function fadaid returned failure (called from faddep).
Error: function faddep returned failure (called from FADEPR).
APP-OFA-48208: famcpsob, sob_id has the value of 1. 

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
Cause
Solution
 Still Have Questions?
References

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