Fixed Assets Error in Gain or Loss

[navson]

Dear All,
Depreciation on assets cant be performed becuse of gain or loss is not working properly here is the output of log file



+---------------------------------------------------------------------------+
Assets: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FARET module: Calculate Gains and Losses
+---------------------------------------------------------------------------+

Current system time is 02-FEB-2010 16:50:43

+---------------------------------------------------------------------------+






ABL Retirements Execution Report 02/02/2010 16:45:59

At beginning of Calculate Gain/Loss program
Book: ABL CORP BOOK
Request ID: 390329
Cache: Error retrieving row from FA_DEPRN_BASIS_RULES table for:
Fiscal Year Name: ABL Fiscal
Fiscal Year: 2007

Cause: You have a database problem.
Action: Contact your system administrator.
ORA-01403: no data found
Error: function fa_cache_pkg.fazcfy returned failure
User-Defined Exception
Error: function fa_calc_deprn_basis1_pkg.GET_REC_COST returned failure
User-Defined Exception
Error: function fa_calc_deprn_basis1_pkg.GET_EOFY_EOP returned failure
Error: function FA_AMORT_CALC_PVT.Recalculate returned failure
User-Defined Exception
Error: function FA_AMORT_PVT.faxama returned failure
Error: function fa_gainloss_dpr_pkg.CALC_CATCHUP returned failure
Error: function FA_GAINLOSS_UND_PKG.fagrin returned failure
FAGRIN: Fail to reinstate asset 1

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: 1 Asset Number: 1 --> ** Failed **
The Asset Id is 1
Number of successes: 0
Number of failures: 1
Module Calculate Gain/Loss ended with error
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.
Concurrent program returned no reason for failure.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Calculate Gains and Losses" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 02-FEB-2010 16:50:44

+---------------------------------------------------------------------------+

Please help me find the solution.


Regards

Naveed

[AmanKhan]

Check Asset #1 as there is some issue with the asset. Provide the assets detail.

Regards,