Recruiting
Discussion List
-
insert line break inside a conditional statement in rtf letter templateSummary: insert line break inside a conditional statement in rtf letter template bi publisher Content (required): creating an RTF letter template and need to insert a li…Akhil Vutukuri 2.3K views 2 comments 0 points Most recent by Micha---- Reporting and Analytics for HCM -
Is there a way to add field of Responsibilities under Work Experience when printing the candidate?Is there a way to add the field of Responsibilities under Work Experience when printing the candidate details?Shaina_Manalo 13 views 1 comment 0 points Most recent by Jessica Reilly-Oracle Recruiting, Opportunity Marketplace -
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext… -
SQL query to get the candidate's education detailsSummary: Hi All, I am facing an issue to get the candidate's education data using the SQL query: SELECT U.* FROM IRC_CAND_PROFILE_USAGES_M R, IRC_PROFILE_EDUCATION_ITEMS…Shikha Agarwal 1.6K views 9 comments 0 points Most recent by UdayrajSingh Reporting and Analytics for HCM
-
Display Formatted Job Description Details on OTBI or BIP ReportSummary: Display Formatted Job Description Details on OTBI or BIP Report Content (required): We are trying to display Formatted Job Description Details onto an OTBI repo… -
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…Audrea Miller 2 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
BI Publisher - RTF Template - Numbered List in Offer LetterSummary: Hello everyone, I am new to build the BI Publisher, I would like to check a feasibility for my client requirement. My client offer letter has a numbered list e.… -
How can we report on click tracking for all emails sent as part of a recruitment campaign?Problem Description: Our recruitment campaign includes two emails: Email A: Contains buttons such as "Option A" and "Option B," linked to campaign goals. The goal respon…GraemeHarper 13 views 1 comment 0 points Most recent by Joey O-Oracle Recruiting, Opportunity Marketplace -
Job Offer Letter - RTF template If Condition for hire dateSummary: Hi Everyone, Does anyone has experience to write the condition rule under the RTF Template for Job Offer Letter (BI Pulisher), I would like to get some advise o…Kristy Fung 15 views 1 comment 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
Recruit to Hire Dashboard customizationHi Team, As we have seeded Recruit to Hire Dashboard, we want to have customized dashboard based on our requirement. we want to hide below items from the dashboard. Can …VenkaeshSJDI 144 views 8 comments 0 points Most recent by Vaibhav Ramesh Reporting and Analytics for HCM -
Report on Deleted Interview Feedback - RecruitingSummary: We have a requirement to track the Delete Feedback action on Candidate Job Applications. Has anyone created a report to do this? Content (please ensure you mask…Meeghan_Rodrigues 2 views 0 comments 1 point Started by Meeghan_Rodrigues Reporting and Analytics for HCM -
Recruitment - Candidates How to get a SMS/Email Communication Message History OTBI AnalysisSummary: Hi, On a Requisition via the Messages Tab a Recruiter sends out messages to candidates via Email or SMS using templates or custom messages. We need to have the … -
We have Job Application - Progression"."Current Phase" but it showing only phase like New onlySummary: Hi Team, Below subject area we rae using to know the Job Application - Progression"."Current Phase it showing of New or another phase but we need days in Phase …AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …Tammi Desens 13 views 4 comments 1 point Most recent by Carolyn K Payroll and Global Payroll Interface (GPI) -
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 28 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 104 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 25 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 21 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 28 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 54 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 10 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 1.2K 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 34 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 3 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 22 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 1 view 0 comments 0 points Started by YOGESH SAMPANGI Reporting and Analytics for HCM