Hi, im trying to run this plsql block on IEE
DECLARE
CURSOR CUR_USER_GROUP_USER IS
SELECT
USER_GROUP_API.GET_NAME(USER_GROUP_ID) USER_GROUP_NAME, USER_ID, OBJID,
OBJVERSION
FROM
USER_GROUP_USER
WHERE
USER_ID = &CF$_IDENTITY;
INFO_ VARCHAR2(32000);
OBJID_ VARCHAR2(32000);
OBJVERSION_ VARCHAR2(32000);
SWITCH_ VARCHAR2(5) := &CF$_IS_ACTIVE;
ATTR_ VARCHAR2(32000);
V_ROWCOUNT NUMBER;
BEGIN
NULL;
END;
but i get the error message of the title with no information on what permissions i need
this is the whole error message
Server error messages:
3937c6d5-7f86-46fd-b470-b5f7fe7d18d0
Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-06550: line 10, column 12:
PL/SQL: ORA-01031: insufficient privileges
Failed executing statement (ORA-06550: line 10, column 12:
PL/SQL: ORA-01031: insufficient privileges
ORA-06550: line 9, column 3:
PL/SQL: SQL Statement ignored)
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(CommandBehavior behavior)