My Oracle Support Banner

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 later
Information in this document applies to any platform.


After asset reinstatement, Calculate Gain and Loss request ends with 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

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.
4. M: Other>Requests>Run, Run Calculate Gain and Loss
  Find error




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

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