Category: Apps (11i, R12) scripts

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,…

Find 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…

The below scripts can be used for responsibility, menu, submenu, and function details of specific responsibilities. 1. Retrieve a list of all responsibilities. Parameters: None…

Script 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,…

Sometimes 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…

Below 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…

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…

Below scripts can be utilized to find the number and details of EBS users that were on the system in the last 1 hour. The…

Value of specific profile option at all level select b.user_profile_option_name “Long Name” , a.profile_option_name “Short Name” , decode(to_char(c.level_id),’10001′,’Site’ ,’10002′,’Application’ ,’10003′,’Responsibility’ ,’10004′,’User’ ,’Unknown’) “Level” , decode(to_char(c.level_id),’10001′,’Site’…