My Oracle Support Banner

FARET FAGPRV: Fail to insert Depreciation Reserve adjustments (Doc ID 368557.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Oracle Assets - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FARET


Symptoms

Calculate Gain and Loss (FARET) is ending with this error:

At beginning of Calculate Gain/Loss program
Book: XXXXXXX
Request ID: XXXXX
ORA-01422: exact fetch returns more than requested number of rows
Error: function FA_GAINLOSS_UPD_PKG.fagprv returned failure
FAGPRV: Fail to insert Depreciation Reserve adjustments for asset YYYYYY

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure
FAGRET: Fail to retire asset YYYYYY

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
Retirement ID: ##### Asset Number: YYYYYY --> ** FAILED **
The Asset Id is ####
Number of successes: 0
Number of failures: 1

Module Calculate Gain/Loss ended with error

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
References

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