You probably need to grant access for user IFSINFO to the QFACT database object.
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)
We got it Thanks Paul
There 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.