My Oracle Support Banner

FARET Error FAGPRV: Fail to Insert Depreciation Reserve Adjustments for Asset (Doc ID 2040648.1)

Last updated on NOVEMBER 11, 2022

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.