OTBI
Discussion List
-
OTBI Union ALL Sort OrderSummary Need to sort the first union query using UNION ALLContent Hello, Just wanted to ask if there was a way to sort the first query created that is then UNION'd ALL w…User_2025-02-05-12-12-38-615 77 views 4 comments 0 points Most recent by User_2025-02-05-12-12-38-615 Reporting and Analytics for HCM -
How to compare EE and Manager DetailsSummary OTBI report neededContent We are auditing some of our HCM data. We would like to compare an employee's department against their manager's department. Most of the…Ashley Cossey 18 views 2 comments 0 points Most recent by Ashley Cossey Reporting and Analytics for HCM -
OTBI CASE Statement across Subject AreasSummary Attempting to write CASE IF statement for data across subject areas in OTBI and receive errorContent Business requirement is to write a CASE IF statement to popu…user9020833 118 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Age BinsSummary Invalid Alias FormatContent Hi, I've copied a formula that calculates the age of an employee from the following Oracle video: https://www.youtube.com/watch?v=QpG…User_2025-02-05-22-44-35-842 25 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to get the classroom for an Activity learning item?Content Hi everybody, I should report the classroom for Activities but I am not able to get it. I don't find the link between the activity id and the classroom id (this … -
OTBI - How to download Archive file via web serviceSummary OTBI - How to download archive file via web serviceContent Hi, I'm considering to automate below archive process through web service. 1. Navigate to report path …
-
Unable to Export HTML Narrative View for OLC Learning CertificateContent Hello, I followed this post to create an Oracle Learning Cloud certificate in OTBI using HTML with the attached report and Narrate View code. It is displaying pr…User_2025-01-31-00-25-12-234 38 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to delete duplicated records in OTBI AnalysisContent Hello experts, I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only. However, the analysis return…Valerio Curzi 1.2K views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Understand SQL Query for Talent profile data modelContent Hi Everyone, I have created the data model for talent profile print action with the help of delivered data by oracle. In delivered data model oracle has used a s…Misbahul Khair 96 views 3 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
"Department Name" Attribute Missing from "Workforce Management - Person Real Time"Summary "Department Name" Attribute Missing from "Workforce Management - Person Real Time"Content Hi Experts, While trying to build a custom OTBI Analysis on "Workforce …AshishERPCloud 41 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Reports (and Dashboard) SharingSummary Request for best Practice for Reports (and Dashboard) SharingContent Hello all! We have newly implemented HCM Fusion and received little guidance concerning Repo…User_2025-02-05-11-42-08-011 148 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get UI value on SQL outputContent Hello Experts, How we can pull or put some conditions to get the result. Eg. There are few fields with drop value like Yes, No but when I am pulling the data thr…Misbahul Khair 22 views 3 comments 1 point Most recent by Karthik K-Oracle Reporting and Analytics for HCM
-
Unable to view Full-Time Equivalent value from OTBIContent Hi All, We created OTBI report based on "Workforce Management - Worker Assignment Real Time" subject area but unable to view "Full-Time Equivalent" data from OTB…
-
Union Analysis Needed for SecuritySummary need assistance with a union analysisContent I am in need of assistance with an analysis. I need to capture all hourly employees who do not have the 'Employee Ho…Shelly Feyerherm 15 views 6 comments 2 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Reporting on Questionnaire ResponsesContent Hi All, We're getting ready to deploy an onboarding questionnaire as a task in our enterprise onboarding checklist. Does anyone know which subject area can be us…Lauren Owen 218 views 15 comments 0 points Most recent by Shweta Ganguly-Oracle Reporting and Analytics for HCM
-
Performance Rating Real Time- Is there a way to rate overall sections?Summary A client would like to report on overall competencies. There seems to be calculations for section ratings, but not that actual section rating itself. Is there a …
-
Manager Hierarchy of terminated employeesSummary Manager Hierarchy of terminated employeesContent Hello, I need to pull an OTBI Report to grab the Manager Hierarchy (Up to Level 6) for terminated employees. I h…User_2025-02-04-15-06-22-759 227 views 2 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Return the Line Manager at a Point in TimeSummary Return the line manager at a PITContent Hi all I am trying to build a report that displays the line manager against the person at a specific point in time howeve…Dawn Cawston - CPS 28 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Images on InfoletsSummary We want to find suitable images to display on our infoletsContent Hello, For some of our infolets where it isn't relevant to see a count of colleagues e.g. numbe…User_2025-01-28-05-32-59-092 75 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Emergency Contact Report not returning phone resultsSummary The phone results in the Person Contact Relationship folder is not returning any resultsContent Using the Workforce Management - Person Real Time subject area. P…User_2025-01-28-20-43-56-568 111 views 18 comments 0 points Most recent by User_2025-01-31-18-28-58-561 Reporting and Analytics for HCM
-
How to add the computer name to report?Summary Wish to show the computer name that requested a report to be runContent The user has requested that as part of a custom report to show not only the Date and Time…
-
Worker Assignment Event Real Time Date PromptSummary Date Prompt not workingContent Hi, I'm trying to add a calendar date prompt to the this report that will show me all promotions between date from & date to dates…User_2025-02-05-22-44-35-842 63 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Oracle Error 25137 - Data Value Out of RangeContent Afternoon all, Oracle built us a dashboard a few years ago that compares data fields between two dates, to highlight changes (SQL attached). However, we are now …User_2025-01-28-05-39-23-766 131 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Receiving Maximum Number Of Input Records Error When Creating a .csv File From OTBISummary Receiving Maximum Number Of Input Records Error When Creating a .csv File From OTBIContent Good morning Everyone, After taking the 20A update we are receiving th…Daniel McMillian 46 views 4 comments 0 points Most recent by Daniel McMillian Reporting and Analytics for HCM
-
Can we get ETEXT output from OTBI Report?Summary Can we get ETEXT output from OTBI Report.Content Hi Experts, Is it possible to get ETEXT output from OTBI Report ? Thanks, Madhu Version R13Madhu N-155308 20 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Alert Composer not getting all records from databaseSummary Alert Composer not getting all records from database, even though using OTBI I get all using the same queryContent Hi I have created a simple alert in Alert comp…
-
Term report by date enteredSummary Having trouble getting term report by action date, not term dateContent Hello, Hoping someone can help. We went live with Oracle the 1st of this year and having …User_2025-02-05-07-51-01-504 31 views 13 comments 0 points Most recent by User_2025-02-05-07-51-01-504 Reporting and Analytics for HCM
-
success criteria with html balise in bi publisherSummary How can I delete the html code in success criteria column in bi publihserContent Hello, I want to delete the html balise for the column success_criteria from the…User_I6AXL 37 views 13 comments 0 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
Model Profile - OTBISummary Having difficulty with the model profile subject area for reportingContent Hello I have the attached report that looks to bring through the model profile informa…Andrew Braid 95 views 4 comments 0 points Most recent by User_2025-02-07-09-44-11-289 Reporting and Analytics for HCM -
When filtering on 2020 data for Turnover Dashboard, 12/31/19 terminations are included.Summary When filtering on 2020 data for Turnover Dashboard, 12/31/19 terminations are included.Content We have a dashboard for turnover data. There are several prompts t…User_2025-01-28-20-43-56-568 39 views 7 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM