Home » Applications » Oracle Fusion Apps & E-Business Suite » Fusion HCM --Need help with a sql query for Fusion users , roles and the orgs the user has access (Fusion HCM)
Fusion HCM --Need help with a sql query for Fusion users , roles and the orgs the user has access [message #625324] Sun, 05 October 2014 10:37
amita.narayanswamy
Messages: 2
Registered: October 2014
Junior Member
Hi,

I need to write a sql query to pull out the USERS,ROLES and the Departments that a user via the ROLE has access to..

First query I worte -- I was able to pull out all active users and the ROLES attached to the USERS

Second query--Gets all the USERS AND the Departments that the users have access to

For Example If a USER HAS THE ROLES HR SPECIALIST ATTACHED THEN HE HAS ACCESS TO "DEPT_NAME_XYZ" and MY query should get this suername , role_name and the Dept Name..


This in the front end is happening via the person EIT--"DEPT_NAME_XYZ" is attached to this person record in the application.

However I need to get the connection between the USERS, ROLES and the DEPARTMENTS..


My query should pull out this..


Any help is appreciated..

Thanks.
Previous Topic: FRM-41033:attribute active irrecevable pour l'élément non affiché in a personnalization form oracle
Next Topic: EBS cloning
Goto Forum:
  


Current Time: Mon Sep 21 12:16:32 CDT 2020