OTBI
Discussion List
-
Future Direction of SOAP on OTBISummary What is the future/strategic direction of SOAP on OTBIContent Hi, We've developed an automated deployment tool for OTBI using SOAP calls and we've invested signi…Syaifuddin 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get the manager's manager name in OTBIContent Hi, I got the employee manager name in OTBI subject area's and we need manager's manager name in OTBI. Please let me know the presentation table and column for t…Janardhana Kondaveeti 123 views 7 comments 2 points Most recent by James Hoffmann Reporting and Analytics for HCM -
OTBI Chart Legend TotalsSummary Totals to be included on the chart's legendContent Is there a way to include the totals on the charts? We are creating a dashboard with several pie and bar chart…Shelly Feyerherm 19 views 5 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM
-
Employee Unable to Pull Offering Primary Instructor - Oracle Learning CloudSummary Employee can pull their complete transcript in OTBI, but Offering Primary Instructor is BlankContent We have a requirement for an employee to pull their Learning…User_2025-01-31-00-25-12-234 47 views 3 comments 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
Bank Holiday Time Element EntrySummary Bank Holiday Time Element EntryContent Hi, We are trying to report on Employees who are looking to get their Personal Contribution for Bank Holiday Time worked a…Tim Hopkins 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker ****Summary What are the roles and permissions required to be given to a userID so that he can use "Workforce Management - Worker Assignment Real Time" subject area and extr…Dharmendra Shukla 54 views 12 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?Walid Hamdy 36 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
OTBI Report that References Results of another OTBISummary Is there a way to have one OTBI report reference the results from another OTBI report?Content Hi All, Our use case: We need an OTBI Contractor report that also i…Denise Izzi 114 views 15 comments 2 points Most recent by Denise Izzi Reporting and Analytics for HCM -
Data Security when creating HCM OTBI reports for non-HR usersContent We want to create a few reports that need to be available to either Finance or Office Managers which get the data from the Oracle HCM module. Some examples, but … -
New DFF Segment Not Appearing in OTBIContent Hello, I've added some new segments to the Document Record DFF. I ticked the box labelled "BI Enabled" for each segment, and both verified/deployed the DFF. Its …User_2025-02-07-03-52-39-913 411 views 16 comments 2 points Most recent by Akshay Aiyer Reporting and Analytics for HCM -
Is there a Subject Area to View all Address Attributes?Summary I am migrating international employees into our system and want to report on their addresses however, I cannot find some of the fields within the subject area to…HROps17 173 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Average Time in JobSummary Creating a graph of average time in JobContent Hi all, I am working on a couple of reports where I am looking for the Average time a person has stayed in a Job, …User_2025-02-05-05-51-12-049 17 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Link between Pending Worker and an Employee in OTBISummary Link between Pending Worker and an Employee in OTBIContent Hi All, I have a requirement where I need to build a performance tile which needs to report the count …User_MC37Q 52 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
HCM – Product Office Hour: OTBI November 2020Content Submit your questions for the HCM – Product Office Hour: OTBI November 2020 session to have them answered during the live event. Post your questions by posting a…Heather Hagedorn- Cloud HCM-Oracle 52 views 10 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 52 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error in Report - Date not filtering properly with other variables in Oracle ReportSummary dates not filtering correctly with other variableContent I am trying to filter dates with step increases in a custom Oracle Report; the objective is to show how …User_2025-02-06-20-46-18-602 10 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Adding Row # and Row Count to a report?Summary Looking for a way to include a row count in a reportContent We have recently moved to HCM Cloud after using Peoplesoft. Peoplesoft Query provided a row count in …User_2025-02-07-16-42-37-187 317 views 5 comments 1 point Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM -
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new …User_2025-02-05-04-46-07-194 51 views 2 comments 1 point Most recent by Jo Black Reporting and Analytics for HCM -
Delivered Reports/Dashboards - Security ConcernsSummary Delivered Reports/Dashboards - Security ConcernsContent Hello, We are currently implementing and discovered today that delivered reports contain some sensitive i…User_2025-01-23-21-37-42-476 72 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Cross posting this idea in HCM Reporting and Analytics forum - ability to Audit OTBI report configuSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch LE Setup in OTBISummary How to fetch LE Setup in OTBIContent Hi Team, Can we fetch LE setup details using OTBI tool in oracle fusion HCM? The fields that need to be fetched are Code, Na…User_2025-02-06-10-22-06-460 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need help on Employee Personal Contribution report buildSummary Need help on Employee Personal Contribution report buildContent Hi Team, We are in the process of developing a report that report will be used to identify employ…Mahendra 27 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Analysis error - ODBC driver returned errorSummary I developed an analysis and it works for one user and error for anotherContent Hi All, I created one analysis and it runs find for one user and error to other on…Peoplesoft 50 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D.Summary HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D. BI version is Oracle Business Intelligence Product Version 11.1.1.9 (Build 11.1.1.9.0BIFNDN…Mohd Shahnawaz Mohd Merajuddin-Oracle 56 views 12 comments 0 points Most recent by Mohd Shahnawaz Mohd Merajuddin-Oracle Reporting and Analytics for HCM -
Workforce Management - Accrual Real Time/Worker Assignment Event Real TimeSummary Issue when combining subject areasContent Hi! Really hoping someone can help with my query. I would like to show the annual leave absences taken by month for a p… -
Learning Hours ReportContent Hi, Has anyone created or come across a report showing the actual or attempted start and stop time of a learning class/course? Thank you!Dishti Malhotra-Oracle 47 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
HCM – Product Office Hour: OTBI, 30 September 2020, 8 a.m PT - Submit QuestionsContent Submit your questions for the HCM – Product Office Hour: OTBI, September 2020 session to have them answered during the live event. Post your questions by posting…Heather Hagedorn- Cloud HCM-Oracle 40 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where to save analysis to be able to use them in Learning AssignmentContent Hello, I created some analysis in OTBI and I should use them to assign Communities to Learners in OLC, but I am not able to find them while performing the add Le…Virginia M. Calvi 23 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
OTBI Analysis not workingSummary Report has stopped workingContent Hi, One of our most popular reports has stopped running all of the sudden - it seems like I'm the only person who can still run…User_2025-02-05-22-44-35-842 46 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Max Scheduled Reports RowsContent I've found this post from a long time ago that discussed 25k as a max for scheduled reports. I'm still encountering this even with csv. Is this the limit on sche…User_2025-01-31-00-25-12-234 29 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM