Clicking On Actions then Prepare Mass Additions Automatically on NEW Lines Gets the Error "FA_MASSADD_PREPARE_PKG.prepare_mass_additions ORA-01426: numeric overflow" (Doc ID 2213686.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Acquire Assets-Record Asset Acquisition

After having enabled all 5 of the Prepare Mass Additions Automatically lookup codes:
ORA_FA_MASSADD_MAP_EXP_ACCT ORA_CATEGORY_EXPENSE_ACCT
ORA_FA_MASSADD_MAP_EXP_BASE ORA_CLEARING_ACCOUNT_CCID
ORA_FA_MASSADD_MAP_EXP_BSV ORA_CLEARING_ACCOUNT_BSV
ORA_FA_MASSADD_MAP_EXP_CC ORA_CLEARING_ACCOUNT_CC
As well as the FA_MAS_ADD_PREPARE_RULES lookup and then trying to click on Actions > Prepare Mass Additions Automatically on NEW lines, the following error occurs in the log file:

ERROR
-----------------------
FA_MASSADD_PREPARE_PKG.prepare_mass_additions
ORA-01426: numeric overflow

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