Below script to find a list of all uses who are online in Oracle EBS. COUNT OF USERS SELECT DISTINCT count (*) FROM icx_sessions icx,…
Leave a CommentAuthor: 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.
[sc name="linkedin"][/sc]
The chattr command in Linux is a file system command which is used for changing the attributes of a file in a directory. The primary…
Leave a CommentTo list all users having specific responsibilities in Oracle EBS. For example below we are finding “System Administrator” responsibiltiy. NOTE: IT WILL LIST ALL THOSE…
Leave a CommentFind responsibilities that can run the specific concurrent program SELECT fcp.concurrent_program_name, fr.responsibility_name, frg.request_group_name, fcp.user_concurrent_program_name FROM fnd_request_group_units frgup, fnd_concurrent_programs_vl fcp, fnd_request_groups frg, fnd_responsibility_vl fr WHERE 1…
Leave a CommentThe below scripts can be used for responsibility, menu, submenu, and function details of specific responsibilities. 1. Retrieve a list of all responsibilities. Parameters: None…
2 CommentsScript to find all active responsibilities linked to an EBS user. SELECT UNIQUE fu.user_id, fu.user_name user_name, fr.responsibility_key responsibility, fa.application_name application FROM fnd_user fu, fnd_user_resp_groups fg,…
Leave a CommentSometimes users are end-dated but the responsibilities assigned to specific users are not end-dated. Below SQL code can be used to identify all such users…
Leave a CommentBelow are some of the useful Oracle EBS queries related to users and responsibilities. LIST OF ACTIVE USERS select user_id,user_name,description,email_address,start_date,end_date from fnd_user where (end_date is…
Leave a CommentThe below script can be used to find the count of users linked to each EBS application. You can also filter and get information for…
Leave a CommentBelow scripts can be utilized to find the number and details of EBS users that were on the system in the last 1 hour. The…
Leave a Comment