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 JUNE 05, 2017

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 GBL_103657-1

Cause: You have a database problem.

Action: Contact your system administrator.

FAGRET: Fail to retire asset XXXXXXXXXXXXXXX

Cause: You have a database problem.

Action: Contact your system administrator.

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

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.


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