Global HR
Discussion List
-
Employee/Manager Self-ServiceSummary How to report on effectiveness of ESS/MSSContent Hi all - checking in to see if any of you currently have a report that reports on the effectiveness of employee …Prudence K 147 views 9 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Help Building HCM Group Membership ReportSummary I need to build a report that pulls all employees HCM Group membershipContent It doesn't seem that there is an easy way to find out what HCM Groups an employee i…David Rabalais 120 views 1 comment 2 points Most recent by David Rabalais Reporting and Analytics for HCM -
BIP | SQL query to get details of the employees belonging to departments below the selected departmContent Requirement: 1) Report should display employees belonging to the departments of the selected organization type. 2) Report should also display employees belonging… -
Reporting on the positions colleagues are working in (factoring in secondments)Content Im looking to report through OTBI on where colleagues are currently working, factoring in secondments. For example I only want 1 row to appear for each colleague…MattW 35 views 9 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
List of Report for Onboarding ChecklistContent Hi All, Can anyone share a post of link in which we can get List of Report for Onboarding Checklist. Any kind of reports will help. Thanks & Regards, Kiran Versi…Kiran Kancherla 101 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Recruiting - Recruiting Real Time - Ability to Report on Position Details?Summary Currently you cannot report on all position attributes in ORC like FTE, having difficulty with joining subject areas.Content We are trying to report on FTE for O… -
migrate data model from test instance to productionContent Dear Members, I have accidentally deleted a data model of a report from production instance. Thankfully, our Test instance still has that data model as is and un…Megha Patel 34 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas…Dhanuka Chamal 3K views 6 comments 2 points Most recent by Dhanuka Chamal Reporting and Analytics for HCM -
Organization Chart Custom ReportContent Hi All, I customized the DirectoryPrintReport report in /xmlpserver. I have kept only Custom as Default and Active. But the system is still printing the delivere…Mohit-Sinha 41 views 2 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Password Protect xls output in Cloud HCMContent Hi Team, We have a requirement where we need to password protect the xls output produced in Fusion HCM. Can you please let me know on how to achieve this? Thanks…MandeepGupta 35 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Error while building a report using AnalysisSummary Error while building a report using AnalysisContent Team, when I am trying to build a report using work relationship real time subject area (any any subject area…Santosh Mudide 37 views 4 comments 1 point Most recent by Santosh Mudide Reporting and Analytics for HCM -
Calculating Difference from Headcount factContent I am trying to calculate difference between Headcount (Fact from Assignment Real Time) by work location and the number of employees that uploaded a document type…Riti Malhotra 38 views 5 comments 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
OTBI Analysis with EIT fieldsSummary Need to display current Parent Position Code for the record but EIT causing duplicationContent HI all, I need some help with an Analysis - I have paired the anal…User_2025-02-04-08-51-08-912 150 views 4 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp…
-
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a…Mike Householder 30 views 2 comments 1 point Most recent by Mike Householder Reporting and Analytics for HCM -
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti… -
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…User_2025-02-04-08-51-08-912 56 views 1 comment 1 point Most recent by Srdjan Ostojic Reporting and Analytics for HCM
-
Infolet Visibility IssueSummary Can we use Assignment's Descriptive field value in Infolet EL expressionContent Hi, We need to set the Infolet Visibility based on Assignment's Descriptive field…
-
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…Bala Kasineedi 526 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Delegated Roles TableSummary Delegated Roles TableContent Hi All, Is there any other table which stores delegated roles details? I am able to find the table PER_DELEGATED_ROLES but this repo…nitin Sharma 12 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…Balaganapathi Kasineedi 67 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …Mayi218-Oracle 74 views 1 comment 2 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with…Andrew_Schmitz 45 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
General Preferences OTBI Subject AreaContent Hello All. I am trying to include Language from General Preferences in an OTBI report, but I am not able to figure out which subject area general preferences are…Antoine Richard 47 views 2 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report to fetch Open Notifications for the employeeSummary Report to fetch Open Notifications for the employeeContent Hi Guys, I have a requirement to send all the open notifications as a summary via email every week to …Vinod SM Gowda 46 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Nationality Head Count AnalysisSummary Nationality Head Count AnalysisContent Hi All, May I know if anybody has done head count analysis based on Nationality . Could you please guide me. If I take fro…User_2025-02-06-09-41-56-955 35 views 4 comments 0 points Most recent by User_2025-02-06-09-41-56-955 Reporting and Analytics for HCM
-
Oracle Employee auditing that captures changes to a persons recordContent We currently have been looking at the history tab within person management and have realized that it does not give us much information. After connecting with Ora…User_2025-02-05-16-39-03-485 24 views 1 comment 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a …User_2025-01-28-08-47-04-905 411 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI layout performance tile how can i make the square border thicker?Summary OTBI layout performance tile how can i make the square border thicker?Content Hello We have an OTBI with layout of a sum displayed in a ‘performance tile ‘. The …Revital Mefano 35 views 4 comments 1 point Most recent by Revital Mefano Reporting and Analytics for HCM -
OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics, 23 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics session to have them answered during the live event. Post you…mauricio -Oracle 33 views 0 comments 1 point Most recent by mauricio -Oracle Reporting and Analytics for HCM