Recruiting
Discussion List
-
Candidate Date of Birth and NI Number not pulling through on OTBISummary: We have the Regulatory Response Date of Birth and Primary National Identifier Number Columns from Recruiting - Real Time in a report. I am testing applying as e…Alex Buckley 132 views 2 comments 0 points Most recent by Craig Hennessy Reporting and Analytics for HCM -
Viewing the Candidate ResumeSummary Calling/Viewing Candidate Resume from Candidate CV details OTBI ReportContent Hello, I am creating a OTBI report called Candidate CV details where I have a requi…Dharmendra Jha 166 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Error when using different subject areas in OTBI: Odbc driver returned an error (SQLExecDirectW)When I am trying to use different subject areas (Workforce Management-Checklist real time and Recruiting Real time), I am getting the below error in the Results. Odbc dr…Mohit-Sinha 52 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM
-
Create Temporary Table or View for complex agreement templateSummary: Seeking advice regarding BI publisher capabilities to create temporary data tables. Content (required): Hi team, I am seeking advice as to whether it is possibl… -
Calculate time between interactions ORCSummary: Hello - we are trying to report on the time between interactions in ORC. We can pull in the creation dates for each interaction, but we are unsure how to calcul…Shanna Oppenheim 32 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Job Requisition approval audit reportSummary: Please help with Requisition approval audit report sample. hanks in Advance. Content (required): Version (include the version you are using, if applicable): Cod…User_2025-02-12-21-07-06-233 52 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
How do I timestamp the states of applicants as they move through the recruiting process?Content Hello all, I'd like to create a report that timestamps the movement of candidates as they move through the recruiting process. Ideally, the report would look som…User_2025-02-11-09-08-21-835 150 views 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"Summary: Calling all SQL Experts: Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model. …Denise Izzi 155 views 7 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
NewHireReport not getting triggeredSummary: Content (required): We have set the value as "true" for all the below profile options: BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_IRC BIP_EMAIL_NOTIF…Vinay Gharge 22 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM
-
Sample OTBI Dashboards/Reports - RecruitingSummary: Content (required): Are there any recent shared sample packs of dashboards or reports related to ORC Recruiting? Version (include the version you are using, if …Toni Olivier 144 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to show where Referral payment due on completion of Probation periodSummary: We are trying to build a report which alerts us to employees who have now reached the end of their probation period and were referred by an employee during recr…Emily Robinson 32 views 7 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Custom metric doesn't work inside dashboardSummary: Content (required): Hello, We realize a new custom analysis in order to calculate the #Avg Time To Fill (Days), we use this formula: AVG( CAST( TIMESTAMPDIFF( S…Giuseppe Iacono 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job …Alvaro Couto 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da…Gerardo Peluso 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Email Bursting - Best PracticesSummary: Content (required): Hello, We've received a requirement from customer to implement automatic custom notifications to employees. More in depth: HRs post job requ… -
How create a Recruiting Report with ReasonSummary: Content (required): Hello Guys, We would create a Report that extract the reason linked to the last event for each worker, how we can create it, in our database…Giuseppe Iacono 11 views 3 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM
-
How to find requisitions pending approvalSummary: We are trying to find/create a report that can show the requisitions currently pending approval. I found the column that stores the status in Job Requisitions -…Paulette 198 views 5 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM
-
Is it possible to report on HCM Recruitment transaction team system activity?Summary: We want to report on activities undertaken in Oracle Fusion by People (HR/HCM) transaction administration colleagues. This specifically relates to job offer rec…
-
Recruiting Dashboard PDF downloadSummary: Content (required): Hello, The functionality used to download a Recruiting Dashboard page doesn't work anymore. We usually used this html code:Giuseppe Iacono 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Candidate Success of Hire ReportThis analysis displays candidate information such as past employers, education, certifications, and termination data like last position held and length of service. To ad…Dishti Malhotra-Oracle 53 views 3 comments 1 point Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
Bind OTBI Report to Requisition ID and Candidate IDSummary: BInding OTBI report to Requisition ID and Candidate ID Content (required): We have developed a report which calculates and displays the average score the candid… -
Resume/CV extract from work history fields Using BI PublisherSummary: Has any one created a formatted resume report using BI publisher? I have a request to extracted work history entered by our employees who do not have resumes in…Charles Egegbara 1 view 0 comments 0 points Started by Charles Egegbara Reporting and Analytics for HCM -
How select only th last event in Recruiting - Recruiting Event Real Time Subject AreaSummary: Content (required): Hello Guys, We would create a report that extract the number of job application for each reason, but we only want take in consideration the …Giuseppe Iacono 54 views 2 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM
-
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …
-
Candidate Pool Ownership TypeSummary: Content (required): Hello Guys, We would extract the Candidate Pool Ownership Type information from BI, but we don't find the correct table and field, someone c…Giuseppe Iacono 28 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 23 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
How Shows/Downloads OTBI Analysis results in Excel fileSummary: Content (required): Hello Guys, We would create an analysis which extract all the candidate members inside all pools. We have a lot of candidates and for this r…Giuseppe Iacono 13 views 2 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Extract Otbi Analysis with more then 25000 LinesSummary: Content (required): Hello Guys, We would create an analysis that it extract all the candidate members inside a candidate pool. The candidate pool is very large,…Giuseppe Iacono 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Different Data between Subject AreasSummary: Content (required): Hello Guys, We would create an analysis that it shows for each candidate the reason why they are rejected. We use the Recruiting Event Real …Giuseppe Iacono 33 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM