Mass Additions Post Errors With ORA-01476: Divisor Is Equal To Zero

(Doc ID 1934519.1)

Last updated on MARCH 23, 2018

Applies to:

Oracle Assets - Version and later
Information in this document applies to any platform.
FAMAPT - Mass Additions Post


On : version, FA Addition

When attempting to run Post Mass Additions (FAMAPT),
the following error occurs.

ORA-01476: divisor is equal to zero
Error: function FA_INS_ADJUST_PKG.fadoact returned failure
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
Error: function FA_INS_ADJ_PVT.faxiat returned failure
Error: function fa_asset_calc_pvt.calc_fin_info returned failure
Error: function fa_adjustment_pvt.do_adjustment returned failure
Error: function fa_adjustment_pub.do_all_books returned failure
Error: function fa_adjustment_pub.do_adjustment returned failure
Mass Addition ID: XXXXXXX ==> ** FAILED **

The issue can be reproduced at will with the following steps:
1. Submit Post Mass Additions for the corporate book from Mass Additions > Post Mass Additions
2. Verify the log file once the process fails

The issue has the following business impact:
Due to this issue, users cannot post all their mass additions and run Depreciation to close the FA period.


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