My Oracle Support Banner

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.

Symptoms


When running depreciation for Tax book, the following error occurs

ERROR

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


STEPS

The issue can be reproduced at will with the following steps:

  1. Fixed Assets Responsibility 
  2.  Depreciation > Run depreciation



 

Changes

 

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
Changes
Cause
Solution
References


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