My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2018

Applies to:

Oracle Assets - Version 12.2.7 and later
Information in this document applies to any platform.


On : 12.2.7 version, Retirement & Reinstatement

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure when Reinstate Asset

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 01OE170000005

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




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.