Recruiting
Discussion List
-
Segregate visibility on OTBI to allow users to report only on Recruiting Subject AreasSummary: Content (required): Hello, The customer is requesting us the possibility to let Recruiters to access the OTBI and create some custom reports only related to Rec…gguittini 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Session Variables for Recruiting Subject AreasSummary: We have an open requisition report that we would like to use a session variable for so that the recruiter who is viewing the report only sees their requisitions…Allison O'Brien 86 views 2 comments 0 points Most recent by Allison O'Brien Reporting and Analytics for HCM -
Person number of employee/contingent worker of a successful referred candidateSummary: Customer is looking for a report with the person number of the employee/contingent worker who has been successfully hired after being referred by an internal em… -
How to associate an historical event State within a particular Phase in "Recruiting - Recruiting EveContent The requirement is to calculate totals based on Phase/State of historical events for auditing purposes. For example, in a "Job Application Status History" analys… -
HR Recruitment process metricsContent As part of the end to end recruitment process, I would like to report the following basic metrics..... 1. Job Requisition submitted (by hiring mgr/SDA) to Job Re…User_2025-02-11-13-03-12-474 41 views 3 comments 0 points Most recent by Harriet Reporting and Analytics for HCM -
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 35 views 1 comment 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Reporting Requisition Detail with Pending Worker DetailSummary: We have a requirement to report all Pending Workers which works fine, but we also need to include some basic Requisition detail such as Req Number and Title. Wh…Emily Robinson 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 160 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 43 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How is the security defined for the analytics "Recruiting Real Time"Summary: I am trying to create a analysis using the subject are - "Recruiting - Recruiting Real Time". The user has administrator access and role to view all job requisi…Shikha Agarwal 36 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
What table ties a job requisition to a candidate?Summary: I am trying to recreate a seeded report that is not working in HCM/ORC, and am just trying to tie a candidate to a job requisition. Does anyone have any clue wh…User_2025-02-10-17-54-21-557 25 views 3 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
Recruiting - Need to show Offers made that were Declined and the reason givenSummary: Does anyone have a report or dashboard built that will return this? The business needs to review the reasons given for recruiting offers made to candidates that…Rich R 20 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
Candidate Address and Other - IRC_JobOffer_Accepted_External - Alert/NotificationContent Hi, Using Alert: IRC_JobOffer_Accepted_External, added template. Whereas Procurement Department need to be informed that Candidate accepted offer. Procurement ne…
-
Recruitment Subject Area - retrieve Candidate skillsSummary Fusion (21c) Subject Area Recruiting - Recruiting Real TimeContent Our customer requirement is to see Skills from the 'Skill and Qualifications' Candidate sectio… -
Do we have any sql to identify the recruiting hirerarchy details?Summary Do we have any sql to identify the recruiting hirerarchy details?Content Would like to know if we have any sql for recruiting hierarchy details (like recruiting …
-
ORC: Employee Referral ReportContent Hello - we would like to report off employee referrals whether an internal employee used the 'Refer a friend' option to invite someone to apply to a req or if th…Shanna Oppenheim 149 views 4 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How can we extract requisitions tied other locations data through BIP tables ?Content Hi All, PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUI…Janardhana Kondaveeti 40 views 4 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank YouAwadhendra Tripathi 40 views 1 comment 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…Iann hick 47 views 5 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered…Alvaro Couto 163 views 12 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
OTBI report link creation for End usersContent Hi Team, We have created an OTBI report and given its link in the folder for the end user to click so that it will take them directly to the report. The problem …Shikha Agarwal 57 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Requisitions with Inactive ManagersSummary Is there a report showing requisitions with inactive managers?Content Hi all, I am developing a report to identify requisitions with inactive managers, so that w…Tristan Aquino 17 views 2 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
OTBI division operator in calculated column formula is not producing correct results - in RecruitingSummary The division operator in a calculated formula is not producing correct results in the Recruiting - Recruiting Events Real Time subject area.Content In OTBI, when…
-
report out on offer letter templateSummary How can we report out on which offer letter template was selected for a candidateRiti Malhotra 34 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Recruiting - Recruiting Real Time - Ability to Report on Position Details?Summary Currently you cannot report on all position attributes in ORC like FTE, having difficulty with joining subject areas.Content We are trying to report on FTE for O… -
ORC Security - Hiring Manager AccessSummary Is it possible to setup security for hiring managers to view their own requisition?Content Hi, Currently "Recruit to Hire Dashboard" shows all requisition detail…User_2025-02-10-17-54-52-878 32 views 2 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
Number of days a requisition is suspendedSummary Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBIContent Hello ever…Tom John Bontoyan 65 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Requisition HistoryContent Hi, does anyone know how I can create a report which shows the history of a recruitment requisition? Currently I can only successfully make one which looks at th…Erin Matushik 28 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
ORC Candidate Diversity - SummarySummary Getting to one row per job requisition?Content I've created an analysis that uses the delivered counts of applications, veterans, gender, and disability status t…User_2025-02-10-15-34-12-310 153 views 2 comments 0 points Most recent by User_2025-02-10-15-34-12-310 Reporting and Analytics for HCM
-
How to calculate time from different eventsSummary Calculate time difference between different phases (events) in a recruitment processContent Hi, I´m trying to create a report where I can report on the different…Even Kjorsvik-Oracle 45 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM