R12 FARET: Calculate Gains And Losses Errors With 'ORA-01403: no data found' After Amortized Asset Retirement
(Doc ID 1622362.1)
Last updated on APRIL 03, 2025
Applies to:
Oracle Assets - Version 12.1.3 and laterInformation in this document applies to any platform.
FARET - Calculate Gains And Losses
Symptoms
Calculate Gains and Losses program (FARET) is failing with below error:
Error
-----------------------
ORA-01403: no data found
Error: function FA_AMORT_CALC_PVT.Recalculate returned failure
ORA-01403: no data found
Error: function FA_AMORT_PVT.faxama returned failure
Error: function fa_gainloss_dpr_pkg.CALC_CATCHUP returned failure
Error: function FA_GAINLOSS_UPD_PKG.farboe returned failure
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
User-Defined Exception
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
FAGPDP: Fail to insert Depreciation adjustments for asset 17504
Cause: You have a database problem.
Action: Contact your system administrator.
FAGRET: Fail to retire asset 17504
Cause: You have a database problem.
Action: Contact your system administrator.
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 |
Still Have Questions? |
References |