Recruiting
Discussion List
-
Issue with Vertical(portrait) view of offer letter over mail on mobile devices.We have noticed a display issue with the offer letter email when viewed on mobile devices in portrait mode(vertical view). The email requires horizontal scrolling to vie…sreenivasulu.devineni-Oracle 39 views 2 comments 2 points Most recent by sreenivasulu.devineni-Oracle Reporting and Analytics for HCM -
List of Approvers in Workflow NotifcationSummary: List of Approvers in Workflow Notification Content (required): Hi , I need a list of Approvers who are going to approve the transaction in below format. I have …NitinSharma28 7 views 1 comment 1 point Most recent by Akshitha Vyas Reporting and Analytics for HCM -
How to write a query to get accurate "when is the employee start date?" from the OfferSummary: Hi Team, We are trying to add value for "When is the employee start date?" in one of ours Offer accepted report. However when the employee start date is changin… -
License Count IssueSummary Identifying Authorized Hosted Named Users (Doc ID 2512770.1) does not Provide the Correct ResultsContent Hi, We are using the Oracle License count report to get …Sahil_Makhiza 1.1K views 10 comments 2 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Missing conditional paragraphs in Job Offer previewHello, I have created custom Job Offer RTF template with Oracle BI Publisher tool. I have included multiple conditional paragraphs, but only facing issues with paragraph…Piotr Kiewro 27 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
can we have different Font style for e-sign on offer letter templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…YOGESH SAMPANGI 5 views 0 comments 0 points Started by YOGESH SAMPANGI Reporting and Analytics for HCM -
OTBI - add a graph to show the number of candidates by locationSummary: I've created an analysis using Recruiting - Recruiting Real Time Subject area and have been trying to add a graph to show the number of candidates by location, … -
SQL query for interview reminder, collect feedback & LINKEDIN ID from candidates resume on ORCSummary: Hello Experts, I need your help to query two BIP notification that needs to go out along with a message and link for Job Posting, resume in below scenarios: Cus…Ashwini Pundle 66 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav… -
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 27 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
if a journey- checklist is deleted in ORC, what are the ways we can check who has deletedSummary: if a journey- checklist is deleted in ORC, what are the ways we can check who has deleted the checklist. We wish to capture the data of deleted ones Content (pl… -
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 7 views 0 comments 0 points Started by Shanna Oppenheim Reporting and Analytics for HCM -
Need to get referrer Job Title and Referrer assignment status in OTBISummary: We are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker p…Rama123-Oracle 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
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 26 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 16 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 24 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 17 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 20 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.7K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM -
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 57 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 22 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 11 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 37 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 29 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 157 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 26 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…HarishVummidi 47 views 2 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM