OTBI
Discussion List
-
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 58 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 56 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 417 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 180 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 51 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 51 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 9 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 342 views 5 comments 1 point Most recent by User_2025-02-07-16-42-37-187 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 26 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 54 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 27 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Latest Start DateSummary Is there a latest start date field in OTBI? Need length of service in current assignmentContent Hi, I have a report that calculates the Time in Service of employ…User_2025-02-05-22-44-35-842 44 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report on Absence approved dateSummary Report on Absence approved date in OTBIContent Please share the steps to capture Absence approved date when reporting on other absence details in OTBI. I have se…
-
NRA Year to date EarningsSummary Trying to find the NRA YTD 8233 Earnings for an employeeContent Can you please suggest how to get this balance in Subject area. Please see the below Navigation: …
-
Calculated cloumn is not having value with decimals (Expected value --> 383/12 = 31.9 but current vaSummary Using TIMESTAMPDIFF function getting total months between two dates(Ex: 383 Months) when dividing 383 with 12 (383/12) current value coming as 31.0(383/12 =31.0)…User_2025-01-30-17-37-30-647 35 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM