Custom Formulas
Discussion List
-
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… -
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…
-
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…
-
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 … -
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… -
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…
-
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 70 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…Michelle Graham-29105 48 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…
-
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 381 views 0 comments 5 points Started 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…
-
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 …
-
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…
-
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…
-
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 83 views 2 comments 1 point Most recent by Magdalena Gorska 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…Alice Kim, SPHR-SCP 48 views 7 comments 2 points Most recent by Alice Kim, SPHR-SCP 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…Michelle Graham-29105 51 views 4 comments 0 points Most recent by Michelle Graham-29105 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 …
-
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 … -
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… -
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…Valerie Reyna Villarreal 61 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…
-
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 …
-
Formula Help - Pulling data since beginning of yearSummary Writing formula to display results that only coincide with current yearContent Hello, I am creating a report that should only pull the candidates that have been …Sarah Volckmann-10978 61 views 6 comments 0 points Most recent by Sarah Volckmann-10978 Taleo Enterprise -
Reporting on Profile Sources/ Source TypesSummary OBI Assistance- Profile Source FieldsContent Hello, I am trying to splice out my "Profile Source" field in OBI into two separate columns. Current report: Candida…
-
Return only the most recent General Profile- OBISummary Looking for a formula to return the most recently created profileContent Hello, I am having issues reporting on General Profiles. I am using all candidate fields…
-
Req. Saved as Open Date and ageing weekSummary Req. Saved as Open Date and ageing week calculationContent Hi there, I am create an average time to fill report and I have added all fields except two fields tha…
-
Offer Approval Cycle Time (by individual approver)Summary Offer Approval Cycle Time (by individual approver)Content Hello - We're trying to build a report to show the # of days it took for an approver to approve an offe…
-
Reporting on a "As Of" Date - Any Suggestions?Summary Trying to leverage an existing data field/derived field to calculate an as of date to report on historical data and get a snapshot of data at a point in time.Con…