Do you know how to fetch Oracle Cloud Performance data using SQL

In this session, we are going to see how to fetch Oracle Cloud Performance data using SQL.

SQL Text:

select he.evaluation_id ,(select distinct person_number from per_all_people_f papf where papf.person_id = he.worker_id) pers_nbr ,he.manager_id ,he.assignment_id ,her.role_type_code ,to_char(step_completion_date,'mm/dd/yyyy') step_completion_date ,step_code ,per_extract_utility.get_decoded_lookup('HRA_EVAL_STEP_STATUS',step_status) step_status ,hrlv.rating_description ,reference_type ,per_extract_utility.get_decoded_lookup('HRA_SECTION_TYPE',section_type_code) section_type ,hrlv.rating_level_code ,hciv.name profile_item from hra_evaluations he ,hra_eval_sections hes ,hra_eval_ratings her ,hra_eval_participants hep ,hra_eval_steps hest ,hrt_rating_levels_vl hrlv ,hra_tmpl_periods_vl htpv ,hra_eval_items hei ,hrt_content_items_vl hciv where 1 = 1 and hes.evaluation_id = he.evaluation_id and her.reference_id = hes.eval_section_id and her.reference_type = ('SECTION') and hep.eval_participant_id = her.eval_participant_id and hep.evaluation_id = her.evaluation_id and hest.evaluation_id = he.evaluation_id and hest.eval_participant_id = hep.eval_participant_id and hrlv.rating_level_id(+) = her.performance_rating_id and her.business_group_id = hrlv.business_group_id(+) and htpv.tmpl_period_id = he.tmpl_period_id and hes.section_type_code = 'OS' and step_code = 'MGREVAL' and step_status = 'COMP' and her.role_type_code = 'MANAGER' and hei.eval_section_id(+) = hes.eval_section_id and hciv.content_item_id(+) = hei.reference_item_id and sysdate between htpv.nominal_from_date and nominal_to_date