ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 1F0480A825896E8BE0636ADA860A3BB8 ORB Report Name Y select olf_name.property_value value, olf_desc.property_value description from xxorb.orb_report orr, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf_name, xxorb.orb_localizedstring_flat olf_desc where olf_name.meta_object_id = orr.id and olf_name.property_key = 'name' and olf_desc.meta_object_id(+) = orr.id and omo.id=orr.id and olf_desc.property_key(+) = 'description' and (:$flex$.report_folder_name is null or omo.parent_id=( select omo.id from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf where omo.id=olf.meta_object_id and olf.property_key = 'name' and omo.obj_type=12 and olf.property_value=:$flex$.report_folder_name ) ) US 1F0480A8258E6E8BE0636ADA860A3BB8 ORB User Name Y select ou.id value, xxen_orb_util.orb_user(ou.id) description from xxorb.orb_user ou US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 1F150D78A8B2A7D9E0636ADA860A5F62Y select distinct count(x.run_id) over (partition by x.report_id) count, x.report_name, count(distinct x.run_by) over (partition by x.report_id) users, max(x.run_by) keep (dense_rank last order by x.count_per_user, x.run_by) over (partition by x.report_id) most_frequent, count(distinct x.run_by) over () total_users, x.created_by, xxen_util.client_time(x.created_date) creation_date, x.last_modified_by last_updated_by, xxen_util.client_time(x.last_modified_date) last_update_date from (select ors.run_id, ors.component run_component, ors.report_id, ors.report_name, ors.report_type, ors.run_by, ors.created_by, ors.created_date, ors.completion_time, ors.time_in_seconds, ors.output_type, ors.error_message, ors.last_modified_by, ors.last_modified_date, count(ors.run_id) over (partition by ors.report_id, ors.created_by) count_per_user from ( select ors.id run_id, ors.component, orv.report_id, orv.report_name, orv.report_type, xxen_orb_util.orb_user(ors.run_by)run_by, orv.created_by, cast(orv.created_date as date) created_date, cast(ors.run_date as date) run_date, cast(ors.completion_time as date) completion_time, round((cast(ors.completion_time as date) - cast(ors.created_date as date)) * 86400,2) time_in_seconds, ors.output_type, ors.error_message, ors.rows_retrieved, orv.last_modified_by, cast(orv.last_modified_date as date) last_modified_date from xxorb.orb_report_stats ors, xxorb.orb_report_v orv where 1=1 and --ors.created_date >=sysdate-30 and orv.report_id=ors.report_id )ors )x US ORB Report Execution Summary Execution history of Orbit reports, summarized by users accessing the reports ,most frequent user and total user count. This can be used when migrating from Orbit Reporting to Blitz Report, to analyze which Orbit Report were previously used by the business ORBIT 1=1 1 10 1=1 orv.report_name=:report_name LOV ORB Report Name 1F0480A825896E8BE0636ADA860A3BB8 Y select olf_name.property_value value, olf_desc.property_value description from xxorb.orb_report orr, xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf_name, xxorb.orb_localizedstring_flat olf_desc where olf_name.meta_object_id = orr.id and olf_name.property_key = 'name' and olf_desc.meta_object_id(+) = orr.id and omo.id=orr.id and olf_desc.property_key(+) = 'description' and (:$flex$.report_folder_name is null or omo.parent_id=( select omo.id from xxorb.orb_meta_object omo, xxorb.orb_localizedstring_flat olf where omo.id=olf.meta_object_id and olf.property_key = 'name' and omo.obj_type=12 and olf.property_value=:$flex$.report_folder_name ) ) US Report Name 2 20 1=1 ors.run_by=:created_by LOV ORB User Name 1F0480A8258E6E8BE0636ADA860A3BB8 Y select ou.id value, xxen_orb_util.orb_user(ou.id) description from xxorb.orb_user ou US Submitted by User 3 30 1=1 ors.created_date>=sysdate-:submitted_within Number 60 US Submitted within Days 4 40 1=1 ors.created_by<>nvl((select id from xxorb.orb_user ou where ou.authority_user_id=fnd_global.user_id),-99) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Exclude own Submissions