Hi Friends,
I am getting below technical issue while trying to delete the accounts.
please help me to resolve this.
Server error messages:
87404d55-4935-40d6-ab86-8ab31cd55fdd
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01427: single-row subquery returns more than one row
Failed executing statement (ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 15
ORA-06512: at "IFSAPP.REFERENCE_SYS", line 266
ORA-06512: at "IFSAPP.REFERENCE_SYS", line 266
ORA-06512: at "IFSAPP.ACCOUNT_API", line 4713
ORA-06512: at "IFSAPP.ACCOUNT_API", line 4772
ORA-06512: at "IFSAPP.ACCOUNT_API", line 4778
ORA-06512: at "IFSAPP.ACCOUNT_API", line 1373
ORA-06512: at "IFSAPP.ACCOUNT_API", line 1384
ORA-06512: at line 9)
at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
--- End of inner exception stack trace ---
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(
Regards,
Nagarjuna