OTBI
Discussion List
-
Remove Edit Capability from the Reports Shared Folder but Retain Edit Capability in the My FolderSummary: We are trying to update report permissions to remove the edit capability from the shared folder but retain the ability to edit in reports in My Folder. We have …G. Class-Peters 18 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.Shanna Oppenheim 29 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Adding Total Headcount and Response Percentage Columns in OTBI ReportHi Community, I am working on an OTBI report that aggregate responses from employees related to their self-identification. Current Setup: The report currently includes c…Ashok Kumar Sharma 28 views 1 comment 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM -
V3 Seniority Dates in OTBISummary How to report on V3 dates in OTBIContent Hello, We're migrating to the V3 seniority dates with the release of 20B, but we're running into a number of reporting i…Whitney Van Way 103 views 8 comments 1 point Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 294 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Year over year disability disclosure reportsOur requirement is to provide a report and graph with year over year counts of disability self disclosures. Attached is an xml version of my report. I'm joining the Work…Jenna Fuchs 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Identifying duplicate emailsSummary: An analysis that highlights the same emails being registrered to multiple persons Content (please ensure you mask any confidential information): I need an OTBI … -
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct…
-
How to find Grade ID for EmployeesHi, I am trying to complete a Bulk Load and require 'Grade ID' for employees, I have the Grade Name and Grade Code but not the Grade ID associated, how can i extract thi…Jacob Good 123 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 326 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll Reporting name in OTBISummary Payroll Reporting name in OTBIContent Hi All, I can see a field "Reporting Name" in PAY_ALL_PAYROLLS_F table, I can able to pull this in BIP but not able to see …Prabhu Krishnamoorthy 50 views 4 comments 0 points Most recent by Anubha B Reporting and Analytics for HCM -
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 80 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay https://us.v-cdn.net/60…AjayKumar Maddipati 27 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an…
-
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 24 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to pull employees and contingents on a OTBI report along with seniority datesSummary: Hello, I am trying to pull both employees and contingents on a OTBI report along with seniority dates. I am noticing that since contingent workforce donot have …Nikhila 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Perfermance Status Chart (SPI AND CPI)Summary: In which type of Analysis the said graph could be made. Thank you for your prompt attention to this matter.Looking Forward for your reply. Version (include the …
-
Assignment Status in BI ReportSummary Assignment Status in BI ReportContent Hi, I want to find out table field in BI Report which hold value Assignment Status = "Active Payroll Eligible" or "Inactive…User_2025-02-07-19-03-14-525 238 views 12 comments 1 point Most recent by Aurobindo Ghosh Reporting and Analytics for HCM -
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 58 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
Learning Items for Pending WorkersSummary: Unable to pull Pending Worker information from Learning Records Real Time DM and Assingment Real Time DM Content (please ensure you mask any confidential inform…
-
Specialization Completion PercentageSummary: I am looking to build an OTBI report that lists by associate an enrolled learning specialization and a summary count of the number of the courses in the special…Kristen Arner 61 views 5 comments 0 points Most recent by PEEMA O-CHA Reporting and Analytics for HCM -
OTBI > Permissions > HR Specialist cannot open DashboardContent Hello All, I will appreciate your support on the issue below: The HR Specialist with Data Role “AUIB Human Resource Specialist” cannot open the Dashboard (File “…
-
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
What is the Subject Area for News and Announcements (which are displayed on the user home page)?Summary: We have a requirement to show employee announcements in an OTBI dashboard, so we want to know the subject area for the same. Content (required): Subject Area fo…Bhukya Vamsi Naik 45 views 4 comments 0 points Most recent by gguittini Reporting and Analytics for HCM
-
HR is unable to view own record on 1 Report in OTBISummary: Hi Team, Our HR Team has raised a concerned wherein they are unable to access/ view their own data (means the one who's extracting the report) in 1 of our repor…
-
Need help on the Attrition % formulaSummary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…Shreya Datir 67 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…