My Oracle Support Banner

R12 FARET Calculate Gain and Losses Fails With ORA-1403 For Asset Retired in Year of Addition With Daily Prorate (Doc ID 1669972.1)

Last updated on MARCH 09, 2021

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
FARET - Calculate Gain and Losses


Symptoms

On Release 12.1.3,

When attempting to run Calculate Gains & Losses program for processing a Retirement ,
the following error occurs.

ERROR
-----------------------
ORA-01403: no data found
Error: function FA_GAINLOSS_UPD_PKG.farboe 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 XXXXXXX

Cause: You have a database problem.

Action: Contact your system administrator.

FAGRET: Fail to retire asset XXXXXXX

Cause: You have a database problem.

Action: Contact your system administrator.

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Retirement ID: #### Asset Number: XXXXXXX --> ** Failed **
The Asset Id is XXXXXXX

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log to FA responsibility
2. Retire an asset  with date retired equal Date Placed in Service .
3. Run Calculate Gains&Losses program.


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
 Still Have Questions?
References


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