Reports
Discussion List
-
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 463 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 56 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 156 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 230 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 245 views 8 comments 2 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM
-
How to limitate only one report based on rolesSummary We want to put upcoming birthdays to opening page but everyone should see all employee's dataContent Hi All, Normally, when we create report and put it to the da…User_2025-02-04-18-26-11-309 33 views 2 comments 4 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
HCM Location for Manager Self-Service ReportsSummary Where are other companies, placing self-service reports in HCMContent The manager experience we are designing for HCM is to provide infolets as the primary chann…User_2025-02-04-10-47-55-876 51 views 6 comments 3 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
Managers on a Leave of AbsenceSummary Managers on a Leave of Absence reportContent Hello, I am trying to create a report that will show managers, the managers Assignment Status (to be used to determi…Shanna Oppenheim 51 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report Jobs Not Saving Notification PreferencesSummary The scheduled BI Publisher report jobs are not sending notifications. The notifcations are used to confirm report completion or failure.Content Hi, We will be us…
-
Do we have any list of UK legislative reports provided by the fusion Payroll especially the statutorSummary Do we have any list of UK legislative reports provided by the fusion Payroll especially the statutory onesContent Do we have any list of UK legislative reports p…Abhishek Sood HCM 21 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
BIP SQL Query to get absences hours and paid hoursSummary BIP SQL Query to get absences hours and paid hoursContent Hi All, Can someone guide me with the sql query to get the absence hours and paid hours of an employee …SuryaMuralidharan 79 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
BIP SQL Query for Previous Assignment Information, Updated Assignment Information, Previous Person ISummary BIP SQL Query for Previous Assignment Information Updated Assignment Information Previous Person Information Updated Person Information Previous Bank Information…User_2025-02-01-06-07-07-886 544 views 4 comments 0 points Most recent by User_2025-02-01-06-07-07-886 Reporting and Analytics for HCM
-
BI Catalog ShortcutsSummary How to create shortcuts for reportsContent I have a report that I want to create a shortcut of so that another user can run it out of a different folder because …Gregg Vadasz 74 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Determining # of direct reports at time of terminationSummary How can we determine how many direct reports someone had as of their term date?Content We have received a request to pull together a report of terminations over …Cheryl Burwell 33 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
List of employees that are LINE MANAGERSSummary List of employees that are LINE MANAGERSContent Employee Details that are Line Managers Hello Community, Could anyone share a sample report which will list down …Prosenjit Manna 70 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Is it possible to create OTBI analysis that should reports person numbers for alternate Managers andSummary We are trying to create an OTBI analysis that should reports person number for alternate Managers and Line managers both.Content Requirement- Need to create an O…User_F89L9 78 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
19B Release causing report issuesSummary OTBI Report with Location GL field is breakingContent 19B released over the weekend. Noticed that reports that have Location GL field are causing ODBC error now.…User_2025-01-28-20-43-56-568 56 views 5 comments 1 point Most recent by Linda Dunn Reporting and Analytics for HCM
-
Learning Analysis Need Column for Last Job ChangeSummary Find the date the colleagues Job Title ChangedContent How do I add a field to an analysis for Learning Module that will show the correct date the colleague's Job…Dena Swanson 38 views 2 comments 0 points Most recent by Dena Swanson Reporting and Analytics for HCM -
History of benefit element entry electionsContent Is there a way to report the history of a benefit element assigned to employees and the rate value (communicated rate value)? I am trying to find out what the em…Annette M 53 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
SQL query fetching Duplicate rows for terminated employees with pending worker recordsSummary SQL query fetching Duplicate rows for terminated employees with pending worker recordsContent I created a SQL BI Publisher report to fetch all active employees a…User_2025-01-30-21-52-52-008 260 views 18 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
PDF/A output is not working as expected in BI Publisher reportSummary How to set PDF/A output for a BI Publisher report in HCMContent Hi All, I want to set output type of a BI Publisher report as PDF/A as my intention is not to let…SuryaMuralidharan 56 views 1 comment 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher?Raja Mohan Ivaturi 60 views 5 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM -
Detail Compensation Bonus StatementSummary Need report detailing components of an associate's bonus payoutContent We are looking for a detail Compensation Bonus Statement report that can help us see at th…Paola Rodrigo 61 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI reports for Individual CompensationSummary Are we planning to launch any OTBI reports for Individual Compensation? If yes, do we have an ETA?Content We have quite a subject area for Workforce Compensation…Aparna Damle 114 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Multiple Worksite ReportingSummary I need a report that has the headcount for each work location over the last quarter and the gross wagesContent Hi, In our previous system, we have a report calle…Kevin Orze-43433 82 views 1 comment 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM
-
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 86 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Assigment History - Old Value and New ValueSummary How can we get old value and new value for Assignment History?Content Hi All, Is there any way to get old value and new value for worker's assignment changes? We…User_2025-02-04-18-26-11-309 222 views 3 comments 2 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM