Hi Team,
We are getting the below error while login to IFS Test Apps 8 after we refresh from PROD data. Did anyone got this issue? Any suggestion please?
Thanks,
Sanjay
Hi Team,
We are getting the below error while login to IFS Test Apps 8 after we refresh from PROD data. Did anyone got this issue? Any suggestion please?
Thanks,
Sanjay
Hi
Looks like some of the privileges have been revoked after the refresh. Do you get this error when logging in as Application Owner as well? Please try running following scripts:
Logged in as SYS:
BEGIN
Prepare_SYS.Dbagrant('&APPOWNER’);
END;
Logged in as Application Owner:
BEGIN
Installation_SYS.Grant_Ifssys(TRUE);
END;
BEGIN
Fndbas_Installation_API.Post_Installation_Object;
END;
BEGIN
Fndbas_Installation_API.Post_Installation_Data;
END;
Hope this helps!
Hi Charith,
Thanks for your reply.
I ran the above scripts except the below two seems they are not available for Apps8, but still the same issue and I am getting this error with every user id including AO.
BEGIN
Fndbas_Installation_API.Post_Installation_Object;
END;
BEGIN
Fndbas_Installation_API.Post_Installation_Data;
END;
Thanks,
Sanjay
Hi
Try to refresh dictionary and security cache:
Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'FULL');
Security_SYS.Refresh_Active_List__(1);
Hi
Thanks for your reply.
Finally i restarted Application server followed by providing all the grants again and it worked.
Thanks,
Sanjay
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.