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
Query to get interview details for a job requisition using BI Report
Summary:
Hello Team,
I am trying to get interviewer details (Interviewer person number and email address) using below query but I am not getting the right results. Can anyone please help here. Like it is doing cartesian product.
Content (please ensure you mask any confidential information):
select
distinct
irvl.OBJECT_STATUS "Object_Status",
irvl.name "Requisition_Title",
irvl.requisition_number,
irvl.FULL_PART_TIME,
decode(irvl.EXT_PUBLISH_JOB_STATUS, 'ORA_POSTED', 'ACTIVE', 'INACTIVE') "Posting_Status",
pjffv.job_family_name,
pjft.name "Job_name",
pldftl.LOCATION_NAME,
paf.ADDRESS_LINE_1,
paf.POSTAL_CODE,
paf.TOWN_OR_CITY,
paf.COUNTRY,
iri.start_date "Interview_Date",
Tagged:
0