R12.1.x Calculate Gain And Loss (FARET) Ends In Error 'ORA-01476: divisor is equal to zero'

(Doc ID 1582272.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Assets - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
FARET module: Calculate Gains and Losses


Symptoms

On : 12.1.3 version, Retirement & Reinstatement

Calculate Gain and Loss program (FARET) errors out while closing the period in FA.

When running Calculate Gain and Loss Program the following error occurs:

ERROR
-----------------------
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_UND_PKG.fagrin returned failure
FAGRIN: Fail to reinstate asset 2119578


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Reinstate an asset (Asset Workbench > Retirements form).
2. Run Calculate Gain/Loss (FARET).
3. FARET ends in ORA-01476 error.

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