Recruiting
Discussion List
-
Interview Percepts feedbackDear team Hope you are doing well Could you please provide a query to retrieve the Interview Percepts feedbackManal Almutairi 5 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr…
-
Recruit to Hire - Top 10 Openings per Job FamiliesSummary: Top 10 Openings displaying info, and not info active Content (please ensure you mask any confidential information): We are in the process of going live with Rec…
-
Query to fetch candidate personal email address and personal phone numberHello Team, Please provide SQL query to fetch candidate's personal email address and personal phone number. These details should be taken from candidate info/candidate t…Ooha Pranathi Akkala 198 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How can we add Rehire column status in OTBI report? Is there any filed is there ?Summary: In a report we need to add rehire column status but there is no field to add this in OTBI report Content (please ensure you mask any confidential information): …
-
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…
-
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…User_2025-03-07-05-34-02-150 1.6K views 9 comments 0 points Most recent by User_YG5HR Reporting and Analytics for HCM
-
Onboarding/Recruiting Employee Name fieldSummary: What is an alternative for updating the "Employee Name" in OTBI, where it displays First Name Last Name for Onboarding/Recruiting, and not change any of the exi…
-
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 17 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 17 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 17 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 157 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 8 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 35 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 16 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 30 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 110 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 30 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 25 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 37 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 63 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 25 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