Script to list users having specific responsibility in Oracle EBS

To list all users having specific responsibilities in Oracle EBS. For example below we are finding “System Administrator” responsibiltiy.

NOTE: IT WILL LIST ALL THOSE USERS WHO ARE NOT END DATED AS WELL AS RESPONSIBILITY IS ALSO NOT END DATED)

set lines 2000
set pages 5000
col USER_NAME for a45
Select b.user_name,b.EMAIL_ADDRESS,B.DESCRIPTION, c.responsibility_name, a.START_DATE, a.END_DATE RES_END_DATE, B.END_dATE USER_END_dATE
from fnd_user_resp_groups_direct a, fnd_user b, fnd_responsibility_tl c
where a.user_id = b.user_id
and a.responsibility_id = c.responsibility_id
and c.responsibility_name='System Administrator'
AND (A.END_DATE IS NULL AND B.END_DATE IS NULL);

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud and AI Architect with over 19 years in Oracle Applications, Databases, and Cloud ecosystems. My work spans large-scale, global projects where I’ve designed and optimized solutions across both Oracle and non-Oracle stacks—on-prem and in the cloud. Lately, my focus has shifted toward integrating AI into enterprise architectures, leveraging GenAI, automation, and data intelligence to drive performance, resilience, and modernization. I’m passionate about exploring emerging AI tools, agentic workflows, and practical use cases—and I'm fortunate that my role gives me space to experiment and share my learnings.

Script to list users having specific responsibility in Oracle EBS

Related posts: