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

SQL Query to Find DFF Structure from backend

/******************************************************* *PURPOSE: SQL Query to find DFF Structure from backend* *AUTHOR: Shailender Thallam * *******************************************************/ SELECT apps.application_name "Application", d_flex.title "DFF Title", d_flex.application_table_name "Table Name", d_flex.context_user_override_flag… Read More »SQL Query to Find DFF Structure from backend