Calculate Gains and Losses (FARET) Cache: Error Retrieving Row from FA_CALENDAR_PERIODS Table (Doc ID 1961713.1)

Last updated on MARCH 22, 2016

Applies to:

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

Symptoms

When running FARET module: Calculate Gains and Losses, the following error occurs:

ERROR
-----------------------
Cache: Error retrieving row from FA_CALENDAR_PERIODS table for:
Calendar Type: XXX QUARTER
Fiscal Year: STANDARD
Date: 15-SEP-75

Cause: You have a database problem.
Action: Contact your system administrator.

ORA-01403: no data found
Error: function fa_cache_pkg.fazccp returned failure
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
User-Defined Exception
Error: function FA_GAINLOSS_UPD_PKG.fagpdp returned failure
FAGPDP: Fail to insert Depreciation adjustments for asset XXX

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_ret_pkg.fagret returned failure
FAGRET: Fail to retire asset XXX

Cause:        You have a database problem.

Action:        Contact your system administrator.

Error: function fa_gainloss_pro_pkg.fagpsa returned failure
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: XXX Asset Number: XXX --> ** FAILED **
The Asset Id is XXX
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