Count of EBS users having responsibilities linked to applications

The below script can be used to find the count of users linked to each EBS application. You can also filter and get information for the specific application.

select apl.application_name,
decode(ins.status,
'I',
'Installed',
'S',
'Shared',
'N',
'Not License') status,
count(distinct usr.user_id) Active_User_Count
from apps.fnd_product_installations ins,
apps.fnd_application_tl apl,
apps.fnd_user_resp_groups grp,
apps.fnd_user usr,
apps.fnd_responsibility_tl res,
apps.fnd_responsibility rss
where ins.application_id = apl.application_id
and apl.application_id = res.application_id
and grp.RESPONSIBILITY_ID=res.responsibility_id
and rss.responsibility_id=res.responsibility_id
and usr.user_id=grp.user_id
and ins.status in ('I','S')
--and apl.application_name = 'Cash Management'
and (usr.end_date is null or usr.end_date>sysdate)
and (grp.END_DATE is null or grp.END_DATE> sysdate)
and (rss.END_DATE is null or rss.END_DATE> sysdate)
group by apl.application_name,
decode(ins.status,
'I',
'Installed',
'S',
'Shared',
'N',
'Not License')
order by 2;

It will give output like below;

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.

Count of EBS users having responsibilities linked to applications

Related posts: