11.5.10.x FARET - Calculate Gains Losses: Zero Cost Asset ORA-01476: Divisor Is Equal To Zero (Doc ID 1680138.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

FARET - Calculate Gains and Losses errors with the following on a $0 cost asset which has a retirement backdated to the DPIS date:

ORA-01476: divisor is equal to zero
Error: function FA_AMORT_CALC_PVT.Recalculate returned failure
ORA-01476: divisor is equal to zero
Error: function FA_AMORT_PVT.faxama returned failure
Error: function fa_gainloss_dpr_pkg.CALC_CATCHUP returned failure
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

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

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
Getting Debug information
FA_GAINLOSS_PKG.do_calc_gainlo: +++ Step 1 +++ has the value of
FA_GAINLOSS_PKG.do_calc_gainlo: +++ Step 2 +++ has the value of
FA_GAINLOSS_PKG.do_calc_gainlo: l_asset_hdr_rec.asset_id has the value of
FA_GAINLOSS_PKG.do_calc_gainlo: l_asset_hdr_rec.book_type_code has the value of
FA_GAINLOSS_PKG.do_calc_gainlo: current_period: l_period_rec.period_name has the value of
FA_GAINLOSS_PKG.do_calc_gainlo: Passed basic validation has the value of
FA_GAINLOSS_PKG.do_calc_gainlo: l_asset_retire_rec.cost_retired has the value of 0

Changes

Running code:

FA_AMORT_PVT
FAVAMRTB.pls     
115.258.258.18 or prior.

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