Unable to fetch role id using SYS_CONTEXT function

Summary:

Unable to fetch User role id using SYS_CONTEXT function

Content (please ensure you mask any confidential information):

Hi Team,

We have a requirement to find the Role of the Person through which an action is triggered and perform some DSU based on that role.

But when we are using SYS_CONTEXT function to fetch the role in Agent actions, it is not fetching the role id to the assign variable.

This same SQL using SYS_CONEXT works fine when ran via SQL Servlet.

Version (include the version you are using, if applicable):

26B

Code Snippet (add any code snippets that support your topic, if applicable):