Skip to main content
Question

Issue while login to IFS Test App8 after Prod Refresh

  • March 4, 2022
  • 4 replies
  • 112 views

Forum|alt.badge.img+6

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

This topic has been closed for replies.

4 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

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!


Forum|alt.badge.img+6
  • Author
  • Sidekick
  • March 4, 2022

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


Forum|alt.badge.img+17
  • Superhero (Partner)
  • March 4, 2022

Hi @SANJ 

 

Try to refresh dictionary and security cache:

Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'FULL');

Security_SYS.Refresh_Active_List__(1);


Forum|alt.badge.img+6
  • Author
  • Sidekick
  • March 4, 2022

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