Global HR
Discussion List
-
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 112 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav…Kimberly Nguyen 68 views 7 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 206 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM -
Unreadable content when reporting on GoalsSummary Excel generated error when using Export to ExcelContent Hi, when I'm reporting off the 'Workforce Goals - Goal Status overview real time' subject area, the analy…Alex Andreadis-70445 49 views 5 comments 1 point Most recent by Alex Andreadis-70445 Reporting and Analytics for HCM -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 453 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…User_2025-01-23-23-50-04-709 103 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…User_2025-01-23-21-24-21-434 717 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
How to Obtain "People Group" Field through BI PublisherSummary How to obtain "People Group" field through BI PublisherContent Hello All, I am unable to obtain "People Group" and "Legal Employer Name" fields through querying …Aahiri_Sarma 65 views 7 comments 0 points Most recent by Aahiri_Sarma Reporting and Analytics for HCM -
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man…Dudi Levi 97 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…User_2025-01-29-01-27-20-754 67 views 3 comments 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 30 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Error on InfoletsSummary I've created two simple infolets for employees to see HC and FTEContent I've created two simple infolets for employees to see HC and FTE - but when then go to th…User_2025-01-29-19-59-40-005 67 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Possiblity of creating a Report which has a combination of data column from two different source oneSummary Possiblity of creating a Report which has a combination of data column from two different source one SQL and other static data (say excel Spreadhseet, XML, CSV..…AshishERPCloud 65 views 3 comments 0 points Most recent by Atish Chandra Supakar Reporting and Analytics for HCM -
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…User_2025-01-30-03-54-32-528 65 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way…User_2025-01-22-19-43-38-766 43 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 Reporting and Analytics for HCM
-
What job role gives access to Human Capital Management – Approval Notification Archival Real Time suSummary What job role gives access to Human Capital Management – Approval Notification Archival Real Time subject area ?Content What job role gives access to Human Capit…Ruzwan Akram 80 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…User_2025-01-28-05-39-23-766 117 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Table Name for Scheduled ProcessesSummary Am looking for the Database TABLE name for querying all scheduled/processes with their PROCESS_IDContent Hi, Am looking for the Database TABLE name for querying …User_2025-01-30-03-39-56-442 1.5K views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 324 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM -
Table for getting the Scheduled HCM Extracts listSummary Need table names for getting the scheduled payroll flows listContent Hi All, I have a requirement to generate BIP report with all the scheduled payroll flows and…Sricharan Monigari 67 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Max Custom BIP Reports that can be run as a scheduled jobContent Hi, My customer has a custom BI Report. It is similar to a Compensation Statement. Each report run has 2 pages per worker as output, in PDF. If a Line Manager wi…User_2025-01-30-03-39-56-442 25 views 4 comments 0 points Most recent by User_2025-01-30-03-39-56-442 Reporting and Analytics for HCM
-
OTBI Report giving No result from same subject areaSummary OTBI Report giving No result from same subject areaContent Hi Team, I am using ‘Workforce-Assignment Real time’ subject area. Our requirement like Division with …User_2025-01-30-05-05-05-573 59 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Department Hierarchy Report giving No ResultsSummary OTBI Department Hierarchy Report giving No ResultsContent Hi Team, I am trying to run a OTBI report for Department/Organisation Hirarchy in my Client instance, h…User_2025-01-30-05-05-05-573 115 views 4 comments 0 points Most recent by User_2025-01-30-05-05-05-573 Reporting and Analytics for HCM
-
Year End BalancingSummary Looking for Report IdeasContent I am looking for good reporting ideas to balance YTD amounts with my Tax Provider. I would like to start balancing this numbers o…User_2025-01-30-03-55-50-271 58 views 0 comments 0 points Most recent by User_2025-01-30-03-55-50-271 Reporting and Analytics for HCM
-
Reporting on a Additional Job FieldContent Morning All, If you see the document I have uploaded it will make more sense with Images. Wonder if you could help me to get the bottom of a reporting issue with…User_2025-01-28-18-35-09-769 33 views 4 comments 0 points Most recent by User_2025-01-28-18-35-09-769 Reporting and Analytics for HCM
-
Seeking BIP report for Worker, Potential Life event and Processed Life EventSummary Seeking BIP report for Worker, Potential Life event and Processed Life EventContent I need a list of workers and their event information - Potential and Processe…User_2025-01-23-21-24-21-434 94 views 8 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Learning Evaluations Report in OTBISummary Cannot Report Learning Evaluations DataContent I am trying to create an OTBI report that contains data from the Learning Evaluations folder in Workforce Learning…User_2025-01-28-17-24-53-863 196 views 3 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 101 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM