Best answer by Tomas Ruderfelt
View originalThere is a system defined method for granting all database objects to IFSINFO so you do not need to grant each object manually.
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.
We got it Thanks Paul
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)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.