Calculate Gains And Losses Fails With ORA-1427 In Function Igi_iac_reinstate_pkg.Do_iac_reinstatement
(Doc ID 399546.1)
Last updated on MARCH 19, 2019
Applies to:Oracle Public Sector Financials (International) - Version 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
Oracle Assets - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:FARET - Calculate Gains and Losses
Calculate Gains and Losses fails with the following error in the logfile, for assets which were reinstated following a previous backdated retirement:-
ORA-01427: single-row subquery returns more than one row
Error: function IGI_IAC_REINSTATE_PKG.Do_Iac_Reinstatement : Full returned failure
Error: function IGI_IAC_REINSTATE_PKG.Do_Iac_Reinstatement returned failure
Retirement ID: #### Asset Number: ##### --> ** FAILED **
Error: function l_calling_fn(Calling IAC) returned failure
Error: function FA_GAINLOSS_PKG.do_calc_gainloss_asset returned failure
<Patch:5346846> has been applied.
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