• Post category:Recruiting
  • Post comments:0 Comments
  • Post last modified:August 4, 2021
  • Reading time:3 mins read
You are currently viewing How to refer candidates in ORC and track them?
How to refer candidates in ORC and track them?
- How to refer candidates in ORC and track them?
Total Visits: 6

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.

image 1 1024x422 - How to refer candidates in ORC and track them?

Next, click on the three dots beside the job for which you want to refer a candidate

image 2 1024x296 - How to refer candidates in ORC and track them?

On the next screen enter the candidate email and click continue.

image 3 1024x301 - How to refer candidates in ORC and track them?

Fill in candidate data and an optional endorsement and click continue

image 4 1024x664 - How to refer candidates in ORC and track them?

Attach Resume and click Submit

image 5 1024x284 - How to refer candidates in ORC and track them?

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 DESC

Here 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.

image 6 1024x360 - How to refer candidates in ORC and track them?

Hope this was a good read. Stay tuned for updates.

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.