FARET ORA-01400 Cannot Insert Null Into FA.Fa_Adjustments.Adjustment_Amount (Doc ID 2044145.1)

Last updated on MARCH 07, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Calculate Gains and Losses fails with error:

FARET module: Calculate Gains and Losses

At beginning of Calculate Gain/Loss program
Book: XXXXXX
Request ID: XXXXXX
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 XXXXXX

Cause:        You have a database problem.

Action:        Contact your system administrator.

FAGRET: Fail to retire asset XXXXXX

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: XXXXXX Asset Number: XXXXXX --> ** Failed **
The Asset Id is XXXXXX
Number of successes: 0
Number of failures: 1
Module Calculate Gain/Loss 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