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.

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




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!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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