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,…
Leave a CommentAuthor: Brijesh Gogia
Brijesh writes about enterprise AI, automation, AIOps, cloud infrastructure, databases, Oracle EBS, Exadata, and real-world multi-cloud architecture patterns for infrastructure and operations teams.Read more about BrijeshConnect on LinkedIn
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…
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 CommentValue 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’…
Leave a CommentQ: What is RMAN and why is it used in Oracle databases? Answer: RMAN (Recovery Manager) is a utility in Oracle databases that provides a…
Leave a CommentThe below script can be used to find SQL details from AWR. set lines 155 col execs for 999,999,999 col avg_etime for 999,999.999 col avg_lio…
Leave a CommentThe below script can be used to run SQL tuning advisor manually. CREATE TUNING TASK DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( sql_id =>…
Leave a CommentMongoDB is a popular, open-source NoSQL database that is known for its scalability and high performance. It uses a document-oriented data model, which means that…
Leave a Comment