Recruiting
Discussion List
-
Recruitment questions in all blocksSummary: Hi , I would like to report on all questions in the pre-screening form for a candidate. The questions for the job requisition appear but not the questions in ot…Neena S 25 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM -
Candidate and Job Application Source-TrackingWe drew the statistics from the recruit to hire dashboard, and need clarification on how these are being collected and what those source mean. We inserted a pre-screenin…Radhika Hatwar-Oracle 27 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM -
Requisition Staffing agency fields in OTBI do not show any dataSummary: Requisition Staffing agency fields in OTBI do not show any data Content (please ensure you mask any confidential information): Recruiting Real time Subject area…FuriousSS 5 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
Tax Reporting Unit field on OfferSummary: Where can I pull the Tax Reporting Unit that is listed on a candidate's offer. Understand that the TRU name is on the hr_organization_units_f_tl, however, how c…Juan C. 27 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
Difference between creation_date and submission_date in IRC_SUBMISSIONS tableSummary: Difference between creation_date and submission_date in IRC_SUBMISSIONS table Content (please ensure you mask any confidential information): Hello experts, does…Oriana L. 8 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM -
Date when an applicants enter in a specific state of the applicationSummary: Content (please ensure you mask any confidential information): Hello experts, we are creating an OTBI analysis and we would like to know if it is possible to re… -
Is there a way to join a "Workforce Management - Areas of Responsibility" SA with "Recruiting RT"Summary: Is there a way to join a "Workforce Management - Areas of Responsibility" SA with "Recruiting - Recruiting Real Time" SA to get proposed representatives for the…Volodymyr Faranosov 15 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Job requisition approver using OTBISummary: Job requisition approver using OTBI Content (please ensure you mask any confidential information): Hello experts, we would like to build an OTBI analysis specif…Oriana L. 66 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Grade null for Job requisition OTBISummary: Grade null for Job requisition OTBI Content (please ensure you mask any confidential information): Hello experts, we are building an OTBI report with "Recruitin… -
How to retrieve the job req status for BIPSummary: How to retrieve the job req status for BIP Content (please ensure you mask any confidential information): Hello experts, we would like to build a BIP report wit…Oriana L. 97 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 28 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 30 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 15 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 35 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 6 views 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 17 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 374 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 16 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 119 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 37 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 34 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 64 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 17 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 138 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 25 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 50 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 20 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 25 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM