Recruiting
Discussion List
-
Need Enterprise Onboarding Template NameSummary: Wanted to customize the Enterprise Onboarding email being sent. Content (required): We need the path of the template. We want to display the first name in place…Gourabh Choudhary 56 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
Cannot extract Moved to HR information from BI tables (Recruiting)Summary: Content (required): Hello experts, we need to track candidates under Moved to HR and Moved to HR date. Is there a BI table to extract this information? Thanks i…Valerio Curzi 24 views 2 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM -
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 182 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Application Source website details informationSummary: Content (required): Hello experts, from BI, is there a way to extract website details for the Application Source object (Recruiting module)? For example, if we …Valerio Curzi 35 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I pull the source information indicated on the Candidate Profile.Summary: We are looking to pull the source information that is stored on the Candidate Profile - not the submission that is associated with any requisitions. Content (re…Craig Stevens 39 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to extract the results of the notifications sent using BI Publisher with Bursting.Summary: if seeded report got bursted one notification through EMail to X Users, is it possible can we get notification delivered date. If yes what are the tables involv…Sivaram Injeti 45 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Oracle BI EE option missed in Data source while creating report?Summary: Oracle BI EE option missed in Data source while creating report? Content (required): Oracle BI EE option missed in Data source while creating report? Version (i…
-
How to get an analysis to show # of open Positions being recruited for each month over the past yearSummary: How to get an analysis to show how many positions were being recruiter for each month over the past year? We have a dashboard with the time dimensions of Month,…Craig Stevens 34 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Need BIP query for Sensitive Information in Job Application ORCSummary: Which is the source table for National Identifier and Date of Birth under Sensitive Information? Navigation: My CLient Group >> Hirings >> Search Req Number>> C…
-
Manager hierarchy in Recruitment using OTBISummary: Need guidance on which field or logic to be used to include manager hierarchy in an OTBI recruitment report Content (required): OTBI Manager Hierarchy Recruitme…
-
How to get the Time Dimensions to work with the Move HR DateSummary: We have a recruiting dashboard that has the Time.Month, Time.Quarter and Time.Year dimensions as prompts. When we run a drill down to show details of the intern…Craig Stevens 45 views 6 comments 0 points Most recent by Craig Stevens Reporting and Analytics for HCM
-
AOR Templates - RecruitingSummary: I am trying to do an OTBI Report for representatives assigned with Recruiting responsibility type. However, when I add a filter for recruiting responsibility ty…Ridma Karunanathan 56 views 1 comment 0 points Most recent by Mayur Kaushik Reporting and Analytics for HCM
-
Recruiting DEI ReportingWe are trying to create a TA / Recruiting-based DEI report that necessitates requisition details, candidate details, and some sensitive DEI data elements (gender, ethnic…Brian Kress 56 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Filled Requisition > Hired Employee OTBISummary: Wondering if anyone has a solid analysis that indicates which filled requisition a hired employee came from? (Even if they arent still in the same job that they… -
Changes Only Extract not picking the ORC Promoted EmployeesSummary: What is stopping the Changes only extract not to pick the employees promoted through ORC? Content (required): We have developed a Changes Only extract which sen…
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 15 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
can we create report on the missing candidates (unconfirmed candidates).There are some candidates who were not able to submit there job applications because of issues with being able to access the assessment. I need to check if we can create…Chetana Pawar 69 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
How would we restrict the access of Hiring Manager to the other reports in a Dashboard?We have Dashboard A where Hiring Managers has access to. Inside the Dashboard A, we have a couple of reports (eg. Requisitions, Candidates, Hiring Manager requisitions).…
-
Report on Job Openings as of Last MonthSummary: I need to report on how many job openings there were as of last month. When I use the sql for last day of last month, the numbers aren't accurate as it is live …Jessica D 35 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM
-
Find list of requisitions that has internal employees in the Best Candidates.Summary: We have a requirement to find out requisitions that has internal employees in the Best Candidates list. Please share if there is any BI query that I can use to … -
Prompt does not work in dashboard for different analysis using different subject areasSummary: Content (required): I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real …Maria Xydopoulou 45 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
To avoid Oracle Repository external accessHi team, I need your precious support! Cause of notifying the candidate, we created a BI report adding a "link" to make the recipient able to download a .zip file. We us…tommasodicesare 35 views 0 comments 0 points Started by tommasodicesare Reporting and Analytics for HCM -
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…
-
Sharing Recruit to Hire Dashboard -- download catalog fileSummary: I know I have seen a posting that shared the delivered Recruit to Hire Dashboard in a customizable download file. Can someone share the link to that posting? I …Ellen Manthei 66 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Using filter with ORSummary: We want to add a filter to a fact column to only return Direct Applications, so no Agency Referrals from Source or Internal Candidates from Job Application Basi…Emily Robinson 25 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 48 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Report Job Offer Employment Category in AnalysisSummary: I want to Report the Employment Category of a Job Offer in an Analysis Content (required): I use the Subject Area "Recruiting - Recruiting Real Time" and can't …Felix2 15 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC…Rajib_Samanta 79 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Create a Report for Candidate Job Application with the Prompts as Prescreening QuestionsSummary: Hello Experts, We have a requirement where we need to build a report with the Filters as the Prescreening Questions. There are 15 Prescreenshing questions but w…HarishVummidi 107 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Report in OTBI to show data as of end of previous monthSummary: Need to show number of openings (from recruiting requisitions) from a specific date (6/1/22) through the last day of the previous month. I created a filter to s…