Skip to main content

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 @SANJ,

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 @SANJ 

 

Try to refresh dictionary and security cache:

Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'FULL');

Security_SYS.Refresh_Active_List__(1);


Hi @Charith Epitawatta , @knepiosko ,

Thanks for your reply.

Finally i restarted Application server followed by providing all the grants again and it worked.

Thanks,

Sanjay