Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Getting multiple values with HZ_LOCATIONS query
Hello,
I am creating a BI report to fetch location values from HZ_LOCATIONS table for longitude and latitude along with person details from employee table. The query is giving me multiple values indicating some missing join which i am unable to find. Can you please help.
select
/*loc.address1
, papf.person_number,
hr.location_id,
hr.location_name,
loc.longitude,
loc.latitude
*/
hosr.*, papf.person_number
from hz_orig_sys_references HOSR
, HZ_LOCATIONS LOC
, per_all_assignments_m paam
, per_all_people_f papf
, HR_LOCATIONS hr
where hosr.owner_table_name in 'HZ_LOCATIONS'
AND hosr.ORIG_SYSTEM = 'FUSION_HCM'
Tagged:
0