My Oracle Support Banner

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 JANUARY 16, 2023

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 #####

Asset ##### 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.

 

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!

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