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

Last updated on JULY 17, 2017

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

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