Global HR
Discussion List
-
Query to fetch data model output in hdl formatContent We are trying to automate HDL process using BI publisher report and Extract. Data model query to include output for Worker dat file with two metadata lines (Assi…Kavya Sreenivasulu 731 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM -
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…User_2025-02-06-09-29-18-902 169 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…tiffnyc 65 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…Bala Kasineedi 45 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules …Pedro Teixeira 21 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Need details on right place to get each salary component exact value but not adjustmentSummary Need details on right place to get each salary component exact value but not adjustmentContent In current configuration, monthly salary basis is configured with …
-
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…User_2025-01-23-21-37-42-476 38 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Is it possible to created Facts/Measure in Logical SQLSummary Is it possible to created Facts/Measure in Logical SQLContent Hi all, I need to pivot and show percentage of a column but seems like it is not possible to create…Raymund Jerome 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report error for employeesSummary OTBI Report error for employeesContent Hi Team, I have enabled a HCM infolet to show personal details and is working fine from admin user. but when custom employ…Vinod SM Gowda 52 views 3 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Employees with Leave Status within a Specific MonthSummary Employees with Leave Status within a Specific MonthContent We are tracking leaves through Manage Employment using Action and Assignment Status. Our HRBPs would l…Kathleen Nguyen 23 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table(s) that store Persons Language, Degree, Prior Work Experience, Licenses/Certificate InformatioSummary Looking for the hcm tables that store Person info such as Language, Degrees, Prior Experience, LicensesContent Hi, We want to create data model(s) to pull the Pe… -
Document Delivery Prefrences User Entity DetailsSummary Document Delivery Prefrences User Entity DetailsContent hello Everyone, Do we have user entiry for person document delivery prefrence details. Thanks, Rasu P
-
HCM Quarterly Changes Impact on Reporting and AnalyticsSummary HCM Quarterly Changes Impact on Reporting and AnalyticsContent Hi all, Is there any other references for Quarterly changes on HCM that affects reporting? I have …Raymund Jerome 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Report Job History Page in OTBI IssueSummary Report Job History Page in OTBI Issue is BlankContent Is anyone else experiencing an issue accessing the Report Job History Page? I assume a browser issue, but h… -
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 29 views 2 comments 1 point Most recent by Mike Householder Reporting and Analytics for HCM