Recruiting
Discussion List
-
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 8 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Subject area for Candidate Extra Internal InfoSummary OTBI Subject area for Candidate Extra Internal InfoContent Hello team, I'm looking for OTBI subject area for Candidate job application extra internal info. Thank…Santhosh Bachu 31 views 3 comments 0 points Most recent by David Oldfield Reporting and Analytics for HCM -
Reporting on Offer Start Date if date ChangesSummary: Reporting on start date from offer when start date changes in assignment later. Content (required): I have a report using the Recruiting Real Time subject area …
-
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 2 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 32 views 3 comments 0 points Most recent by Shanna Roy Reporting and Analytics for HCM
-
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…Sateesh Reddy 11 views 3 comments 0 points Most recent by Sateesh Reddy Reporting and Analytics for HCM
-
Average Time of Two PhasesSummary: I'm looking for a way to report on the average time an application is in the Screen and Interview phases (combined and separately), but am having zero luck. Any…Jessica D 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fact Definitions - Candidate Tracking Real TimeSummary: Content (required): Where can I find the definitions of facts in the Candidate Tracking Real Time Subject Area? I'm looking for the difference between 'Number o…Susan Anderson 13 views 2 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Authorization error with REST API to move candidate between phases / statesSummary: Content (required): Hello everybody, We are trying to use the rest api made available by Oracle to move a cadidate present in the system in the ORC module betwe…Gerardo Peluso 11 views 3 comments 0 points Most recent by Mandeep Gupta 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-Oracle 31 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…
-
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not … -
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…
-
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…
-
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_9D8XD 31 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. … -
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …Greg Rank 12 views 3 comments 1 point Most recent by Allison O'Brien 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 11 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM
-
Generate candidate list for incomplete submissionsSummary: how do i generate a list of candidates that did not complete their application? Content (required): Hi we are in process of migrating from Taleo to ORC 22A and … -
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 21 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 21 views 7 comments 0 points Most recent by Cora_Stanciu Reporting and Analytics for HCM
-
Recruit - reporting on event date for Interview to be ScheduledSummary: We have a report which shows all candidate at state of Interview to Be Scheduled, but we want to add the date which they got moved to this state. I have added s…Emily Robinson 1 view 3 comments 0 points Most recent by Bhaskar Konar 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 1 view 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc)Summary: Sql Query to get New Hired employee details with Requisition Details (Req Number, Hiring Manager, Recruiter Name etc) Content (required): Version (include the v…Awadhendra Tripathi 22 views 2 comments 0 points Most recent by Awadhendra Tripathi 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 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…
-
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 1 view 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 1 view 3 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM