Recruiting
Discussion List
-
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 143 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 K 33 views 4 comments 0 points Most recent by Janardhana K 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 34 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 43 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 153 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 52 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 15 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 31 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 28 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 49 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 149 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 41 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Candidate Pre-Screening ResponsesSummary Need to build a report to reflect the pre-screening responses for specific candidateContent Hi All I am new to HCM, and I am having trouble determining how to jo… -
recruitment facts/metricsContent Is there a way to pull # of applicants submitted to Manager, how many of those were rejected - or each phase how many touchpoint did recruiter make with applican…Riti Malhotra 48 views 2 comments 0 points Most recent by Dhiraj Hadkar Reporting and Analytics for HCM
-
Manage Job Offers - Approvals HistorySummary Manage Job Offers - Approvals HistoryContent Hi All Could you please help me with the OTBI / BI Report which helps to get the history of all transactions related…Mansur Khalil 69 views 2 comments 3 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Query to display the Phases and States of the CSP in OBIContent Hi Experts, I am looking for a OBI query to display the Phases and States which are associated to the CSP. Regards, Harish Version 20DHarish Vummidi 60 views 4 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
Recruiting Module - OTBI/BI ReportSummary Recruiting Module - OTBI/BI ReportContent Hi Team, I'm new to Recruiting Module I would like to fetch following attributes from either OTBI/ BI Report. Please he…Mahendra 92 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Recruiting - Hires Listing no pulling offer detail for allSummary Recruiting - Hires Listing no pulling offer detail for allContent Trying to use seeded report of Hires Listing to create our own version and for some candidates …Emily Robinson 54 views 2 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…Adil_R 72 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Recruiting - Reporting on a candidate source when added by a recruiterContent HI experts, I need your help if possible. We haven't been using agency recruiting in ORC because of a system functionality issue so have had to resort to a worka…User_2025-01-25-04-04-47-442 71 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time SuSummary How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time Subject areaContent Hi Team, Please find attached analysis whic…
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 60 views 7 comments 0 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
ORC analysis - Time to Approve?Summary I am looking for a way to report on the time to approve a job requisition in ORC using OTBIContent Hello, I have a need to report on the Time to Approve an ORC j…User_2025-02-04-23-22-13-274 86 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
how to take custom dff of (IRC_OFFERS_DFF) in analyticsSummary how to take custom dff of (IRC_OFFERS_DFF) in analyticsContent how to take custom dff of (IRC_OFFERS_DFF) in analytics need subject criteriaSidhartha Wadhwa 23 views 1 comment 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM