Recruiting
Discussion List
-
Query/ table to find the new joiners detailsSummary: Hi team, Please help to find the Query/ table to find the new joiners details in Oracle Fusion HCM such as: Current Job Title Last Title (Designation from previ…Hitha Harikumar 24 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Move multiple candidates to rejected on Assessment, Initiate Assessment StatusSummary: We are trying to utilize the Move functionality to reject several candidates at a time, but we are receiving an error Content (please ensure you mask any confid…KMore 31 views 3 comments 0 points Most recent by ChelcieN-Oracle Recruiting, Opportunity Marketplace -
How to get approved by for Job Requisition ?Summary: I want a query to get approved by in transaction console for job requisitionMartin_Melek 1 view 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?In my RTF template, I'd like to put a message for employees who are not belong to a specific department: However, in our case, some employees under 'ABC Expert' departme…
-
OTBI Agent sends spoiled action linksSummary: OTBI Agent sends spoiled action links Content (please ensure you mask any confidential information): Hi experts, I am working on the new job applications list O…Volodymyr Faranosov 12 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Link Requisition with Prescreening Questions and Answers (Oracle Recruiting Cloud)Content I am trying to link Requisition ID, Candidate with Prescreening Questions and Answers but I am unable to find the link between the requisition, candidate and que…scheduler DBA 320 views 6 comments 0 points Most recent by Santhosh Gangishetty Reporting and Analytics for HCM
-
BI report - rejected by in Job RequisitionWe are building a report to check the rejected job requisitions and we can't find the field for who rejected the requisition. The field IRC_REQUISITIONS_VL.LAST_UPDATED_…Marta Martinho 11 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
The Requirement is to get the Approval history for the Job Offer approvalSummary Approval status and the approval date with the respect to the approver for a job Offer in BIP ReportContent Requirement is to fetch the below for Candidates Job …Ashish Shukla-83483 116 views 3 comments 0 points Most recent by Deepika1704 Reporting and Analytics for HCM
-
OTBI-ORC report issue on filter of candidate job application dateSummary: HI Team, when we apply the filter of candidate job application date report running long time without result but when we remove the filter on date it takes only …AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Candidate’s application Question code in OTBI or data moduleI am looking to build a report that has the candidate’s application questions and answers and I need the question code on it for analytic purposes. I can build an OTBI b…Chris Pomager-27736 31 views 7 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Any Functional or Technical Design document for Seeded ORC DashboardAs we can see the seeded Dashboard for ORC - Recruit to Hire. But do we have any technical or Functional document available to see the logic (calculations) used in each …Venkatesh S S 51 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
In what particular subject area can Date of Fill, Time to fill and Time to Hire be found?I'd like to pull the following columns within the Recruiting Subject Areas: Date of Fill - Returns the date/time when the requisition was most recently filled. Time to F…Welsey 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
where to find "when is the employee start date" from offer letter in BISummary We need to report "start date" from offer letterContent Hello We have a requirement to include the "When is the employee start date" [hire date] from the offer l…Adil_R 131 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No results for some Facts-Candidate Tracking Activity such as number of applies, number of submits.Summary: Running a basic query against Recruiting - Candidate Tracking Real Time subject area. Number of successful submits does display, however Number of Applies, Numb…Melody Herbert 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
candidate email address in OTBISummary: How do we fetch the candidate email ID in OTBI from recruitment real time subject area as per the email ID present in the candidate personal information page. I…Debkanya 41 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
time to fill OTBI report in ORCSummary: Does anybody have time to fill OTBI report or dashboard build in ORC? Content (please ensure you mask any confidential information): Version (include the versio…Avinash.Potti 11 views 2 comments 0 points Most recent by Avinash.Potti Reporting and Analytics for HCM -
ORC OTBI Report issue when we export from outputSummary: Hi Team, we getting below issue when we ty to export the data. Thanks, ajay Content (please ensure you mask any confidential information): Version (include the …AjayKumar Maddipati 21 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Import Oracle Taleo Recruiting to HCM Fusion.Summary: Hi Team, Could you please let us know, Candidate Imported form Taleo to fusion through "Import Oracle Taleo Recruiting Cloud Service Data" process, in which tab…
-
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 121 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM
-
ORC - Answers to open questions not visible in analysis with Subject Area 'Recruiting Real Time'Hi, We can't seem to pull the answers from open text questions (prescreening) into a report using an analysis based on the Subject Area 'Recruiting Real Time'. We use th…Natalia_Leemans 1 view 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM
-
Is there a way to include historical source information?Summary: Candidate Pool Reporting - historical 'Source' data Content (please ensure you mask any confidential information): We are building a report on candidate pools a… -
How to extract Questionnaires and Employee Response?Summary: How to extract Questionnaires and Employee Response?
-
how to get Expected date of joining in orc from which tableIn orc how to get Expected date of joining of candidates.Vinay Prasad 63 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Columns as stagesSummary: im trying to find a way if possible to wrap a whole column in an arrow pointing right. I have multiple stages and want to flow from stage1 to stage5. The two wa…
-
Query to find Ownership type of candidate pool(Private, Shared, Global)Summary: I need to show ownership type(Private, Shared, Global) of Candidate Pool in BI report. I am unable to find any table that stores this information. However, ther…Sujay Bhowmick 61 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
LSQL - Connect Job Applicant and Employee AssignmentHello All, I am writing an LSQL analysis in OTBI which requires us to add the Hire Date for applicants who are hired. We're familiar with the Projected Start Date and ev…Nick Dorfner 31 views 2 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Where can I find the table for phase and state submission date?Summary: Table for phase and state submission date. Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…