Periodic Mass Copy (FAMCP) or Calculate Gains/Losses (FARET) Errors with ORA-01403 for Asset Retirements (Doc ID 1579267.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Assets - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
This knowledge document is a replacement for 1579274.1 which has been deleted.

Symptoms

On : 12.1.3 version, FA Addition

A) Periodic Mass Copy Errors with ORA-01403 on asset retirements.

ERROR
-----------------------
ORA-01403: no data found
Error: function FA_GAINLOSS_UPD_PKG.farboe returned failure
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
User-Defined Exception
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
FAGPDP: Fail to insert Depreciation adjustments for asset 10761774

Cause:        You have a database problem.

Action:        Contact your system administrator.

FAGRET: Fail to retire asset 10761774

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Error: function FA_RETIREMENT_PUB.calculate_gain_loss returned failure
Error: function FA_RETIREMENT_PUB.do_retirement returned failure
Mass Copy failed on this asset and transaction. Please review log file for more information.
Error: function fa_masscp_pkg.mcp_retirement returned failure
Error: function fa_masscp_pkg.do_mass_copy returned failure


OR


B) Calculate Gains/Losses (FARET) ended in error for Back-dated Overlapped Retirement:

ERROR
-----------------------
Error: function FA_GAINLOSS_UPD_PKG.farboe returned failure
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
User-Defined Exception
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
FAGPDP: Fail to insert Depreciation adjustments for asset 10761774

FAGRET: Fail to retire asset 10761774

ORA-01403: no data found


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