Recruiting
Discussion List
-
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 41 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 51 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 51 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 11 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 61 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 33 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 41 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 31 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 61 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 21 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 41 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 11 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 71 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…Harish Vummidi 101 views 2 comments 0 points Most recent by Harish Vummidi 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…
-
Filter does not remain for Inactive Applications tabSummary: Content (required): Hello all, I'm facing a problem regarding Requisition Recruiter filter in OTBI dashboard. Starting from the first tab of the dashboard, name…Maria Xydopoulou 51 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept…
-
BI Reporting function that creates link to attachmentsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Consulting Description (Requir…Claudio Marini-Oracle 32 views 0 comments 3 points Started by Claudio Marini-Oracle Reporting and Analytics for HCM
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 172 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM
-
Recruiter ScorecardSummary: Content (required): Has anyone created a recruiter scorecard before? How do you deal with requisition metrics if there was recruiter turnover and the new recrui…Riti Malhotra 31 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Filter by results of another analysis is slowSummary: The 'Filter by results of another analysis is extremely slow' Content (required): I have an, admittedly heavy, analysis with a significant number of calculated …DanielHarley 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Transfer Dashboard's gear icon to the HCM UIHello, Our client has a requirement, in which he wants the user to have access to the page options (gear icon) of the dashboard in the HCM UI, in the exact same manner i…Ioannis Adamou 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 61 views 4 comments 0 points Most recent by Poorani Gibson Reporting and Analytics for HCM