FA.R12: Tax Book - Calculate Gain/Loss Program Ends With Error (Doc ID 2458586.1)

Last updated on AUGUST 27, 2019

Applies to:

Symptoms

 Error received when running the Calculate Gain and Loses program, Tax Book , for fully retired asset.

"At beginning of Calculate Gain/Loss program Book: xxxxx Request ID: 40860644 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 116800
Cause: You have a database problem.
Action: Contact your system administrator.
FAGRET: Fail to retire asset 116800
Cause: You have a database problem.
Action: Contact your system administrator.
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure Retirement ID: 1611355 Asset Number: 116800 --> ** Failed **"

Cause

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