Custom Formulas
Discussion List
-
Requisition Primary Location Zip CodeSummary Looking to only show Primary location zip codeContent Hello, I am looking to show the primary location zip code in an OBI report. I noticed under Requisition Pri…Kellyzuckerman 47 views 1 comment 0 points Most recent by User_2025-01-25-01-06-59-455 Taleo Enterprise -
Application Historical Tracking Date and corresponding Application Historical CSW StepSummary Application Historical Tracking Date and corresponding Application Historical CSW StepContent This is an easy one but my brain is fried with the upcoming holiday… -
Need to display which candidate filled the last open position of filled requisitionsSummary We are not able to display which candidate has filled the last open position of filled requisitionsContent Hi, We have created below custom formula to display th…User_2025-01-28-05-32-41-814 33 views 1 comment 0 points Most recent by Santosh Tekumalla-14206 Taleo Enterprise -
Subtract 3 hours from a dateSummary Subtract 3 hours from a dateContent Hi All, I'm trying to subtract 3 hours from a date and cannot get the formula to work. Formula in BO =RelativeDate([Job Offer…User_2025-01-23-22-13-40-899 52 views 5 comments 0 points Most recent by Santosh Tekumalla-14206 Taleo Enterprise
-
Create a variable to count offer accepts where start date is > current dateContent Hello, I am creating a table that counts by location the various stages of the candidate life cycle. One of those counts is on offer accepts where the start date…User_2025-01-23-23-38-26-219 31 views 2 comments 1 point Most recent by User_2025-01-23-23-38-26-219 Taleo Enterprise
-
Report to show all candidates at least at offer - draft PLUS requisition details of candidate countsSummary Report to show all candidates at least at offer - draft PLUS requisition details of candidate counts at selected step/statusContent I am trying to recreate a rep…User_2025-01-28-05-26-41-549 25 views 1 comment 0 points Most recent by Jennifer Tanous-44292 Taleo Enterprise
-
Compliance reportSummary Trying to filter report to show personnel areaContent Creating a compliance report from BO to OBI that is using a subquery. Need to use the Req Identifier to wri…User_2025-01-23-23-19-49-770 44 views 1 comment 0 points Most recent by Dawn Phipps Taleo Enterprise
-
First Req. History Transaction date (when posted externallly)Content MIN(CASE WHEN "Requisition Posting"."Posting Source" = 'Career Section - EXTERNAL' THEN EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER,"Requisition Tracking History"."Re…User_2025-01-28-07-26-11-852 62 views 9 comments 0 points Most recent by User_2025-01-28-07-26-11-852 Taleo Enterprise
-
Filter or dashboard prompt issueContent Hi, I wonder if anyone can provide answer to this. I created a req report which includes names of recruiter. I applied a prompted filter on Recruiter as I planne…User_2025-01-28-07-26-11-852 60 views 9 comments 3 points Most recent by User_2025-01-28-07-26-11-852 Taleo Enterprise
-
Current Date/Time Stamp in OBI AgentSummary Looking to put a date/time stamp in the subject line of my OBI agentContent Hello, I would like the subject line of my OBI agent to contain the date/time of the …Kellyzuckerman 70 views 2 comments 2 points Most recent by User_2025-01-23-23-38-26-219 Taleo Enterprise
-
Display values in separate columnsSummary Display values in separate columnsContent Is there a way to display the Evaluation Evaluator Name field is separate columns if there are more than one? I have tr…User_2025-01-23-20-11-29-895 50 views 1 comment 0 points Most recent by Charu Vohra Taleo Enterprise
-
How to get the nationality of a candidate or the language spoken by the candidate?Summary How to get the nationality of a candidate or the language spoken by the candidate?Content Hi All, One of my team members wanted to access all Dutch speaking cand…User_2025-01-28-04-22-02-757 57 views 0 comments 0 points Most recent by User_2025-01-28-04-22-02-757 Taleo Enterprise
-
Need help calculating the percent different between two columnsSummary Need help calculating the percent different between two columnsContent We are creating a recruiter scorecard in OBI. I've used a CASE WHEN formula to enter in ea…Jordan DeLellis 65 views 1 comment 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise -
Report to identify duplicated reqsContent I've been asked to run a report to see how many reqs have been duplicated since September 1, 2016. I know this shows in history, but what field can I pull that w…User_2025-01-25-04-51-45-357 42 views 13 comments 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
BO formular to OBISummary Me trying to breakdown a BO code...Content Round( (Truncate(DaysBetween([Min Post Date - All Reqs];CurrentDate()) / 7 ; 0) * 5) + ToNumber(Substr("12345551234445…User_2025-01-28-07-26-11-852 39 views 1 comment 0 points Most recent by User_2025-01-28-07-26-11-852 Taleo Enterprise
-
How to Knowledge DocumentsSummary Documents provided in MOS by Support to guide you through common tasksContent Published OBI KM Docs KM Doc ID KM Doc Title KM Document Type Reference Documents 2…Rachel Martorelli-Oracle 743 views 0 comments 6 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise -
HTML TagsSummary Include HTML Tags in OBI ReportContent I am trying to build an OBI report that would include the HTML tags with the description and qualifications for our posted…User_2025-01-25-03-53-30-763 85 views 4 comments 0 points Most recent by User_2025-01-25-03-53-30-763 Taleo Enterprise
-
Pull Analysis with Current Status as of a certain time/dateContent Hello, I have a graph set up in OBI where I need to re-pull it as of last Friday 10/28 as of noon. I already have a filter on it for Req Creation date less than …Kellyzuckerman 54 views 3 comments 0 points Most recent by User_2025-01-22-20-20-44-584 Taleo Enterprise
-
Display dates on same row?Summary How to display custom dates on the same data row?Content I am using a formula to show dates using a specific step and status. The formula works but since I am us…User_2025-01-23-20-11-29-895 75 views 5 comments 0 points Most recent by User_2025-01-23-22-14-30-510 Taleo Enterprise
-
MAX "Profile Passport"."Profile Service Status Log Date"Summary MAX "Profile Passport"."Profile Service Status Log Date"Content I am trying to get max date (latest activity date) and the results status ("Profile Passport"."Pr… -
Changing Date Format to use in PivotSummary Changing Date Format to be able to use Date as a Measure in a Pivot TableContent I have searched high and low. I am trying to pull a usage report and wanted to u…User_2025-01-23-20-07-00-854 60 views 3 comments 1 point Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
OBI Filter Week To DateContent Hello OBI Users, I was asked recently how to create a filter that would give results based on the week to date and I want to share my solution with you. Assuming…Rachel Martorelli-Oracle 78 views 2 comments 1 point Most recent by User_2025-01-22-20-02-29-023 Taleo Enterprise
-
Reporting on requisition posting statusSummary provide detail on whether or not a requisition is posted to a specific career siteContent In Business Objects I was able to include information on whether or not…User_2025-01-23-23-38-26-219 43 views 7 comments 2 points Most recent by User_2025-01-23-23-38-26-219 Taleo Enterprise
-
Report on Reqs/Candidates by Career SIteContent We need to create a new careers site to "hire" all of the employees we are acquiring in an acquisition. I am going to create a careers site for them to gather th…User_2025-01-25-04-51-45-357 52 views 4 comments 0 points Most recent by User_2025-01-25-04-51-45-357 Taleo Enterprise
-
Previous Employer Value from OBI ReportingSummary Need to know which field to include in a report to get the previous employer value of an applicantContent Hi, I am currently working on creating a report in OBI …User_2025-01-28-04-22-02-757 35 views 1 comment 0 points Most recent by Sachin Sirohi Taleo Enterprise
-
Other (specify) Reject Motive CommentsSummary how to pull comments entered when recruiter rejects with motive of Other (specify)Content I was able to accomplish this by using a separate query in BO but I am …User_2025-01-23-22-02-51-715 41 views 1 comment 0 points Most recent by User_2025-01-23-22-02-51-715 Taleo Enterprise
-
Latest - Historical Step/Status CommentsSummary Latest - Historical Step/Status CommentsContent Hi there, I have created a report (attached) and I added Historical Step/Status Comments. However, I got the repo…User_2025-01-25-05-14-55-725 79 views 3 comments 1 point Most recent by Jody Reutemann-9500 Taleo Enterprise
-
Calculating Percent Difference between two columnsSummary Calculating Percent Difference between two columnsContent Hello - Does anyone know the best way to calculate the percent difference between two columns? We are t…User_2025-01-23-21-59-01-568 54 views 1 comment 0 points Most recent by Santosh Tekumalla-14206 Taleo Enterprise
-
Latest - offer accepted dateSummary Required formula for populating latest - offer accepted dateContent Hi there, I have created a report that contains all hired candidates details. I have populate…User_2025-01-25-05-14-55-725 93 views 4 comments 0 points Most recent by User_2025-01-25-05-14-55-725 Taleo Enterprise
-
Custom formula used more than onceSummary Custom formula used more than onceContent Hello is there a way to save a custom formula in OBI that is used more than once on multiple analyses - like we can do …User_2025-01-23-22-10-45-747 68 views 4 comments 0 points Most recent by User_2025-01-25-04-11-45-026 Taleo Enterprise