R12 FA: Calculate Gain and Loss ends with ORA-01403 Error (Doc ID 2746912.1)

Last updated on JANUARY 26, 2021

Applies to:

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

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