R12 FARET: Calculate Gains and Losses fails on a Member Reinstatement with 'ORA-0001: unique constraint (FA.FA_BOOKS_U1) violated' (Doc ID 1936729.1)

Last updated on MARCH 24, 2016

Applies to:

Oracle Assets - Version 12.1.2 and later
Information in this document applies to any platform.
FAXASSET.fmb - Asset Workbench form
FARET - Calculate Gains and Losses

Symptoms

Failure of the Calculate Gains and Losses program (FARET) when run either standalone or within the Depreciation Request Set, errors with the following:

Error
-----------------------
ORA-0001:  unique constraint (FA.FA_BOOKS_U1) violated

Error:  function FA_GAINLOSS_UND_PKG.fagiat returned failure

Error:  function FA_GAINLOSS_UND_PKG.fagrin returned failure

FAGRIN:  Fail to reinstate asset 12345

Asset 12345 is a member of a Group Asset.

Since member reinstatement are not realized through Calculate Gains and Losses, but are realized as part of the transaction when they are input, this failure should not occur.

 

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