Asset Reinstatement Error: Function FA_GAINLOSS_PKG.do_calc_gainloss_asset Returned Failure (Doc ID 2354726.1)

Last updated on JULY 14, 2024

Applies to:

Symptoms

On : 12.2.7 version, Retirement & Reinstatement

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure when Reinstate Asset

ERROR
-----------------------
ORA-01403: no data found
Error: function FA_AMORT_PVT.GetDeprnRec returned failure
Error: function FA_AMORT_CALC_PVT.Recalculate returned failure
User-Defined Exception
Error: function FA_AMORT_PVT.faxama returned failure
Error: function fa_gainloss_dpr_pkg.CALC_CATCHUP returned failure
Error: function FA_GAINLOSS_UND_PKG.fagrin returned failure
FAGRIN: Fail to reinstate asset XXXXXXXXXXX

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: 100x Asset Number: XXXXXXXXXXX --> ** Failed **


Steps to Reproduce:

Using responsibility such as Fixed Assets Manager which has the ability to retire and reinstate assets:

1)  Query a retired asset up in the Asset Workbench

Menu:  Assets : Asset Workbench, query by asset number

2)  Choose the Retirements button

3)  Do a Find F11 to find the retirement on this asset which needs reinstatement.

4)  Choose the Reinstate button.

5)  Run Calculate Gains and Losses.

Menu:  Other : Requests : Run

Cause

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