My Oracle Support Banner

Program Calculate Gains And Losses (FARET) Returned ORA-01422 After Reinstatement (Doc ID 1498593.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
ORA-01422
FARET

Symptoms



When attempting to run Calculate Gains and Losses (FARET) for reinstatement, the following error occurs.

ERROR
-----------------------
ORA-01422: exact fetch returns more than requested number of rows
Error: function fa_util_pvt.get_asset_desc_rec returned failure
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: 11111 Asset Number: 123456 --> ** Failed **
The Asset Id is 123456





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
Cause
Solution


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