Reports
Discussion List
-
OTBI Report Limited to Excel SheetSummary How do I report on person numbers from an Excel SheetContent Hi all - I have a list of 2K+ Person Numbers in an Excel Sheet. I need additional data about these e… -
BIP Report with OTBI PromptsSummary How do I create a dashboard that uses OTBI prompts for a BIP reportContent Hi all - we are experiencing an issue since our Rel12 upgrade, where the parameters fo…Prudence K 229 views 4 comments 0 points Most recent by User_2025-01-31-00-03-33-089 Reporting and Analytics for HCM -
MAX formula with CONCAT calculated measureSummary Difficulty getting the formula to workContent The way our Talent Review Meeting's were created we were forced to use flexfields to store the data. So to include …User_2025-01-28-08-47-04-905 56 views 12 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM -
UNION promptsSummary Want to add to a report that is built on UNION a AsOfDateContent We have a report built on a UNION. We want to add the option to enter a prompted As of date and …User_2025-01-30-04-37-05-780 107 views 3 comments 0 points Most recent by User_2025-01-30-04-37-05-780 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 -
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 61 views 8 comments 0 points Most recent by Julian Challenger-Oracle 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 204 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM -
Cloud HCM cannot enable writeback,,,Summary Unable to understand how to write back dataContent Hi All, I am attempting to write back to a dff that i created but have been unsuccessful so far. In OTBI the o…Nicolas Trojack-24006 28 views 8 comments 1 point Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
Salary basis for future hireSummary Using the Compensation - Salary details real time don't see salary basis for future hireContent We need to get the salary basis for new hires, rehires, etc. For …User_2025-01-30-04-37-05-780 75 views 4 comments 0 points Most recent by Gail Langendorf-Oracle 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 -
Future Dated Salary ReportSummary Ability to run a future dated salary change reportContent Does anyone know if it's possible to run a future dated salary report? We want to bulk load salary data…User_2025-01-22-19-19-56-324 92 views 6 comments 0 points Most recent by Gail Langendorf-Oracle 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 477 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 102 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Duplicate Rows; Multiple lines of dataSummary My report is spitting out multiple lines of the same data; trying to find a way to consolidateContent I'm building a report that will serve as a validation/audit…User_2025-01-28-20-40-07-753 160 views 8 comments 0 points Most recent by User_2025-01-28-20-40-07-753 Reporting and Analytics for HCM -
HCM Extract Bursting PrioritySummary How to set bursting priority in BI Bursting or HCM extract delivery optionContent One of our integration partner requires trigger file (empty file with same file…User_2025-01-25-03-22-14-136 68 views 3 comments 0 points Most recent by DIVIAMARENDRA1201 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 775 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Absence Accrual Plans for EmployeesSummary Need query table/analysisContent One of our states where our employees are located has ruled to provide hourly employees with sick pay of 40 hours per year after…Frank Wheatley 157 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Active Employees in a QuarterSummary How can I find Active Employees in a particular Quarter.Content Hi, Current I am using Assignment event real time subject area. I can pass 2 dates one start date…Jaydeep Puranik-24545 83 views 4 comments 0 points Most recent by Jaydeep Puranik-24545 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 -
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 -
EEO-1 Report - R13Summary DUNS Number does not fit in field on reportContent Hello Community, The DUNS number on the delivered EEO-1 audit report in R13 does not fit and is cut off. In R1…Susan Anderson 85 views 5 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
Payroll Activity ReportSummary Page breaks in Payroll Activity ReportContent Hello, It would be really nice if the payroll activity report could page break between person. I think it would mak…Susan Anderson 158 views 3 comments 1 point Most recent by Richard Marko-47911 Reporting and Analytics for HCM