R12 FA: Calculate Gain and Loss ends with ORA-01403 Error
(Doc ID 2746912.1)
Last updated on JANUARY 26, 2021
Applies to:
Oracle Assets - Version 12.1.2 and laterInformation in this document applies to any platform.
Symptoms
After asset reinstatement, Calculate Gain and Loss request ends with error.
ERROR
-----------------------
Request ID: 123
ORA-01403: no data found
Error: function FA_INS_ADJUST_PKG.fadoact returned failure
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
Error: function FA_GAINLOSS_UND_PKG.fagtax returned failure
Error: function FA_GAINLOSS_UND_PKG.fagrin returned failure
FAGRIN: Fail to reinstate asset 546
Cause: You have a database problem.
Action: Contact your system administrator.
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: XYZ Asset Number: 546 --> ** Failed **
The Asset Id is 546
Number of successes: 0
Number of failures: 1
Module Calculate Gain/Loss ended with error
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
In Oracle Assets
1. M: Asset>>Asset Workbench, Select RETIREMENT and enter full retirement
2. M: Other>Requests>Run, Run Calculate Gain and Loss
3. M: Asset>>Asset Workbench, Select RETIREMENT and find the prior retirement.
Select REINSTATE
4. M: Other>Requests>Run, Run Calculate Gain and Loss
Find error
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 |