Reports
Discussion List
-
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 -
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 72 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 37 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 91 views 10 comments 0 points Most recent by User_2025-01-23-23-38-17-063 Reporting and Analytics for HCM
-
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 55 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 60 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 48 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… -
Competency Gap Chart Report in 19BSummary How to find the ProfileGapReports-artificats.catalog and ProfileGapReport_PersonCompetency.jsff.xml as stated in the documentationContent Hello everyone ! We are…User_2025-01-24-00-17-10-902 79 views 2 comments 1 point Most recent by User_2025-01-24-00-17-10-902 Reporting and Analytics for HCM
-
Embedding BI Publisher Report on DashboardSummary Embedding BI Publisher Report on DashboardContent Hello, Looking for a better way to display an embedded BI Publisher report in a Dashboard. The views between BI…User_2025-01-28-20-36-10-715 135 views 7 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
Historic data of role assignmentsSummary Historic data of role assignmentsContent Hello Does anyone know if it is possible to return the history of a role being assigned to a user? For example User A ha…
-
My Team Tab - Adding BI Catalog to PageSummary Adding BI Catalog to PageContent Background: We are planning to only use infolets as the primary channel for managers to access "reports" in HCM. We also want ma…User_2025-02-04-10-47-55-876 82 views 5 comments 2 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
Hiding the 'Export' option on custom analysesSummary I am looking for guidance on how to disable to the ability to export an analysisContent Hello, I am hoping for some guidance on the steps I need to take to disab…Bryent Wagner-150293 43 views 4 comments 0 points Most recent by Debo Reporting and Analytics for HCM
-
DISTINCT NOT WORKSSummary DISTINCT NOT WORKSContent Hello everyone, Does anyone have any idea why my query does not work? I'm using DISTINCT but I get repeated rows. Also, we have 8500+ e…User_2025-01-25-01-17-59-580 53 views 9 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Failed notification messages on providing a wrong email addressContent Hi All, We are developing one BIP report where we have utilized the bursting option to send an email to employees based on certain changes. Currently, we are sen…Amrit 32 views 1 comment 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM
-
Need BI SQL to fetch previous row assignment and salary details of employeesSummary I need to fetch previous row details based on latest row effective end dateContent In My BI Report, if i passed effective end date as a parameter , then employee…User_6U8NQ 263 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Merged ColumnsSummary How to prevent merged columns in reports?Content Hi Everyone, I noticed that some of our reports come out with merged columns, which always throw off our sorting…User_2025-01-29-23-59-58-976 61 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM
-
CASE Statement Future Termination DatesSummary Trying to show future termination dates as blank in active reportContent I have an all ee report. One of the fields is termination date. if someone has a future …Mike Borghoff 51 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Publisher Export LimitContent We recently created a BI Publisher report based on a Data Model. The Data Model was created based on a BI Analysis. When trying to schedule the report with an ou…User_2025-01-23-23-27-03-729 439 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sub Folder for Requisition field in Workforce ModellingContent Hi Guys, I'm creating a proof of concept for the reporting that can be done out of the workforce modelling area and can't seem to locate the field 'Requisition'.…Ivy__Valverde 36 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Nesting Case statements?Summary Is it possible to nest Case statements in otbi?Content I am working on a recurring report that requires me to classify people based on certain characteristics. I…Cheryl Burwell 50 views 3 comments 0 points Most recent by User_2025-02-04-18-47-48-634 Reporting and Analytics for HCM -
Manager Self Service MetricsSummary Manager Self Service MetricsContent I would like a report that displays metrics on how often managers are initiating employee data changes in Oracle. Also, I wou… -
Active User Name Flag (Terminated Employee or Active Employee)Summary Does OTBI provide an Activated User Flag?Content We have a requirement to provide an audit report in HCM that shows any active HCM user accounts for terminated e…User_2025-01-28-08-17-22-037 158 views 2 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
Can we report on Workflow TransactionsContent Hi All, I am trying to see if we can report on Workflow Transactions. I am able to query fa_fusion_soainfra.WFTASK table which seems to have workflow data in HCM…Vibha Pandey - Oracle 229 views 9 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Query to get Report run History in Fusion HCMSummary Query to get Report run History in Fusion HCMContent Hi All, Is there any possibility to get the details of a report's run History in Fusion HCM? I want to know …SuryaMuralidharan 197 views 8 comments 2 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM