Analyses
Discussion List
-
Maximum Historical Status of a Req as of a point in timeSummary We want to know what the maximum historical status of each Req as of the beginning of each monthContent We want to know what the maximum historical status of eac… -
Email users based on report resultsContent Trying to create a daily report which is only delivered to hiring managers included in the report. The fields for the report are req id, req current status, and … -
OBI Report: Historical Status DateContent Hi, I have a report built to send data for candidates that have accepted an offer within a certain period of time. This report runs twice, daily. It runs at 7AM … -
Fiscal Week or Month reporting in OBISummary how to define dates when fiscal year does not correspond to calendar yearContent Hi! Our Fiscal Year this year started on January 1/31/2021. That was day 1 of we… -
Average Time From One Status To The NextContent I am trying to calculate the average time in days it takes our recruiters to move candidates from one status to the next by Requisition. I am able to get the cal…
-
Report on if candidate referral was effective at time of hireContent So when someone gets referred, they are active as the referrer for 120 days, then it shows Not Effective after that date. I'd like to report on how many candidat… -
Agents - Is it possbile to adjust Prompts when scheduling an agentSummary Agents - Is it possbile to adjust Prompts when scheduling an agentContent There seems to be a limitation with the ability to adjust prompts when scheduling an ag…
-
Formatting items on a graphSummary Need help with formatting dates and data on a graphContent Please help with me with converting week number to a correstponding date as shown in the attached docu…
-
Report column to show # submissions in a specific step/statusSummary please advise on correct formula syntaxContent I need to pull the number of candidates currently in the "New" step and the "To Be Reviewed" status. I am using th…
-
Offer ReportingSummary I need to report on Offer DatesContent I would like to create a report on offer dates and am struggling with how to do that. I am trying to report on what the Of… -
Exporting Attachments details - Visible to Candidate FlagSummary Exporting Attachments details - Visible to Candidate FlagContent Hello Experts I am trying to export all the attachments to candidates general profile or submiss… -
Hire Start Date suddenly off a dayContent So on Monday's we run an automated analysis of upcoming hires via the Hire Start Date field. It's been fine up until today. It now is showing Hire Start Date one…
-
Add "average" value at the bottom of a result columnContent Hi! How does one add a value = average of numeric values in a result column? I would like it to be a field that is visible in the report vs downloading the resul…
-
-
Reporting on #s of candidates that had EVER been in specific steps/statusesContent Hi! I am new to both OBI and Taleo and am looking for some guidance on a specific internal customer ask... I am being asked to create a report that would show fo…
-
Receiving error message when filtering by promptContent Hello All, I have a SQL formula that has condensed our Organization Level 2 data to make it more intelligible for the end user. Here is the formula: CASE IFNULL(… -
Scheduling agent to go to a recipient used in analysis condition?Summary Cannot successfully schedule an agent to email results to field (recruiter) in analysis.Content I'm trying to schedule a simple analysis/audit to run and deliver… -
TIMESTAMPDIFF between two statusContent Hello, I would like to calculate the number of days between two date from CSW status; I tried this formula : TIMESTAMPDIFF(SQL_TSI_DAY,(CASE WHEN "Submission CSW…
-
Pipeline type reportContent Does any one have a kind of pipeline report that shows the average amount of days a candidate spends in kind of custom "windows" as I call them? For example, how…
-
OBI report how to show only most recent candidate submissionSummary In a report of all submissions for a time period, how to only show the most recent for each candidateContent I have a report of all submissions for the year, and… -
Requisition On Hold DatesSummary We are building a report that will show how many times a requisition was put On HoldContent Requisition Data On Hold Date Reactivation Date Days On Hold 9-May-16… -
"NO RESULTS" text customization for reportSummary Can someone let me know if we can customize the text " "No results" The specified criteria doesnt result in any data"Content I would like to know if we can custo…
-
Custom Formula for Pending HiresSummary Issues calculating pending hiresContent Hello, Our Recruiters have requested a number of "Pending Hires" added to reporting. This would be calculated based on th…
-
Help with Duplicate Rows in Candidate Regulations FieldSummary Looking for a SQL Code to remove duplicate rowsContent Hello, I am using the Candidate Regulations "Race" field to report out hires information. I am finding tha… -
Reporting on Onboarding Task HistorySummary Looking to report on onboarding task historyContent Hello, I'm trying to report on onboarding tasks that are completed and who they were completed by. I have att…
-
Adding Case Formulas in Analysis FiltersSummary Adding Case Formulas in Analysis FiltersContent Hi Team, I have a custom report developed to fetch the most progressed status of a submission in a Requisition. T…
-
Column Deleted in 20A - "Candidate Passport Services Latest Request Status Event Date"Summary Reports failing due to error: State: HY000. Code: 27045. [nQSError: 27045] Nonexistent column: "Candidate Passport Services Request"."Candidate Passport Services…
-
Help with AVG functionContent I'm having some issues figuring out the AVG function. I'm getting data that doesn't make sense. So, the TA manager wants to know the avg amount of days between c…
-
Onboarding UDF'sSummary Onboarding UDF'sContent Hi Where can I find the onboarding UDF's? I looked in all the folders in BI and I cannot figure out where the data is housed for reportin…Michele Y 80 views 5 comments 0 points Most recent by Kristine Kukich-Oracle University-Oracle Taleo Enterprise -
Talent Managment OTBI reports SecuritySummary Security requirement for OTBI reportsContent Hello everyone, We have this weird requirement where we need to place security on OTBI reports. Security should be s…