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 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.
Hope this was a good read. Stay tuned for updates.If you like the content, please follow us on LinkedIn, Facebook, and Twitter to get updated with the latest content.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM