Recruiting
Discussion List
-
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" … -
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o…Volodymyr Faranosov 11 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
HSDL Updates to Requisition are not captured in IRC_LC_HISTORY TableSummary: When a requisition is updated using HSDL and if EXT_PUBLISH_JOB_STATUS , EXT_PUBLISH_JOB_END_DATE columns are being updated without any change to phase or state…vinay karumanchi 11 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Spreadsheet Data Loader (HSDL)
-
Some Requisitions Dropped from OTBI Reports after Adding any Data Column that is not HyperlinkedSummary: Some requisitions were dropped from OTBI report after adding a data column that is not hyperlinked. Content (please ensure you mask any confidential information…Kathleen Nguyen 11 views 2 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM
-
Need help in getting the query to fetch Candidate Extra Info from ORCSummary: I have been trying to look for tables that stores the Extra Info section details on the Candidate profile in ORC. If anybody has worked on it, can you share the…Rini_Varghese-Oracle 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Fetching Job Requisition with Sensitive Information in OTBIHi Team, We are fetching job requisition details from OTBI in the Recruiting - Recruiting Real-Time subject area. However, we also need to retrieve additional candidate-…Jeeva - Cloud Vantage 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 2.3K views 9 comments 0 points Most recent by Gongati Nandish Kumar-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…
-
Candidate Drop off ReportSummary: Hi - I am looking for an example candidate drop off report Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Is there any analytics for ORC on how many visitors visited/view job postings?Content Need an analytic from the very beginning of applicant funnel. Where i want to see how many has actually visited/view the job. Is this possible for ORC? In Taleo …Angie Ng-Oracle 48 views 2 comments 0 points Most recent by Siti Nor Nadiah Reporting and Analytics for HCM
-
In BI Publisher scheduled report how to disallow using Email Destination while retaining burstingSummary: Can BI Publisher scheduled reports be setup to disallow using Email Destination (either enterprise wise or certain user roles) while at the same time retaining …Jbgood 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
unable to get the assignment details for pending worker from checklist real time subject areaHello Team, while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment …Shivam Naugraiya 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Which table stores job link from ORC Career SiteSummary: I am trying to find table which stores job requisition link from career site. Content (please ensure you mask any confidential information): Version (include th…HCM_Rahul 22 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Active Candidate Pools OTBISummary: Dear Community, We would like to create an indicator that counts all active candidate pools within our system. However, while exploring the Recruiting - Recruit…Giuseppe Iacono 2 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …Pavan Kumar Thummalapalli 87 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI filter show no dataSummary: Hello experts, we have a report for recruiting requisitions, but when trying to search in the values we get no data.. the list of values: SELECT DISTINCT IRB.RE…Lucas B Maciel 21 views 3 comments 1 point Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Creating a Unified Report for Job Application Details and Pre-screening ResponsesHello Cloud Customer Connect Community, I hope you're all doing well. I'm currently facing a challenge and would greatly appreciate your expert insights. I am in the pro…Harish Vummidi 41 views 2 comments 1 point Most recent by Harish Vummidi Reporting and Analytics for HCM -
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio…
-
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 31 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result…
-
employees job interestsSummary: Report on employees job interests Content (please ensure you mask any confidential information): In opportunity Marketplace employees can record their interests…Dan Woodward 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Tips, Suggestions of migrating Taleo Reports to ORacle REcruiting CloudSummary: We have taleo reports which we want to create also in oracle recruiting cloud. I Would like to ask what are the possibilities of migrating besides manually crea…
-
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 161 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to report on Number of Positions requested, approved, rejected, pending?Summary: I have a requirement to design a Dashboard designed to track the overall timeline to 'Hire an new employee' from the time the initial position is requested/amen…Antonio Moldovan 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to get 'Last Update By' from Recruiting Subject Area in OTBISummary: We have a OTBI Reporting Requirement to display 'Last Update By' for a job application. I can see that 'Job Application Last Update Date' is available under Rec…Antonio Moldovan 31 views 4 comments 0 points Most recent by Antonio Moldovan Reporting and Analytics for HCM
-
Loading Job Requisitions via HDL - What table is collaborators held in?Summary: I'm loading Job Requisition from one Oracle environment to another and I'm having trouble finding the table where Collaborators sit. Please advise. Thanks! Cont…User_H77SF 41 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
OTBI Recruiting Candidate Data SecurityHello, We currently operate in multiple GDPR countries, and our Legal/Data-Privacy departments are requiring that we lock down candidate and job requisition data based o…Nick Dorfner 11 views 2 comments 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Misalignment Candidate selection process phase and state between OTBI and UISummary: Content (required): Hello Guys, We would create a report that show for each Candidate selection process Phases and States the correct number of application. By …Giuseppe Iacono 21 views 9 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Recruiting - Recruiting Real Time not showing jobs with 0 applicationsSummary: Content (please ensure you mask any confidential information): Hi all, I am trying to build an analysis using the subject area "Recruiting - Recruiting Real Tim… -
Global Talent Community Pool data not visible in OTBISummary: Hi Team, We are using OTBI to fetch data from the candidate data belonging to "Global Talent Community Pool". However, we are getting only one record having sta…