FARET Errors ORA-01422: exact fetch returns more than requested number of rows

(Doc ID 358615.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Assets - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
FARET
Calculate Gain and Loss

***Checked for relevance ***12-Mar-2013***


Symptoms

Calculate gain and loss errors with the following error:

ORA-01422: exact fetch returns more than requested number of rows
    Error: function fa_gainloss_mis_pkg.faggbi returned failure
    FAGGBI: Failed to get FA_BOOKS information for asset ######
   
    Cause:        You have a database problem.
   
    Action:        Contact your system administrator.
   
    Error: function fa_gainloss_pro_pkg.fagpsa returned failure
    Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure

Changes

None

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms