My Oracle Support Banner

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 AUGUST 23, 2021

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


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:

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 ######

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.




To view full details, 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 a vibrant support community of peers and Oracle experts.