Reporting
Discussion List
-
What is the analysis used in OTBI to pull requisitions currently in the job formatting phase?Summary: Currently trying to write a report in OTBI that shows on the requisitions in the job formatting phase. Content (required): I am able to pull the information for…Tyler Buczynski 36 views 4 comments 0 points Most recent by Cheryl Calsetta Recruiting, Opportunity Marketplace -
What is the report name/path that is used in the 23A enhancement "Metrics in requisition overview"?Summary: 23A enabled users to view metrics in the requisition overview tab. The metrics section displays an OTBI report. I'm trying to track down the name/path of that r…Michael Glassco 64 views 2 comments 0 points Most recent by Em-Jay Recruiting, Opportunity Marketplace -
Application Source TableSummary: Hello - does anyone know the table name where the Source is captured for applications? i.e. Indeed, ziprecruiter etc. I was able to locate the SOURCE_TRACKING_I…Jose Castelan 53 views 4 comments 0 points Most recent by Jose Castelan Recruiting, Opportunity Marketplace -
Job Offer Preview error messageSummary: Content (required): Hello experts, when the agent clicks on Preview Offer the report is not visible and a message error is returned. What privile is missing? Th…Valerio Curzi 26 views 2 comments 0 points Most recent by Valerio Curzi Recruiting, Opportunity Marketplace -
Show the Grade Range values Minimum, Maximum, Midpoint in Job RequisitionSummary: Show the Grade Range values Minimum, Maximum, Midpoint in Job Requisition Content (required): It looks like we don´t have the grade range available in job requi… -
SQL query time exceeds the limit (500). Stopped processingSummary: I am getting this error while running the BI report Content (required): I am getting this error while running the BI report, SQL query time exceeds the limit (5…SKDasaraju 787 views 1 comment 0 points Most recent by MandeepGupta Recruiting, Opportunity Marketplace -
When we trigger the "Alert Notification" the Word and Token and Merge.Summary: Hi Team, When we trigger the "Alert Notification" the word and Token in the Subject line of the Notification are in single word if give the space in the content…Krishna Sigilipalli 25 views 1 comment 0 points Most recent by Srujan Karanam-Oracle Recruiting, Opportunity Marketplace -
Stacked Requisitions and reporting # Avg Time to Fill (Days)Summary: I am stuck. I want the # Avg Time to Fill (Days) delivered formula (in the Requisition Aging KPIs analysis, which is part of the Recruit the Hire dashboard) to …Jessica D 75 views 1 comment 0 points Most recent by David --Oracle Recruiting, Opportunity Marketplace -
Able to create reports from "Include in Marketing Campaign" opt in?Summary: Wondering if the field: Include in Marketing Campaign is available in OTBI? Content (required): I am unable to find it when searching in all Recruiting Subject …Melissa Drysdale 35 views 1 comment 0 points Most recent by Alan L-Oracle Recruiting, Opportunity Marketplace -
Filled Requisition DateSummary How can I change the format of my newly create field to be a 'Date' field, that then allows me to be able to prompt on Dates Between in the front page filters.Co…Karen Doig 44 views 1 comment 1 point Most recent by Alan L-Oracle Recruiting, Opportunity Marketplace -
How to extract job application status within expired job requisitionSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
Opportunity Markertplace: How to embed an OTBI\Dashboard in reporting tabDears, I enabled the "Reports" tab in Opportunity MarketPlace. I want to embed inside this page a report in OTBI. During a Workshop Oracle (link: https://videohub.oracle…Antonio Stornello 93 views 3 comments 0 points Most recent by Antonio Stornello Recruiting, Opportunity Marketplace -
Prescreening and DisqualificationSummary: Values are falling under column level, in reports but customer is expecting the questions and answers to be in the Row level it self Content (required): In ORC …SKDasaraju 24 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Recruiting, Opportunity Marketplace -
Page Entry Usage Details RequiredSummary: We have create some custom page entries and we need to know how many users are clicking or accessing the page with the page entry. Content (required): Is there …Sidulle 43 views 1 comment 0 points Most recent by ChelcieN-Oracle Recruiting, Opportunity Marketplace -
Historial record for candidate source in 23ASummary: In 23A we have the new option to edit the source of the candidate, but we want to know if it is possible to audit or keep the historical record Content (require…Rodrigo Durán 74 views 1 comment 0 points Most recent by Alex N-Oracle Recruiting, Opportunity Marketplace -
Token is not translated in Job Offer LetterContent Hello, I create a job offer letter for Germany. So, I created a template thanks to BI publisher plug in in word. In this template I have the field "Temporary / R…Audrey Corbellini 110 views 5 comments 0 points Most recent by Prabhsimran Recruiting, Opportunity Marketplace -
KPI: time to hireSummary recruiting, KPI, reportsContent Hi, How do you calculate KPI for recruiting? For example: time to hire? We are investigating: from job requisition approval date …User_2025-02-05-07-40-31-235 48 views 2 comments 0 points Most recent by Srujan Karanam-Oracle Recruiting, Opportunity Marketplace -
Add posting description into Approval NotifcationSummary: Is there a way to pull the job posting description into the Job Requisition Approval Notification? Content (required): I have followed How to Modify Offer or Re…SophiaRavenscroft 45 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Recruiting, Opportunity Marketplace -
Struggling to use OTBI to report on # ever in custom phases and statesWe are building a report to include data on job requisitions. It should include columns for the number of candidates in certain phases/states of the application process.…rd17 111 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Recruiting, Opportunity Marketplace -
How to report on Interview Feedback Details?Summary: We would like to create a BIP report on the following Interview Feedback details, so that Recruiters can review/compare the detailed feedback from all Interview…Ronnie George 347 views 1 comment 0 points Most recent by Srujan Karanam-Oracle Recruiting, Opportunity Marketplace -
Need input to capture the Requisition progress phase durationSummary Need input to capture the Requisition progress phase durationContent Need to capture the phase duration from posted to filled for a Job requisition. Is there a w…Oguri Rama Yogaiah 40 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Recruiting, Opportunity Marketplace -
Agency - Candidate OwnershipSummary: Content (required): I am aware that there is restrictions for recruiters to see the length of ownership on a candidate that has been referred by an agency and w…Ivor Ferris 85 views 3 comments 0 points Most recent by Srujan Karanam-Oracle Recruiting, Opportunity Marketplace -
Unable to find CSP Name and Background package details in IRC_REQUISITION_B tableSummary: Hi We are trying to create a report and fetch requisition details like CSP name, Background check package selected on the requisition. I could not find the deta…User_2025-07-18-04-46-22-973 55 views 2 comments 0 points Most recent by User_2025-07-18-04-46-22-973 Recruiting, Opportunity Marketplace -
Candidate Pool and Harver Assesment custom report in OTBISummary: Custom Report Content (required): Hi, We need to create custom reports on candidate pools and assessments (we have integrated Harver , an Oracle's partner) in O…Alessia Da Dalt 26 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace -
Recruiting Pipeline ReportSummary: Content (required): Hello, We would understand how the standard report Recruiting Pipeline work: We would know the reason why It consider inside the phase the h…Giuseppe Iacono 24 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace -
Bursting Query Email Display NameSummary: We have a custom BIP notification with a bursting query that defines the FROM email address that the notification send from which is triggered for new hires in …Shanna Oppenheim 35 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace -
Reporting on latitude and longitude from RecruitSummary: Is it possible to report on latitude and longitude for advertised work locations in Recruit via BI? Content (required): Version (include the version you are usi…Robbie Bloomer 2 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace -
Extended_date column is null in IRC_OFFERS TableSummary: Extended_date column is null in IRC_OFFERS Table Content (required): Hi All, I am working on candidate offer details report, in which i am looking for candidate…NitinSharma28 83 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace -
Identify device type of Job ApplicationSummary: Hi, In ORC, is there any way to identify if the job application is from a Mobile device, Desktop, iPad, etc? Content (required): We would like to know the devic…Rahul Salot - Mastek 16 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace -
How to display In Direct Reports in "Request Feedback" page for Line ManagersSummary How to display In Direct Reports in "Request Feedback" page for Line ManagersContent Hello All - We have a requirement to display Direct + In direct reportees fo…Ravi Desetty 41 views 1 comment 0 points Most recent by Ian M-Oracle Recruiting, Opportunity Marketplace