There are several ways to run a command in a loop in Linux. Some of these with simple examples are listed below. This can prove…
Leave a CommentExpert Oracle Posts
There are several Linux commands that can be used to gather information about the CPU and Memory in a Linux system. Some of the most…
Leave a CommentThe “screen” command in Linux is a terminal multiplexer, which allows a user to open and manage multiple terminal sessions within a single terminal window.…
Leave a CommentBelow 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 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…
Leave a CommentScript 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 Comment