Global HR
Discussion List
-
Using Headcount Values in Reports and DashboardsContent I am trying to use headcount values in reports and dashboards, but the values are not lining up correctly. I know how to load the assignment work measure via HDL…Shannon Lackmeyer 38 views 2 comments 3 points Most recent by Shannon Lackmeyer Reporting and Analytics for HCM -
Require a report to show when a Primary Mailing Address is missing in the systemSummary It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing…User_2025-02-04-08-51-08-912 1.1K views 6 comments 3 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM -
Displaying Dashboard to Welcome ScreenContent Hello All, We have been able to successfully add the Dashboard to the Welcome screen in a Sandbox with Page Composer. What we are running into now is any user no… -
OTBI Reporting Leave Begin DateSummary Displaying actual Leave Date or the date when the employee returned to workContent Hi All, Need some help with an Analysis that I have built to show employees th…User_2025-02-04-08-51-08-912 42 views 4 comments 0 points Most recent by User_2025-02-10-19-46-17-403 Reporting and Analytics for HCM
-
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 39 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM -
Tile in Fusion for Managers to directly take them to their Manager ReportsContent We are trying to figure out if it is possible to create a tile in Fusion for anyone with a Manager role to have a tile to take them to our Manager Reports folder…User_2025-02-05-16-39-03-485 35 views 4 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Bank Account UpdatesContent I was wondering if anyone had a report that was able to pick up changes to bank account information? We currently have a report that pulls the last update date o…User_2025-01-31-00-25-12-234 131 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Role security not being enforced on dashboard promptContent I am using "Workforce Profiles - Person Profile Real Time" to create a list of employee certifications by manger (direct and indirect). The "Matrix Manager"."Top…User_2025-01-23-21-24-21-434 17 views 4 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 29 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Dashboard prompt defaultContent I have an OTBI dashboard prompt that I want to default to the current logged in user. However, the session (server) DISPLAYNAME value is in a different format an…User_2025-01-23-21-24-21-434 63 views 5 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
Need help in restricting infolet in Legal Employer Transfer PageContent Dear All, I have created an OTBI infolet on Legal Employer Transfer UI in Assignment section. Now this infolet is visible in all the pages where Assignment secti…User_2025-02-06-14-37-05-233 44 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
-
HR Help Desk report availabilitySummary Looking for recommendations and examples of reports for managing HR Help DeskContent Does anyone have any tips or suggestions for creating reports for HR Help De…Len M. 39 views 10 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Error when trying to save an analysis - don't have sufficient privilegesContent Recently we started to receive the following error after editing and analysis and trying to save it. "You do not currently have sufficient privileges to save a r…
-
Ho Do I Call a BI Publisher Report from a Tile on the SpringboardSummary Ho Do I Call a BI Publisher Report from a Tile on the SpringboardContent Hello, We would like to call a BI Publisher report from a tile on the springboard. Does …Daniel McMillian 37 views 8 comments 1 point Most recent by Daniel McMillian Reporting and Analytics for HCM
-
Multiple rows converted to columns grouped by employeeSummary Would like to display multiple phone types by column instead of having separate rows for each oneContent Hi - I am creating a report that shows specific phone ty…
-
Salary & Assignment Changes JoinedSummary Report that pulls Salary and Assignment Changes Joined TogetherContent Hi all, Has anyone created a report that pulls both Salary and Assignment Changes joined t…User_2025-01-31-00-25-12-234 102 views 5 comments 2 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Is it possible to have a WITH clause in OBIEE Logical SQL?Summary Is it possible to have a WITH clause in OBIEE Logical SQL?Content Hi all! Is it possible to have a WITH (subquery) clause in OBIEE Logical SQL? I have to exclude…
-
When applying case statement with group by and aggregate function it is showing error.Summary When applying case statement with group by and aggregate function it is showing error(No fact table exists).I am using 2 subject areas and included fact columns …
-
How to convert numbering format from Indian currency to Dutch (10.13 t0 10,13) to OTBI Report.Summary How to convert numbering format from Indian currency to Dutch (Amount 10.13 to 10,13) to OTBI Report.Content Hi All, We have a requirement to convert amount/curr…User_2025-02-10-16-28-01-402 39 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
Is it possible to create a BI report to search for a string in all the log files for the parent scheContent We submitted a Synchronize Person Assignments from Position and it internally spawned 25 processes. Instead of looking into the individual log files, we wanted t…User_2025-01-22-19-57-39-723 28 views 2 comments 0 points Most recent by User_2025-01-22-19-57-39-723 Reporting and Analytics for HCM
-
How to ensure consistent output of default Date format in OTBISummary Default Date format is different for 2 different users who have same Regional PreferencesVersion Oracle Cloud Application 21B (11.13.21.04.0)User_UM4C6 24 views 1 comment 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
Checklist item and report on there StatusSummary Need a report for onboarding checklist (DoR) which the acknowledgementContent Team, We have onboarding checklist items and using BI publisher for some of them to…Santosh Mudide 54 views 4 comments 0 points Most recent by Santosh Mudide Reporting and Analytics for HCM -
Download approval rule reportContent Good day colleagues! Could you please tell if it is possible to download file with this address: hcm/hrc/db/data/HcmCommonTop/HcmCommonTransaction/ApprovalCompos…Kristina Serikova 24 views 2 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
OBIEE SQL and Listagg functionSummary Need to display a list of degrees and certifications in a list for a reportContent Hi all, I am trying to produce a list of certifications and degrees for each e…User_2025-02-04-08-51-08-912 55 views 2 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Need inputs to display data in a single record for each employee if an employee is having multiple aContent Hi All, We have a requirement to display Person, Visa and assignment details through OTBI. As of now we are using below two subject areas to achieve this require…
-
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 85 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 40 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 692 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM