FARET Error FAGPRV: Fail to Insert Depreciation Reserve Adjustments for Asset (Doc ID 2040648.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

When running Calculate Gain and Loss request (FARET), following error occurs

Error
---------------

FARET module: Calculate Gains and Losses

Book: XXXXXX
Request 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 YYYYYY

Cause: You have a database problem.

Action: Contact your system administrator.

FAGRET: Fail to retire asset YYYYYY

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: ZZZZZZ Asset Number: YYYYYY --> ** Failed **

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