FAMCP Periodic Mass Copy ORA-01400 FAGPRV: Fail to Insert Depreciation Reserve Adjustments for Asset (Doc ID 2072642.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running Periodic Mass Copy, the following error occurs:


FAMCP module: Periodic Mass Copy

Transaction header id 
ORA-01400: cannot insert NULL into ("FA"."FA_ADJUSTMENTS"."ADJUSTMENT_AMOUNT")
Error: function FA_INS_ADJUST_PKG.fainajc returned failure
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
Error: function FA_GAINLOSS_UPD_PKG.fagprv returned failure
FAGPRV: Fail to insert Depreciation Reserve adjustments for asset XXXX

Cause: You have a database problem.

Action: Contact your system administrator.

FAGRET: Fail to retire asset XXXX

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Error: function FA_RETIREMENT_PUB.calculate_gain_loss returned failure
Error: function FA_RETIREMENT_PUB.do_retirement returned failure
Mass Copy failed on this asset and transaction. Please review log file for more information.
Error: function fa_masscp_pkg.mcp_retirement returned failure
Error: function fa_masscp_pkg.do_mass_copy returned failure
Number of successes: 0
Number of warnings: 0
Number of failures: 1
Module Periodic Mass Copy ended with 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