Script to get responsibilities for a user

This script will display all the responsibilities for a given Username.

SELECT fu.user_name, frt.responsibility_name, furgd.start_date,
 
       furgd.end_date
 
  FROM fnd_user fu,
 
       fnd_user_resp_groups_direct furgd,
 
       fnd_responsibility_tl frt
 
 WHERE fu.user_id = furgd.user_id
 
   AND furgd.responsibility_id = frt.responsibility_id
 
   AND UPPER (fu.user_name) = UPPER ('sujeet')
 
 
 

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...