Reporting
Discussion List
-
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 263 views 2 comments 0 points Most recent by Kuraloviya Recruiting, Opportunity Marketplace -
Ability to know for how a long a job application is in a specific phaseSummary: Ability to know via reporting (SQL, OTBI) for how long a job application is in a specific phase Content (please ensure you mask any confidential information): H… -
Possibility to Create Reports on Job Application AI Rating Data for Custom ExportHello, I would like to ask if it is possible to create reports based on the data generated by the Job Application AI Rating functionality. Our goal is to understand whet…Ilaria Petrosino 2 views 1 comment 0 points Most recent by Mollyann Hart Recruiting, Opportunity Marketplace
-
How can I get an Oracle Recruiting - Job Requisition - Details - Deep linkI am looking for the deep link that you can use to directly take you to the actual Job Requisition Number. i.e. 16124 and Details page but could also be Overview. This i…Steven Game 9 views 1 comment 0 points Most recent by Volodymyr Faranosov Recruiting, Opportunity Marketplace
-
OTBI Prescreening Questions as column headers - Prescreening Questions OTBI ReportSummary: We have had a requirement to produce a prescreening questions OTBI report. The subject area has a column for Question Text and a few for the responses. Content …Alex Buckley 61 views 4 comments 1 point Most recent by CallumLambo5 Recruiting, Opportunity Marketplace
-
Redwood Recruiting Dashboard - How to add reports to the Recruiting Activity?Summary: Hello, I want to benefits for the great new feature in 25C which is the possibility to add custom reports to the Recruiting Activity Center page. I have follow …LucieWS 14 views 1 comment 0 points Most recent by Emil M-Oracle Recruiting, Opportunity Marketplace
-
Has anyone experienced issues with BI Reports pulling future-dated data from Offers?We only enabled Oracle Recruiting Cloud this year, and we have BI reports that have been built previously for Core HR/Compensation/Absence Management. Some of these repo…
-
How to get referral candidates details using BIP reportHi Team, Could anyone give me the sql query for referral candidates details. The report must contain Candidate Number Candidate Name Candidate added into the system date…
-
How to report the Interests entered in the Opportunity MarketplaceSummary: How to report the Interests entered in the Opportunity Marketplace Content (required): Hi, we would like to know if there is the possibility to build a report (…Barile Alberto 51 views 7 comments 2 points Most recent by David Chang R. Recruiting, Opportunity Marketplace
-
Referral Bonus ReportHi Experts, I am looking for an report for Referral bonus Payout. Below is the referral bonus criteria. - Referred new hire must work 90 work days for the referee to get…minati_behera-Oracle 55 views 2 comments 0 points Most recent by EmilyVB Recruiting, Opportunity Marketplace
-
How to retrieve timestamp when candidate submits RMI applicationSummary: Content (please ensure you mask any confidential information): Working to troubleshoot CSP automation and I am looking for a timestamp for when candidates submi…Giuseppe Cannova 21 views 3 comments 0 points Most recent by Marina Yavishkina-Oracle Reporting and Analytics for HCM -
How to print Annual Salary in text format in offer letters?Summary: How to print Annual Salary in text format in offer letters? Content (required): How to print Annual Salary in text format in offer letters? Version (include the…Gosu Ashok 24 views 3 comments 0 points Most recent by Ravi Tilekar Recruiting, Opportunity Marketplace
-
Loading Prescreening Questionnaire QuestionsSummary Loading Prescreening Questionnaire Questions to a Job Requisition TemplateContent I was searching for help on this on the forum but couldn't find anything but I …Pete Gutteridge-Paye 411 views 5 comments 5 points Most recent by Rushabh_Mehta Recruiting, Opportunity Marketplace -
Link to details of job requisitions.Content Hello everyone, we have implemented this OTBI report and have encountered the need to insert a link under the job requisition number that takes you to the job re…User_2025-02-07-06-30-13-200 86 views 9 comments 0 points Most recent by Shahbaz Mohmmed Recruiting, Opportunity Marketplace -
Date formatting doesn't work in Job offer letter templateSummary: Hi All! We are using format-date-nt expression for start date and end-date to avoid date discrepancy due to time zone conversion. Expression used: It is making…Balazs Grajczar 1 view 1 comment 0 points Most recent by Emil M-Oracle Recruiting, Opportunity Marketplace -
Need to report out on Candidates who has opted for Job AlertsSummary: Query or table and column information to report out which candidate has opted for Job Alets to receive updates about new job opportunities. Content (required): …Surabhi Kumari 91 views 6 comments 0 points Most recent by MHussain Recruiting, Opportunity Marketplace
-
Candidate while filling the form added email and name of an employee for referral bonus to employeehi I am creating inbound HCm extract to Load the referral bonus element entries for eligible employees. and taking the details from IRC_RF_Referrals for the referral. Bu…
-
US Payslip generation process failed to generate custom payslipSummary: Hi Team, Flowed below document mentioned step to customize the payslip. But payslip generation process generating the standard payslip instead of custom templat…Bala.putti1989 5 views 0 comments 0 points Started by Bala.putti1989 Recruiting, Opportunity Marketplace
-
Audit Requirement for DFF Fields in Job Requisition FormHello Oracle Community, We have a requirement to audit the Descriptive Flexfields (DFFs) that are configured under the Job Requisition form. However, when we navigate to…Jasbir_336630 1 view 1 comment 0 points Most recent by Alex N-Oracle Recruiting, Opportunity Marketplace
-
CAND_LAST_MODIFIED_DATE, LAST_UPDATE_DATE of IRC_CANDIDATESSummary: we are working on Candidate data purging process. We have noticed that CAND_LAST_MODIFIED_DATE, LAST_UPDATE_DATE of IRC_CANDIDATES are updating with out any rea…Kajal Ray 71 views 4 comments 0 points Most recent by Nick Dorfner Recruiting, Opportunity Marketplace
-
SQL Query to fetch the Job Application IDI am looking for SQL query to fetch the Job Application ID of a Requisition. Which tables can be used here? Please share the query if anyone has already tried to fetch t…Keerthi Chinthapatla 11 views 4 comments 0 points Most recent by Nivya Mathire Recruiting, Opportunity Marketplace -
Change the Start Date of the Candidates SQL exampleSummary: Change the Start Date of the Candidates SQL example Content (please ensure you mask any confidential information): Hi Experts, I need to compile a list of candi…Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov Recruiting, Opportunity Marketplace -
Contingent (Recruiter) Workers Unable to Access Recruit-to-Hire Dashboard SecuritySummary: What hidden security role or privilege grants access to the “Recruit to Hire Dashboard” function? Observation: When I assigned the following seeded roles, the R…SANDYACOSTA 37 views 2 comments 0 points Most recent by Denise N-Oracle Recruiting, Opportunity Marketplace
-
Issue with Subject Area - Recruiting - Recruiting Real TimeSummary: Hi Team, We have identified an issue in the "Recruiting - Recruiting Real Time" subject area related to the Internal Employee Number field. Specifically, the fi…Anupam Rana-Oracle 1 view 0 comments 0 points Started by Anupam Rana-Oracle Recruiting, Opportunity Marketplace -
What is the correct join of per_allocated_tasks table with per_allocated_checklists table ?What is the correct join of per_allocated_tasks table with per_allocated_checklists table ?when to join with per_allocated_checklists.ALLOCATED_CHECKLIST_ID=per_allocate…sdas 21 views 1 comment 0 points Most recent by Patricia-S-Oracle Recruiting, Opportunity Marketplace
-
Req approval reportingSummary Feasibility of OTBI report on workflow approval of requisitionsContent We have a requirement to create a report of requisitions pending req approvals with req de…Sandra Barr 89 views 9 comments 0 points Most recent by MarkHodges Recruiting, Opportunity Marketplace -
Is there a report or best practice to identify notifications currently in use?Summary: Looking to see if there is a BIP report or easy way to identify what notifications are currently in use and how they are triggered (e.g. part of the Candidate S…
-
ORC - What is the table name to get the candidate labelSummary:ORC - What is the table name to get the candidate label Content (required): ORC - What is the table name to get the candidate label Version (include the version …Uday Kiran Kareti 201 views 6 comments 0 points Most recent by Dona Das Recruiting, Opportunity Marketplace -
DFF Values Not Appearing in OTBI Report – IRC_REQUISITIONS_B TableSummary: Hi Oracle Community, We recently added two Descriptive Flexfields (DFFs) to the Job Requisition form using the following configurations: One field with a List o…Jasbir_336630 13 views 2 comments 0 points Most recent by Jasbir_336630 Recruiting, Opportunity Marketplace
-
Can I customize the data model for job application report to include employee esignature and date?Summary: I have a client requirement to display employee signature and corresponding date and time in the employee job application report template. However the data mode…DiptimayeeParida18 4 views 1 comment 0 points Most recent by Alan L-Oracle Recruiting, Opportunity Marketplace