Reports
Discussion List
-
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 -
make etext template Tab delimitedSummary I need to make a report tab delimited, however I cannot seem to accomplish with etext template.Content I found this, but can't seem to apply it. I guess I am not…Mike Borghoff 285 views 6 comments 0 points Most recent by Mike Borghoff 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 71 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.… -
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… -
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 46 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…Giorgio Innocenti-81771 88 views 2 comments 0 points Most recent by Giorgio Innocenti-81771 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…Burakcan Sencan 193 views 3 comments 2 points Most recent by Burakcan Sencan Reporting and Analytics for HCM
-
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around…Mansur Khalil 60 views 2 comments 0 points Most recent by Srini Devara-130896 Reporting and Analytics for HCM -
Arrange Order and Delete Fields in Data ModelContent I'm dragging and dropping to change the field order in the data model but when I go to run the export, the fields are in the exact same order. I have saved it an…Bhuangtran 33 views 3 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 194 views 3 comments 2 points Most recent by Kamrul Alom Reporting and Analytics for HCM -
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo…
-
Tables to track employee activity to HCMContent Hi All, Can anyone tell us if there is a report,tables...or fields that we can use to create a report...to track if an employee has: 1) Attempted to login to HCM…Praveen Kumar-146357 79 views 3 comments 0 points Most recent by Sasank Reporting and Analytics for HCM
-
Page Composer Changes and OTBI Subject Area ImpactContent Will a change done by Page Composer, like Field Label change, get reflected on OTBI Subject Areas? For example if I change Person number to Employee ID on a page…Vibha Pandey - Oracle 40 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Exclude logged in user from indirect reportsSummary Exclude logged in user from indirect reportsContent Hi, I have a Direct and Indirect selector prompts for managers to use which displays direct and indirect empl…Barry Stamp-73691 49 views 9 comments 0 points Most recent by Barry Stamp-73691 Reporting and Analytics for HCM -
Need Logic/Query to get base element_type_idSummary Need Logic/Query to get base element_type_idContent Hi Team, Need logic to get the Base element_type_id from Earnings results element. Ex: Currently i have Regul…Chaitanya Jogi 155 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 242 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
OTBI Reports - Access to ResultsSummary OTBI Reports - Access to ResultsContent Hi we have created a HR Admin where they should be able to see all employee results. But this user only has access to his…Mansur Khalil 57 views 2 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM
-
Goal Weight for Mass Assigned Goal - OTBI ReportingContent We've developed a performance goal tracking report with basic information regarding an associate's goals. When pulling in the weight of the performance goal, we …User_QKT1Q 46 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Payroll balance value using PAY_RUN_BALANCESContent Hi All, We have a custom payroll balance (XX_MISC_BAL) and added dimension as "Assignment Tax Unit Year to Date" and "Relationship NoCB Year to Date" as on 01-Ja…
-
Not able to restrict edit rights to analysis in specific folderContent We provided employees with the 'Human Resource Analyst' in order for them to be able to create reports. This is what we want, however with this new role they are…Marianne Kromwijk 42 views 2 comments 0 points Most recent by Timothy Orrange Reporting and Analytics for HCM
-
Display on a radar graph 2 times the same gradeSummary Display same grade on the radar graphContent Dears, In the absence of the radar graph for the competencies , I am developing on BI a "home made" version. In some…Jean-Francois Prevost 48 views 1 comment 3 points Most recent by Jean-Francois Prevost Reporting and Analytics for HCM