My Oracle Support Banner

Calculate Gains and Loss (FARET) Errors with ORA-06508: PL/SQL: could not find program unit being called (Doc ID 2734468.1)

Last updated on DECEMBER 11, 2020

Applies to:

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


When attempting to run Calculate Gain and Loss after partial retirement the following error occurs

Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
Getting Debug information
&MSG1 (MSG1=)
Getting Debug information
&MSG1 (MSG1=)
Retirement ID: 2015137 Asset Number: 111111 --> ** Failed **
The Asset Id is 111111
ORA-06508: PL/SQL: could not find program unit being called
Error: function fa_gainloss_ret_pkg.fagret returned failure




The issue can be reproduced at will with the following steps:
1/ Partially retire an asset (FA > Assets > Assets workbench : Retirement)
2/ Run calculate gain and loss to process the retirement (FA > Depreciation > Calculate Gain and Loss)


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

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