In Oracle Recruiting Cloud (ORC), internal employees can refer the candidates to the job requisitions. However there are no seeded reports to track these applications.
Once an internal employee refers a candidate, candidate will get an email to apply for the job. If the candidate feels that the job is appropriate for him, he/she will go ahead and apply for the position by clicking on the hyperlink. Once he/she applies, then the candidate is tracked as referral in the application.
Navigate to Me > Current Jobs and search for all Jobs which are currently posted.
Next, click on the three dots beside the job for which you want to refer a candidate
On the next screen enter the candidate email and click continue.
Fill in candidate data and an optional endorsement and click continue
Attach Resume and click Submit
Once the employee submits the referral, an email will be triggered to the candidate to apply for this position and the referral will be tracked in this system from this point in time.
There aren’t any seeded reports which track the referrals. The referral info will be stored in IRC_RF_REFERRALS table which would be the base for any queries.
SQL Query to find the referrals information:
SELECT
IRV.TITLE,
PAPF.PERSON_NUMBER REFERRER,
(SELECT PPNF.FULL_NAME FROM PER_PERSON_NAMES_F PPNF
WHERE PPNF.PERSON_ID = PAPF.PERSON_ID
AND PPNF.NAME_TYPE ='GLOBAL'
AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
) REFERRER_NAME,
(SELECT FIRST_NAME || ' ' || LAST_NAME FROM IRC_AGENTS WHERE AGENT_ID = IRR.AGENT_ID) AGENT_NAME,
IC.CANDIDATE_NUMBER,
(SELECT PPNF.FULL_NAME FROM PER_PERSON_NAMES_F PPNF
WHERE PPNF.PERSON_ID = IC.PERSON_ID
AND PPNF.NAME_TYPE ='GLOBAL'
AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
) CANDIDATE_NAME,
(SELECT EMAIL_ADDRESS FROM IRC_CAND_EMAIL_ADDRESS_V WHERE PERSON_ID = IC.PERSON_ID) CAND_EMAIL,
IRR.NOTES_CANDIDATE,
IRR.CREATED_BY,
TO_CHAR(IRR.CREATION_DATE,'MM/DD/YYYY') CREATION_DATE,
REQ_JOBS.STATUS,
TO_CHAR(REQ_JOBS."LAST UPDATE",'MM/DD/YYYY') LAST_UPDATE_DATE
FROM IRC_RF_REFERRALS IRR,
IRC_REQUISITIONS_VL IRV,
PER_ALL_PEOPLE_F PAPF,
IRC_CANDIDATES IC,
(SELECT SUB.SUBMISSION_ID, SUB.PERSON_ID, (SPHASE.NAME||' - '||CSTATUS.NAME) AS STATUS, SUB.SUBM_LAST_MODIFIED_DATE AS "LAST UPDATE"
FROM IRC_SUBMISSIONS SUB,IRC_STATES_VL CSTATUS, IRC_PHASES_VL SPHASE
WHERE SUB.PUBLIC_STATE_ID=CSTATUS.STATE_ID
AND SUB.CURRENT_PHASE_ID = SPHASE.PHASE_ID
) REQ_JOBS
WHERE IRR.REQUISITION_ID = IRV.REQUISITION_ID
AND PAPF.PERSON_ID = IRR.REFERRER_PERSON_ID
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND IRR.OBJECT_STATUS = 'ORA_ACTIVE'
AND IRR.CANDIDATE_PERSON_ID = IC.PERSON_ID
AND REQ_JOBS.SUBMISSION_ID(+) = IRR.SUBMISSION_ID
ORDER BY IRR.REFERRAL_ID DESCHere is the output of the query after the referral has been submitted. Once the candidate applies for the position, the status and last update date would be populated based on the Phase/State in which the application resides.
Hope this was a good read. Stay tuned for updates.
