Reports
Discussion List
-
TalentProfile ReportSummary Path for editable version of the TalentProfile ReportContent Hi All, Does anyone know what is the path for the editable version of the Talent Profile Report ? th… -
Wrap Text in OTBI ReportsContent Hi All I unchecked wrap text checkbox in Table content properties to wrap all the columns in the report. In the view it shows the columns are wrapped. However, w…Ridma Karunanathan 130 views 5 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Need the logic to convert English to Chinese language in SQLSummary Need the logic to convert English to Chinese language in SQLContent Hi Team, I have a BI(SQL) report and some of the fields like 'Legal Entity, BU, some EIT fiel…User_2025-02-01-03-43-13-079 97 views 4 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
View Headcount by Selected LeaderContent Hello everyone, I created a dashboard for HR business partners covering basic worker and person assignment information e.g. headcount, gender breakout. I would l…User_2025-02-11-03-07-51-707 41 views 4 comments 1 point Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM
-
Detailed report for pie charts does not work with dashboard promptsContent We are building a dashboard for Talent Profiles and have successfully built a chart that accurately pulls data from Talent Profiles. The chart works well with th…User_2025-02-10-08-27-16-805 36 views 2 comments 2 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
adding recruiter's assignment name from work assignment real timeContent How can i pull the recruiter 's title (recruiter full name- hiring team) from their core hr record. anytime I join recruiting real time to workforce assignment r…Riti Malhotra 12 views 2 comments 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
Table in Data Source: AuditViewDB where it contains the names and employee number of employees.Summary I'm currently using the Data Source: AuditViewDB for some audit purpose. I need the table from that data source that contains the names and employee number of em…Mark kristan De los Reyes 39 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
BIP report to have attachmentSummary Attachments in BIPContent Hi Team, We are trying to download CV in Bulk from Oracle Recruiting Cloud. I was able to bring in the URL from UCM for the attachment …Varun Kumar Kota 68 views 3 comments 1 point Most recent by Hariharan Sekaran Reporting and Analytics for HCM
-
can we group the output using any templateSummary my report is displaying 300 rows but user needs to display the output in grouping ,example each 100 rows as one group ,is it possible to using templateContent Hi…User_VR8E0 20 views 1 comment 1 point Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM
-
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 471 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
OTBI vs BIP filtering clarificationSummary HOw OTBI handles filtering verse BIPContent Hi, Seeking clarification/advice on the following scenario. We have an OTBI report that pulls in a person's work exte…Denise Izzi 30 views 12 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Dashboards graph PropertiesContent Hello! I added some pie charts in a Dashboard but they are displaying misaligned even if they have the same graph properties. In attachment a screen showing the …Chiara Arcidiacono 31 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read tContent Hi Experts, I have Anniversary BI Report using OTBI analysis. Which has following filter criteria CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Re…User_2025-02-07-19-03-14-525 32 views 1 comment 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Custom Columns with field from different Subject AreasContent Hello, I am working on a report that has 2 subject areas (SA). I am trying to include a column with a formula (CASE WHEN statement) using fields from the 2 subje…User_2025-02-05-06-26-19-951 57 views 5 comments 1 point Most recent by user5070067 Reporting and Analytics for HCM
-
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in…
-
Analysis failing with error: Exceeded configured maximum number of allowed output prompts, sections,Content Hello Experts, I had built a dashboard using the Absence Calendar Details Real Time subject area having two sections - Summary and Detail Analysis reports. I had…Akash Kiran Jana 29 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Proper Case Function in OTBIContent Is there a function in OTBI that transforms character strings from their current state into PROPER case format? For example: 'JOHN SMITH' or 'John SMITH' to 'Joh…Dustin Dominic 41 views 2 comments 2 points Most recent by Dustin Dominic Reporting and Analytics for HCM -
Dynamic printing of column labels in OTBI or BI PublisherSummary Dynamic printing of column labels in OTBI or BI PublisherContent Hi All Kindly share your experiences on how you have been dynamically creating reports with titl…User_2025-02-08-03-05-58-849 18 views 1 comment 2 points Most recent by User_VLBBP Reporting and Analytics for HCM
-
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar…
-
Need to generate audit report for Person and Assignment EFFContent I need to be able to run the 'Generate audit Report' Scheduled Process for changes made to both an Assignment and Person EFF. I have turned it on and managed to …Jasmin S 54 views 18 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for HCM
-
Model Profile - Employee Level - FUSION OTBISummary Model Profile - Employee Level - FUSION OTBIContent Hello We have the attached Model Profile Information report that details all the Role Profiles, as well as th…Andrew Braid 116 views 4 comments 2 points Most recent by Aman Malik Reporting and Analytics for HCM -
Documents of Records data in ReportSummary Need to open DOR (Documents of Records) from BIP reportContent Hi All, We have a requirement to display DOR (Documents of Records) data in BIP report and need to…
-
Query to display the Phases and States of the CSP in OBIContent Hi Experts, I am looking for a OBI query to display the Phases and States which are associated to the CSP. Regards, Harish Version 20DHarishVummidi 68 views 4 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Reporting mulitple Types of Managers in OTBI or BISummary Reporting mulitple Types of Managers in OTBI or BIContent Hello, We have three 'TYPES' of managers defined. I need to create a report for all employees showing a…User_2025-02-04-15-06-22-759 271 views 21 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Annualized Salary is not populating on a OTBI reportContent When running an OTBI report the Annualized Salary value is not populating. The user has AoR's and when they view the salary details via the HR forms the details …Rebecca L Smith 113 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Gauge chartSummary How to set maximum scale limit to a columnContent Hi I'm trying to build a simple gauge chart for infolet to show employee's accumulated learning hours. Each emp…Aslam Khuajah 19 views 4 comments 1 point Most recent by Aslam Khuajah Reporting and Analytics for HCM
-
20D - Employee only see his own records when running reportsContent I'm sure this will be an easy fix for someone, but I have recently been tasked with setting up security access to allow a few of our employees to run reports/ana…User_VYO5Y 352 views 4 comments 1 point Most recent by Karen Waddell Reporting and Analytics for HCM -
Calculation on Pivot table resultsSummary Looking to perform calculation on pivot table results columnsContent Hi there, I'm looking to perform a calculation on a pivot table to insert a new column withi…Gary Miller-39965 35 views 9 comments 1 point Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report …User_2025-01-31-17-16-46-301 86 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Talent Profile - Summary of RoleContent Hi all - I am trying to find the fields to create a report from our Talent Profile section. I am trying to find how to report on the area in Fusion going to Pers…Prudence K 93 views 13 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM