Recruiting
Discussion List
-
OTBI Report - Need Query Transaction Console Approver Name for Job Requisition & Job OfferSummary: Need Query Transaction Console Approver Name for Job Requisition & Job Offer i have tried this query select htce.object_name, htce.task_id task_id_hdr, htce.con…Herman Fersendy 26 views 0 comments 0 points Started by Herman Fersendy Reporting and Analytics for HCM -
Time to Fill Measure using Requisition Open Date in Recruiting - Recruiting Real Time Subject AreaContent I'm trying to create a Time to Fill measure using data in the Recruiting - Recruiting Real Time Subject Area. My calculation works but the Requisition Open Date …User_2025-02-10-14-03-41-548 103 views 5 comments 0 points Most recent by AshleyM Reporting and Analytics for HCM -
Can we track Candidates who agree to Terms and Conditions on the Career site?We are trying to find out if it's possible to track candidates who agree to the terms and conditions when applying through our career site. Candidates are given the opti…Niveditha 22 views 1 comment 0 points Most recent by Ramya Pabba-Oracle Reporting and Analytics for HCM
-
Fast Formulas for Candidate Selection ProcessesWe have requirement to candidate selection process. After the final interview, once one candidate is moved to the "selected" phase, other candidates should have to be au… -
OTBI Added formula column and filter stopped workingSummary: I added a column from the Subject Area Recruiting - Recruiting Events Real Time of: CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition Histor…Kristin Montoya TWU 24 views 4 comments 0 points Most recent by Kristin Montoya TWU Reporting and Analytics for HCM
-
Query to get Latest offer extended by details in ORCHi Folks, We are trying to fetch the latest offer extended details in our report, we tried latest updated by column from irc_offers, but It didn't work. Scenario: Hiring…Sushant95-Oracle 24 views 1 comment 0 points Most recent by Anu Puchha Reporting and Analytics for HCM
-
How to get the Job offer Approval history in a BIP report?Summary: Hello, We have a requirement to fetch the approvers, their approval comments and the date of approval in a report. How do we get this via BIP report? Version (i…Shreya Datir 37 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Alert Composer: Message text stored in which tableSummary: I want to get the message text of an alert composer. where it will be stored, Only message body was able to found-. which is in HTML format. most of the alerts …Merwin 3 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Dynamic Hyperlink in BIP RTF templateContent Hi Team, I am looking for a dynamic hyperlink for my rtf template. The requirement is such that for recruiting we need to send email to employees with a link for…Shikha Agarwal 1K views 6 comments 0 points Most recent by user11977061 Reporting and Analytics for HCM -
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 33 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 2 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
-
Job requisition report not pulling all job requisitionsSummary: I created a job requisition report to show all open requisitions in a month. I need it to show any that are currently open plus those that were open and filled …
-
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 21 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 3 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 56 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Report on Messages sent to Candidates using a message templateSummary: Content (required): I'm looking to report on Email messages sent to candidates who've submitted a job application. Any thoughts on which subject area/dimension …Susan Anderson 58 views 4 comments 0 points Most recent by Lee Charleton Reporting and Analytics for HCM -
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 24 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 3 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 2 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 14 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 13 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 12 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