OTBI
Discussion List
-
Drill downs in OTBI Direct Database Query reportsSummary Drill downs in OTBI Direct Database Query reportsContent Hi I have created a Direct Database Query report in OTBI which displays the employee counts joined in ea…SuryaMuralidharan 79 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
BI Author - Who should have the power?Summary Who is the targeted audience to receive teh BI Author role?Content Hello Experts, I have a bit of an abstract question and I'm looking for your opinions and to g… -
Download/Export from OTBI AlertContent Hi! I think this has been asked before, but is there any functionality or planned functionality to have a download/export from the OTBI Alert as attached? We are…User_2025-01-31-00-25-12-234 72 views 4 comments 4 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Report Returning Duplicate RowsSummary Learn Report on Evaluation Responses is returning duplicate rowsContent Created a report on responses to Learning Evaluations, but it is returning duplicate rows…User_2025-01-28-20-43-56-568 104 views 5 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Annualized TurnoverSummary Does anyone have a report that calculates annualized turnover by month?Content I have a table that calculates Turnover Rate by month but our management team is l…User_2025-01-28-20-43-56-568 152 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Employee Hire Date field in "Workforce Management -Person Real Time. Worker" Subject AreaSummary I used "Workforce Management - Person Real Time"."Worker"."Employee Hire Date" field in many OTBI reports. Now we are in 19 B and I can't find that field anywher…Elina Ovetsky 50 views 2 comments 0 points Most recent by Elina Ovetsky Reporting and Analytics for HCM -
How to pass dynamic URL in Action Links in OTBIContent We are trying to navigate to WebPage via action link in an OTBI analysis. The problem is when we will migrate this analysis from one instance to another we have … -
OTBI Cross Subject Area Analysis - Performance Goals and Feedback NotesContent Good afternoon, We are looking to build out an OTBI report where we tie performance goals to feedback notes related to the goals. We have attempted to build a cr…User_2025-01-23-23-27-03-729 93 views 4 comments 0 points Most recent by User_2025-01-23-23-27-03-729 Reporting and Analytics for HCM -
Subject Area for Custom Objects - UDTs and Lookups etcContent Do we have Subject Areas separately to handle/report on UDT and Lookups? I know we have some thing for UDTs -' Payroll - User Defined Tables Real Time'. But this…Vibha Pandey - Oracle 293 views 2 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Department Hierarchy ProblemSummary Having problems with Org/Department Roll-up FilterContent All, I am having a problem creating a reliable Org or Department roll-up filter in my dashboards. I use…Charles Egegbara 138 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Show Every Other Label on a Graph AxisContent I'm sure there's an easy way of doing this that I'm missing. I have a line graph showing our FTE trend over the last 12 months. I don't like the look of the x-ax…Lauren Owen 35 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Termination counts on graphs don't match Term detailSummary Created multiple reports for Terminations year over year but noticed the counts don't match that are reflected on the graphs versus what is in the detailed repor…User_2025-01-28-20-43-56-568 33 views 4 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM -
Pull date from prior rowSummary performance task number of days spentContent The start date in this is an excel field I manually created. Essentially, as people move thru the performance review…Mike Borghoff 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Benefits Status Report to monitor new hires who do not make benefit elections at all.Summary How will we be able to discern between a true waive and someone who has not touched enrollments?Content Is there away to query out employees who never went into …Vishal Gala 53 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Removing Rich Text Formatting from OTBI AnalysisContent Morning all, Can anyone suggest any ways of removing any formatting from text fields in OTBI? I'm trying to export our Goal Descriptions / Success Criteria / Com…User_2025-01-28-05-39-23-766 75 views 3 comments 1 point Most recent by Karen Waddell Reporting and Analytics for HCM -
County or District in OTBI AnalysisContent Can we get the County or District, which are additional attributes in Address, on an OTBI analysis.Vibha Pandey - Oracle 41 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Prompt: Realize a prompt filter beetween effective star and end dateContent Hi Guys, It is possible realize a date column in the prompt that allow me to show the rows in the report where the inserted date is between the effective star da…Giuseppe Iacono 73 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Goal Measurement ID in OTBIContent We are looking to confirm if 'Goal Measurement ID' exists as a reportable object in the Goals subject areas in OTBI. We are working on creating an HDL spreadshee…User_2025-01-23-23-27-03-729 26 views 7 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Termination Report based off Entry DateSummary Business need to create a termination report based off of entry dateContent Hello, Has anyone created a Termination Report that looks off of the termination/acti…User_2025-01-31-00-25-12-234 107 views 9 comments 1 point Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM -
How to pull Rate Name in Reporting?Summary How to pull Rate Name in Reporting?Content How do we pull rate names tied to employees benefits in analysis reporting? I have added the Benefits - Enrollments Re… -
Employee Self Service: how do you show employees their salary history?Summary Employee Self Service: how do you show employees their salary history?Content Hi, Our team would like to display an employee's own salary history on the Personal…Matthew Grillo-95429 125 views 5 comments 1 point Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
Employee not appearing on report; issue appears to be related to Top Manager Name fieldSummary Recreated current report with filter on the impacted employee to identify why she is not showing up on report. When I pull in Top Manager Name field, I get no re…User_2025-01-28-20-43-56-568 66 views 5 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM -
50,000 Cell Excel Export limit from OTBIContent My current client's Pods seem to have a 50,000 cell limit on exports from OTBI into Excel. I've never come across this restriction with previous clients, and for…User_2025-01-25-01-23-28-110 185 views 8 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
BI Report to achieve SANDWICH ABSENT DAYS CASES.Summary BI Report to achieve SANDWICH ABSENT DAYS CASES.Content BI Report to achieve SANDWICH ABSENT DAYS CASES. Please Kindly Help us to achieve these scenarios in BI R…Radhika Yalamanchili 36 views 2 comments 0 points Most recent by Radhika Yalamanchili Reporting and Analytics for HCM -
GenerateHead Error when writing Employee Changes ReportContent I have an employee changes report that runs fine until I try to add two additional fields to it (Cost Center and Manager Name). Now I'm getting a GenerateHead er…Lauren Owen 29 views 3 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM -
Worker Assignment Event - Created ByContent Hi, I am interested in finding out which user created the assignment event. I get the user "FUSION_APPS_HCM_ESS_LOADER_APPID" created this. How would I find out …User_2025-02-01-04-05-22-904 58 views 9 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM -
OTBI Reporting of the new Onboarding FeaturesContent We are looking at alternative designs for OTBI support for the new Onboarding feature and we'd appreciate your input. The existing Workforce Management - Checkli…Julian Challenger-Oracle 139 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Area for Onboarding TaskContent Hi All, Is there a subject area to pull the data from the Me-->Quick Actions-->Onboarding Tasks for the pending workers. I tried using the subject area: Workforc… -
Missing Talent Profiles on ReportsContent We are doing an HDL for License and Certifications and we are missing about 1200 employees when we try and pull the profile report attached. When we pull up one …User_2025-01-31-00-25-12-234 95 views 7 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Link to most recent scheduleContent All - In BI Publisher reporting, is it possible that we are able to provide a static link to the most recent scheduled report? I have a report that is run daily …Prudence K 34 views 2 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM