Hello,
I use IFS9 API on SQL Developer. One user get error ORA-20106 Language.NoAccess for Set_Language. How can I set this authority
Hello,
I use IFS9 API on SQL Developer. One user get error ORA-20106 Language.NoAccess for Set_Language. How can I set this authority
Hi
Check the permission sets that were granted to your specific user. Get them loaded in the below window.
Then see which permission sets it has been granted and whether the users have been granted with the permission set residing under “IFS Base Functionality > FndSession > FND_SESSION_API > Set_Language”
If the user doesn’t have that, grant it. Refresh Security Cache and see if that user has access or not.
Best Regards,
Charana
Hello,
I use IFS9 API on SQL Developer. One user get error ORA-20106 Language.NoAccess for Set_Language. How can I set this authority
Hi
If you are using database scripting tool like plsql developer just try to run the following code snippets in command window. It may solve your issue. This is more like clearing the cache in you application in navigator path → refresh cache
DEFINE GRANTEE = IFSSYS
PROMPT Granting to &GRANTEE
BEGIN
Installation_SYS.Grant_Ifssys(TRUE);
END;
/
UNDEFINE GRANTEE
-- /SQL_COMMAND GRANT_TO_FND_PRINTSERVER]
DEFINE GRANTEE = FND_PRINTSERVER
PROMPT Granting to &GRANTEE
BEGIN
Installation_SYS.Grant_Fndprintserver(TRUE);
END;
/
UNDEFINE GRANTEE
DEFINE GRANTEE = FND_WEBCONFIG
PROMPT Granting to &GRANTEE
BEGIN
Installation_SYS.Grant_Ifswebconfig(TRUE);
END;
/
UNDEFINE GRANTEE
-- /SQL_COMMAND GRANT_TO_IAL_OWNER]
DEFINE GRANTEE = IFSINFO
PROMPT Granting to &GRANTEE
BEGIN
Database_SYS.Grant_All_Objects_Ial('&GRANTEE');
END;
/
UNDEFINE GRANTEE
PROMPT Refreshing Dictionary_SYS
EXEC Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'COMPUTE');
PROMPT Refreshing Reference_SYS
EXEC Reference_SYS.Refresh_Active_List__(2);
PROMPT Reinitialize packages
-- This command disables Installation_Mode in Dictionary_SYS
EXEC Dbms_Session.Modify_Package_State(Dbms_Session.Reinitialize);
/
PROMPT Refreshing Security_SYS
EXEC Security_SYS.Refresh_Active_List__(3);
/
PROMPT Refreshing Report_SYS
EXEC Report_SYS.Refresh_Active_List__(4);
Thanks,
Kavindu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.