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 CommentExpert Oracle Posts
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 CommentBelow is some basic information on how database level parameters are managed between CD and PDB databases in Oracle multitenant architecture: Changing parameters for CDB…
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 Comment