Reports
Discussion List
-
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 63 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 205 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 93 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 428 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 144 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 69 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 685 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 147 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 85 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 66 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 69 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 86 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 159 views 3 comments 1 point Most recent by Richard Marko-47911 Reporting and Analytics for HCM
-
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
-
Creating a Filter Based on Staff with Multiple Rows of Data in AnalysisSummary Creating a filter that will only produce records when an employee has more than one row on the reportContent Hi- I'm working on building a report to focus specif…Bernadette L 56 views 2 comments 0 points Most recent by Bernadette L Reporting and Analytics for HCM -
User Audit RolesSummary Can we report on roles removed?Content Hi all - I have seen multiple postings about how to report on what a user has for roles, but those are current roles. Is i…Prudence K 129 views 5 comments 0 points Most recent by Dr Surlina Yin-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 66 views 3 comments 0 points Most recent by Atish Chandra Supakar 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 41 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 Reporting and Analytics for HCM
-
Creating a drill down report from a pie chartSummary Want to have ability to click on a pie slice and have it open to details.Content I have created a Goals Status report. I would like to have the ability for someo…User_2025-01-28-20-43-56-568 47 views 6 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM
-
Show those with No Goals in a Goal ReportSummary Creating a report which shows those with no goals in a particular goal planContent I'm looking to create a report that shows a count of goals for users along wit…User_2025-01-22-19-54-00-543 90 views 4 comments 0 points Most recent by User_2025-01-22-19-54-00-543 Reporting and Analytics for HCM
-
Element Data History reportContent I am having issues getting a history report of the element data to work correctly. I am trying to pull in the data in a date range, and present the element data …User_2025-01-30-00-38-09-143 176 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle 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 81 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 119 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…User_2025-01-23-21-24-21-434 147 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM