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
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 ######
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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |