Tax Book Depreciation Run Fails with ORA-00001: unique constraint (FA.FA_DEPRN_DETAIL_U1) violated
(Doc ID 2812924.1)
Last updated on OCTOBER 13, 2021
Applies to:Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.
When running depreciation for Tax book, the following error occurs
APP-OFA-48208: fadpaa: before fadaid: method: has the value of STL.
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
The issue can be reproduced at will with the following steps:
- Fixed Assets Responsibility
- Depreciation > Run depreciation
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