Reports
Discussion List
-
Drill downs in OTBI Direct Database Query reportsSummary Drill downs in OTBI Direct Database Query reportsContent Hi I have created a Direct Database Query report in OTBI which displays the employee counts joined in ea…SuryaMuralidharan 72 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Any way to query a table to capture the IP Address of user logging in?Summary IP Address of user logging in?Content I have been asked if it is possible to provide a report of users logging in to HCM Cloud over the past 30 days and provide …DavidBlake 634 views 3 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Report Returning Duplicate RowsSummary Learn Report on Evaluation Responses is returning duplicate rowsContent Created a report on responses to Learning Evaluations, but it is returning duplicate rows…User_2025-01-28-20-43-56-568 99 views 5 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Annualized TurnoverSummary Does anyone have a report that calculates annualized turnover by month?Content I have a table that calculates Turnover Rate by month but our management team is l…User_2025-01-28-20-43-56-568 152 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL query for Employee and his HR detailsSummary My sql query is not fetching the updated HR detailsContent Hi Team, For some departments we changed the HR Approval on April 1st from on that date our report not…User_2025-02-05-04-17-04-394 643 views 1 comment 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Dashboard Access RoleSummary Need to Set Someone Up With Access to a DashboardContent Need to Set Someone Up With Access to a Dashboard --- I've created a company-wide demographic dashboard …User_2025-01-29-19-59-40-005 122 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Publisher - Prompts that update other promptsSummary Refresh Other Parameters on Change causing parameters to blankContent Hello Experts! I have a data model where we've built 8 parameters and I'm trying to make th… -
“Workforce Management Person Real Time”Summary Sample delivered report that has access to subject areaContent New to BI, but need to start somewhere. I have an end user that thinks he needs access to "Workfor…User_2025-01-31-01-48-51-545 51 views 4 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Employee Hire Date field in "Workforce Management -Person Real Time. Worker" Subject AreaSummary I used "Workforce Management - Person Real Time"."Worker"."Employee Hire Date" field in many OTBI reports. Now we are in 19 B and I can't find that field anywher…Elina Ovetsky 45 views 2 comments 0 points Most recent by Elina Ovetsky Reporting and Analytics for HCM -
How to pass dynamic URL in Action Links in OTBIContent We are trying to navigate to WebPage via action link in an OTBI analysis. The problem is when we will migrate this analysis from one instance to another we have … -
Enabling Custom Dimensions for Out of Box Workforce ReportingSummary Can we enable custom dimensions for out of the box Workforce Reporting Cube(OEP_REP)?Content Is there a method or customization to enable custom dimensions for O… -
Show Every Other Label on a Graph AxisContent I'm sure there's an easy way of doing this that I'm missing. I have a line graph showing our FTE trend over the last 12 months. I don't like the look of the x-ax…Lauren Owen 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Embed Infolets in Third-Party ApplicationsSummary Can Infolets be embedded?Content Is there a way to embed Oracle HCM Infolets in third-party applications? We have a requirement to take specific, actionable info…User_2025-01-31-02-37-17-485 47 views 2 comments 2 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Termination counts on graphs don't match Term detailSummary Created multiple reports for Terminations year over year but noticed the counts don't match that are reflected on the graphs versus what is in the detailed repor…User_2025-01-28-20-43-56-568 30 views 4 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM -
Pull date from prior rowSummary performance task number of days spentContent The start date in this is an excel field I manually created. Essentially, as people move thru the performance review…Mike Borghoff 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Switch grid connection from test to prod in Reporting web studioContent Hi All, Im creating a financial report in the planning test instance using its reporting web studio. However in the test instance no data is available and no val…User_2025-02-01-07-41-50-723 33 views 6 comments 1 point Most recent by User_2025-02-01-07-41-50-723 Planning -
Last Date Employee workedSummary Is there a report that has a date field that returns the last shift that an employee worked? (active employees)User_F1ZIP 27 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Removing Rich Text Formatting from OTBI AnalysisContent Morning all, Can anyone suggest any ways of removing any formatting from text fields in OTBI? I'm trying to export our Goal Descriptions / Success Criteria / Com…User_2025-01-28-05-39-23-766 69 views 3 comments 1 point Most recent by Karen Waddell Reporting and Analytics for HCM -
Pivot report not showing values accuratelySummary BIP Report - Table format is showing amounts correctly. But not working in pivot layoutContent Trying to display past 5 year compensation history. It works fine …User_2025-01-25-04-02-13-126 36 views 1 comment 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
Person contact phone numbers not visibleSummary Results of person contact phone number is blank in reportContent Hello - We had a disaster preparedness report which included emergency contact name and phone nu…User_2025-01-23-23-38-17-063 101 views 10 comments 0 points Most recent by User_2025-01-23-23-38-17-063 Reporting and Analytics for HCM -
What's New in 19.05?Summary Lots of stuff...Content Did you miss me posting this topic last month? I hope you were able to get by without any counseling necessary. As you saw via email, we …Mark Rinaldi-Oracle 189 views 19 comments 7 points Most recent by User_2025-01-27-23-37-42-527 Planning -
Retro Details Report is Getting ErrorSummary Retro Details Report getting oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOE…Balaganapathi Kasineedi 53 views 4 comments 2 points Most recent by Balaganapathi Kasineedi Reporting and Analytics for HCM -
Need Local Information to DisplayContent I am looking for a way to generate a report for my local team in Asia that includes both the English (display name) and the local name in Chinese characters. I c…User_2025-01-28-18-57-50-126 59 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to pull Rate Name in Reporting?Summary How to pull Rate Name in Reporting?Content How do we pull rate names tied to employees benefits in analysis reporting? I have added the Benefits - Enrollments Re… -
Employee not appearing on report; issue appears to be related to Top Manager Name fieldSummary Recreated current report with filter on the impacted employee to identify why she is not showing up on report. When I pull in Top Manager Name field, I get no re…User_2025-01-28-20-43-56-568 65 views 5 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM -
Reporting on inactive managersSummary Identifying employees with inactive managers.Content Can anybody share a report that shows employees along with the status of their line manager? Or tell me how …User_2025-01-28-05-34-59-339 62 views 5 comments 0 points Most recent by Debo Reporting and Analytics for HCM -
Past terminations not appearing in reportsContent We added anyone who has left this year (prior to implementation) as basic records so we could report full year of leavers data and those basic records are not ap…Emily Robinson 46 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need inputs on HCM Absence Seeded Audit ReportsSummary Need inputs on HCM Absence Seeded Audit ReportsContent Hi Experts, We are looking for inputs on Seeded Absence Audit Reports, like what is the purpose of each an…Harish Kumar Kovi 54 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subject Area for Onboarding TaskContent Hi All, Is there a subject area to pull the data from the Me-->Quick Actions-->Onboarding Tasks for the pending workers. I tried using the subject area: Workforc…