Reports
Discussion List
-
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 User_2025-02-04-06-31-44-785 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 -
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…User_2025-02-04-18-22-33-673 79 views 3 comments 0 points Most recent by User_2025-01-28-00-10-14-788 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…User_2025-01-30-03-54-32-528 47 views 9 comments 0 points Most recent by User_2025-01-30-03-54-32-528 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…User_2025-02-04-07-00-18-658 242 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_2025-01-23-23-27-03-729 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 41 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…User_2025-01-30-22-29-59-990 48 views 1 comment 3 points Most recent by User_2025-01-30-22-29-59-990 Reporting and Analytics for HCM
-
Conditional Formatting in a BIP GraphSummary Conditional Formatting in a GraphContent Hi I have the requirement of conditional formatting to graphs in a Report, e.g., if the amount outstanding is less than …Misael Gutiérrez-Oracle 48 views 4 comments 0 points Most recent by Misael Gutiérrez-Oracle Reporting and Analytics for HCM -
How does per_ldap_users table get populated?Summary How does per_ldap_users table get populated?Content Two user accounts were created manually and assigned roles. I see that both of them are available in PER_USER…User_2025-01-25-04-02-13-126 101 views 3 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
SUCCESSION PLAN CANDIDATE READINESSSummary SUCCESSION PLAN CANDIDATE READINESS column detailsContent Hello Everyone, How to find current active record for the succession plan candidate readiness, as per o…VarunG 70 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time to First PromotionContent Hi All, We're trying to measure time to first promotion (or the tenure an employee has on average before they're first promoted). Wondered if anyone has had luck…Lauren Owen 53 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Regarding e-text template used in HCM extractsSummary Regarding transformation on e-text templateContent Hi, We need to transform the date on the text template used in an extract.What we need is to add + 1 day in th…User_2025-01-31-02-27-22-166 48 views 1 comment 0 points Most recent by User_2025-01-31-02-27-22-166 Reporting and Analytics for HCM
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…SuryaMuralidharan 73 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
how to avoid multiple rows in OTBI ReportsSummary how to avoid multiple rows in OTBI ReportsContent Hi Team, we have a requirement to pull "Work E-mail" so i have written case statement with email type code as "…User_2025-02-04-07-00-18-658 111 views 12 comments 0 points Most recent by User_2025-02-04-18-22-33-673 Reporting and Analytics for HCM
-
Report with two different As-Of-Dates to calculate Delta variationsSummary We need to pull two lines for employees, one referring to CURRENT_DATE and the other to the previous monthContent Hi All, we do need to calculate, for Payroll pr…User_2025-01-31-00-30-34-540 28 views 4 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…User_2025-02-04-07-00-18-658 143 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Prompt Filter - Date Format ChangeSummary We can't change filter's Date Format at promptContent Hi All, I added date filter with using Prompt for analysis. In Analysis, I can change date format as I want…User_2025-02-04-18-26-11-309 93 views 12 comments 2 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…Vibha Pandey - Oracle 33 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
Report for users with current rolesSummary Not able to pull all users for above reportContent Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Req…User_2025-01-25-04-02-13-126 49 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit report for user roles in HCMSummary Audit report for user roles in HCMContent Hi When I tried to pull the User roles report form the delivered LDAP report it is displaying roles which are currently…User_2025-02-01-08-16-14-343 208 views 3 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 78 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi …AshishERPCloud 177 views 15 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM