My Oracle Support Banner

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 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Assets - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
EXECUTABLE:FARET - Calculate Gains and Losses


Symptoms

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

Changes

<Patch:5346846> has been applied.

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
References

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