Post Mass Additions (FAMAPT) Errors With ORA-01400 'Cannot insert NULL into ("FA"."FA_ADDITIONS_B"."CURRENT_UNITS")' (Doc ID 552281.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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


Symptoms

FAMAPT - Mass Additions Post errors with:

ORA-01400: cannot insert NULL into ("FA"."FA_ADDITIONS_B"."CURRENT_UNITS")
Error: function fa_additions_pkg.insert_row returned failure
ORA-01400: cannot insert NULL into ("FA"."FA_ADDITIONS_B"."CURRENT_UNITS")
Error: function fa_addition_pvt.insert_asset returned failure
Error: function fa_addition_pub.do_addition returned failure
Mass Addition ID: ######## ==> ** FAILED **

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