Global HR
Discussion List
-
How to add a BI Report to a Fusion PageSummary This document explains how to add a report to an HCM pageContent How to add a BI Report to a Fusion Page This document explains how to add a Salary Range Analyti…Gail Langendorf-Oracle 442 views 4 comments 6 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 92 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA) Can you please advise if possible to notify th…Bernard T 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…Harish Vummidi 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Conditional formatting in Logical SQL OTBI reportSummary Conditional formatting does not reflect in OTBI report where Logical SQL is usedContent We have a requirement where we had to write a logical SQL query to show p…Akash Kiran Jana 64 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Denmark country specific HR reports and analyticsSummary Denmark country specific HR reportsContent Hi, Are there any Denmark specific HR reports available? Denmark is Tier 1 localization and expecting some seeded HR r…Anuradha T 16 views 1 comment 0 points Most recent by Deneen Burrows-Oracle Reporting and Analytics for HCM -
Rating ChangesSummary Rating ChangesContent Hi, I have created analysis, we have date parameter based on the passed date it will show the rating changes , But we need to add another c…Reddykrishna 30 views 5 comments 0 points Most recent by Reddykrishna Reporting and Analytics for HCM -
LSQL Newbie questionSummary Trying to learn to write LSQL. Need assistance with the errorContent Hello all, I just started learning to write LSQLs. After going thro the training materials, …User_2025-02-04-15-06-22-759 43 views 2 comments 1 point Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM -
Bar graph drill down filtered on dateSummary Bar graph drill down filtered on dateContent I have built a bar graph that captures disclaimer status by action date. The drill down takes to a different OTBI re…User_2025-02-10-08-27-16-805 28 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Extract Content Id for the attachment from Document of RecordsSummary Extract Content Id for the attachment from Document of RecordsContent As per the Oracle document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=…Sowdha Murugan 50 views 3 comments 0 points Most recent by AvishekNandi Reporting and Analytics for HCM -
How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DaSummary How to move OTBI Report options (Export/Print/Refresh ) from Middle to either left or right on a DashboardContent Hi Team, I want to move OTBI Report options (Ex…Mahendra 48 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
A parent for this record wasn't found. Use any of the four supported key-resolution systems to supplSummary While importing a Worker.dat file via HDL i'm getting the error : A parent for this record wasn't found. Use any of the four supported key-resolution systems to …
-
How to calculate tenure in jobSummary How to calculate tenure in job using OTBIContent Gurus— I need to calculate the time in job per employee, for the current job (not previous jobs). I searched the…justin.field-Oracle 294 views 6 comments 3 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Worker Age in Workforce TrendsSummary What to use to calculate age in Workforce TrendsContent Hello! I've been calculating the Age Bands by using a formula to gather the difference between the date o… -
Trying to sort the month prompt on a dashboardSummary The prompt for Month using a Case to convert to month names instead of integer is now sorting alphabetically by month instead of by integerContent Hi I have look…LTalbott2 26 views 2 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Distribution Summary ReportSummary Employee Distribution Summary ReportContent This sample report gives an insight into the different types of Source System Owner along with the total employee rec…AshishERPCloud 47 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get Manager and it's repotee details using OTBI AnalysisSummary How to get Manager and it's repotee details using OTBI AnalysisContent Hi Experts, I have a requirement in OTBI, I want to build a Manager report. It has to fetc…User_2025-02-05-04-17-04-394 64 views 8 comments 0 points Most recent by Mahendra Reporting and Analytics for HCM
-
D&I reporting - what works for your organisation?Summary D&I reporting - what works for your organisation?Content Hello all - over the years I've helped lots of customers with many diversity reports, but the world is m…Caroline Gladwin-Oracle 81 views 2 comments 1 point Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
HCM Last date a vacant post was filledSummary is there a way to report out when a position was last filled which is currently vacantuser1028626 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to have Pivot in BIP based on a Logical SQL Pivot OTBI Report.Summary An OTBI Report is built based on Pivot View and based on the Logical SQL of that OTBI Report , a BIP Report is built but there the Pivoting is not working as Exp…User_2025-02-08-08-08-53-292 93 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Need the AOR Information in OTBI ReportContent We need the AOR Information in OTBI Report. Please let us know if we have this details captured in any Subject area. Thanks Version 20BUser_2025-02-04-17-42-01-535 96 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
YTD Turnover or Rolling 12 Months TurnoverSummary Is it possible to do trends over custom periods of timeContent Hello! I'm using workforce Trends and have been very impressed how it calculates turnover for me a…
-
How to Open XML in OBIEESummary I want to open XML format file in OBIEEContent I have an XML extension file and want to open/export in OBIEE Version OBIEE 12c -
Performance PDF Reports in to Documents of Records?Summary Performance PDF Reports in to Documents of Records?Content Hi Team, We would like to store BI performance PDF Reports in to employee documents of records for eac… -
Report of changes caused by an actionSummary Need a report of attributes that were changed by an action.Content Hello all, I am trying to pull a report of all the fields/attributes that were changed with an…User_2025-02-04-15-06-22-759 74 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Export Geography HierarchySummary How can I export the geography hierarchy?Content Hi, I couldn't find any option to export the full geography hierarchy as we defined in the "manage geography hie…
-
Assignment Changes Old and New ValuesSummary Reporting on Assignment ChangesContent I have a requirement for a report that shows Assignment changes with old and new values. For example, Department old and n…JHaden3 134 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeSummary Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeContent Hello guys, Here is our business problem: Some of our co…User_2025-02-05-11-42-08-011 25 views 2 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Adding Hyperlink to InfoletSummary Want to add a hyperlink to an infoletContent Hi All - I want to leverage my infolet tile as a hyperlink. Have seen it done in the past at a prior company. Does a…
-
Employee change address reportContent Hello, we are looking to create a report that show changes to an employee address for that month, and to see there old address on the report as well. We want to …Vikki Guyan 96 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM