/********************************************************* *PURPOSE: SQL Query to find ESS Job History * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT p.requestid parent_request_id, m.requestid request_id, NVL(p.name, substr(p.DEFINITION, instr(p.DEFINITION, ‘/’, -… Read More »ESS Request History with Time took to Run
SELECT * FROM ( SELECT gl.name , ROLE.role_name , pu.username FROM fusion.fun_user_role_data_asgnmnts ROLE , fusion.gl_access_sets gl , fusion.per_users pu WHERE gl.access_set_id = ROLE.access_set_id AND pu.user_guid… Read More »SQL Query of Manage Data Access along with Security Context
/******************************************************************* *PURPOSE: SQL Query to get Org Structure along with LE, BU, Ledger and Flex * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT horg.name enterprise ,… Read More »Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit, Ledger and Flex Values
/******************************************************************* *PURPOSE: SQL Query to get Organization Structure along with LE, BU and Ledger * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT horg.name enterprise , horg.organization_id… Read More »Oracle ERP Cloud – SQL Query to get Organization Structure along with Legal Entity, Business Unit and Ledger
/******************************************************************* *PURPOSE: SQL Query to extract BPM Approval Groups Information * *AUTHOR: Shailender Thallam * *******************************************************************/ SELECT fwg.approvalgroupid ,fwg.approvalgroupname, fwgm.member, fwgm.type, fwgm.sequence FROM fa_fusion_soainfra.wfapprovalgroups fwg,… Read More »SQL Query to Fetch BPM Approval Groups Information
We can use tables of FUSION_RUNTIME which stores information of BPM tasks for couple of months or until they are purged. Note: Oracle has granted… Read More »SQL Query to Fetch BPM Tasks Information
In table FND_KF_CROSS_VAL_RULES, we have two columns CONDITION_FILTER and VALIDATION_FILTER of XMLTYPE. To view the content of these columns, we need to use GETCLOBVAL() function.… Read More »How to extract XMLTYPE columns of table FND_KF_CROSS_VAL_RULES
/********************************************************* *PURPOSE: SQL Query to find Report Job History * *AUTHOR: Shailender Thallam * *********************************************************/ SELECT rh.requestid , rh.name , rh.definition , rh.processend , rh.processstart… Read More »SQL Query to find Report Job History 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