User Roles

SQL Query to list All User Roles in ERP Cloud

SELECT * FROM (SELECT user_info.user_login, user_info.user_id, user_roles.role_name, user_info.creation_date, user_info.first_name, user_info.last_name, user_info.location_code, user_info.location_name, user_info.town, user_info.country, user_info.department, user_info.username, user_info.active_flag FROM (SELECT DISTINCT pp.creation_date creation_date, ppf.first_name first_name, ppf.last_name… Read More »SQL Query to list All User Roles in ERP Cloud

SQL Query to List Oracle ERP Cloud Users and their Attached Roles

/***************************************************************************** *PURPOSE: SQL Query to List Oracle ERP Cloud Users and their Attached Roles * *AUTHOR: Shailender Thallam * *****************************************************************************/ SELECT pu.user_id, pu.username, ppnf.full_name, prdt.role_id,… Read More »SQL Query to List Oracle ERP Cloud Users and their Attached Roles