Last updated on MARCH 24, 2016
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