Solved

Insufficient Privileges with IAL Object Developer during Deployment

  • 25 September 2020
  • 4 replies
  • 989 views

Userlevel 3
Badge +4

 

 

 

 
Server error messages:
96e44bfa-30b5-4251-b4a4-1ecbad98b48f

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01031: insufficient privileges

Failed executing statement (ORA-01031: insufficient privileges
ORA-06512: at line 21
ORA-06512: at "IFSINFO.IAL_OBJECT_SLAVE_API", line 144
ORA-06512: at line 1
ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2993
ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2997
ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2151
ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2195
ORA-06512: at line 14)
   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)

 

icon

Best answer by Tomas Ruderfelt 30 September 2020, 10:48

View original

4 replies

Userlevel 7
Badge +24

You probably need to grant access for user IFSINFO to the QFACT database object.

Userlevel 3
Badge +4

Paul Thanks.

Now that is done

Getting this error

 

[1:45 PM] Haley Reavis

Server error messages: c70762bb-fd46-4911-bf79-cb0415f64fc1

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01720: grant option does not exist for 'DHPA1APP.QFACT_APPROVE_TO_PAY_IAS$'

Failed executing statement (ORA-01720: grant option does not exist for 'DHPA1APP.QFACT_APPROVE_TO_PAY_IAS$' ORA-06512: at line 21 ORA-06512: at "IFSINFO.IAL_OBJECT_SLAVE_API", line 144 ORA-06512: at line 1 ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2993 ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2997 ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2153 ORA-06512: at "DHPA1APP.IAL_OBJECT_API", line 2195 ORA-06512: at line 14)    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)

 

 

Userlevel 3
Badge +4

We got it Thanks Paul

 

Userlevel 7
Badge +18

There is a system defined method for granting all database objects to IFSINFO so you do not need to grant each object manually.

  1. Login as appowner.
  2. Run PLSQL block below.

BEGIN
  Database_SYS.Grant_All_Objects_Ial('IFSINFO');
END;

 

This method grants all packages, views and tables that the appowner owns to user IFSINFO,

using “WITH GRANT OPTION” on all grants.

 

This method is run when you install a delivery from IFS but if you have created own database objects after last delivery you can run this manually.

Reply