R12 FARET: Calculate Gains and Losses fails on a Member Reinstatement with 'ORA-0001: unique constraint (FA.FA_BOOKS_U1) violated'
Last updated on MARCH 23, 2018
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
Failure of the Calculate Gains and Losses program (FARET) when run either standalone or within the Depreciation Request Set, errors with the following:
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.
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