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

Last updated on MAY 24, 2023

Applies to:

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 calendar
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

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