Global HR
Discussion List
-
Joining Recruiting and Checklist subject areaContent Hi All, I have a requirement where I need to get the details of the pending worker in HCM, but I also need the Candidate ID. My question is how to join the follo…Amrit 94 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Oracle Cloud HCM Deferred Terminations analysisSummary Need a way to report on deferred terminationsContent Need a way to report on deferred terminations. Does anyone know how to pull that field?prjohnson 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query ValuesetContent Hi, I just created a valueset and looking for a SQL to query them from the application. Is there an easy way to do it?Misbahul Khair 59 views 1 comment 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM -
Reporting State, County and City tax card informationSummary Need field associated with the specific geography the tax card is associatedContent I need help finding the table and field associated with the specific geograph…Ellen Manthei 95 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Filter analysis based on results of other fields which were based on a filterContent I created a report that will compare, by benefit, what should have been deducted from an employee's check vs what actually did get deducted. As a result I have t…Annette M 37 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Position OccupancySummary I'm trying to check a position occupancy report as I am not sure it is returni9ng the correct incumbent FTE value and showing staff that have left and are inacti…Lee_B 95 views 3 comments 0 points Most recent by User_2025-01-28-21-32-42-630 Reporting and Analytics for HCM -
What Role i need to get data out of AnalysisSummary What Role i need to get data out of AnalysisContent Hi I have BI Admin / HR Specialist and manager / Application Developer roles. I can write sql on BI report an…Jagdish Varadraj 49 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reporting ESS and MSS transactionsSummary Reporting ESS and MSS transactionsContent Is it possible to report on Employee Self Service (ESS) and Manager Self Service (MSS) transactions? What defines a ESS…Andrew_Schmitz 91 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reporting Capability for Field HR Reps (OTBI)Summary Need to understand how Reporting (OTBI) capability can easily be issued to field HR reps.Content Hello, We have 55 plants across the U.S. In each plant there is …User_2025-02-04-11-13-27-138 35 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Compare State column in OTBIContent Hello, We have a requirement to show only those employees whose primary mailing address state is not equal to their work location state. I am able to fetch all t…Prateek Yadav 62 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Taleo requisitions data in Fusion OTBISummary How to get Taleo requisitions data in the fusion OTBI subject area (Human Resources - Recruitment)Content Hi We wanted to create a Human resources dashbard in fu…Mohit Gupta-45440 39 views 5 comments 0 points Most recent by User_2025-01-28-05-11-13-165 Reporting and Analytics for HCM -
OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Summary OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Content Hi All, I have a couple of queries around reporting on Wo…Richard Beet 154 views 14 comments 2 points Most recent by User_2025-02-04-17-55-40-189 Reporting and Analytics for HCM -
Position ManagementContent All - we are implementing Position Management and I have some questions about reporting and hoping you can help direct me. I did search for this information, but… -
What are the various benefit plans to which the workers have enrolled, by various years?Content Looking at the Benefits - Enrollments Real Time subject area's business question it is noted that the subject area has attributes that will answer this question.…Annette M 35 views 1 comment 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Employees & Line Managers without Work EmailSummary We are looking to audit all employees and all managers without a work emailContent Hi all, We are working on some audits and one of the audits we are having some…User_2025-02-05-05-51-12-049 52 views 5 comments 0 points Most recent by User_2025-02-05-05-51-12-049 Reporting and Analytics for HCM -
Need to build a report having more than 2.5 million data.Summary Need to build a report having more than 2.5 million data.Content Need to build a report having more than 2.5 million data. Notepad and notepad ++ is not supporti…User_2025-02-05-22-36-27-300 47 views 4 comments 0 points Most recent by User_2025-02-04-18-22-33-673 Reporting and Analytics for HCM -
How to get Matrix Manager email by OTBISummary How to get Matrix Manager email by OTBIContent Hi Experts, we are trying to create a report that will show also Matrix manager data, so we used the Matrix manage…kobi 66 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…Mohit Gupta-45440 861 views 5 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM -
Oracle HCM Client ToolSummary Can we install and configure BI client tools? if we are on cloud platform to generate a Metadata DictionaryContent Hello Everyone, We are researching on how to g… -
Browse Catalog icon for custom roleContent I have created a custom role copying the seeded Human Resource Analysis job role. But when navigate to the report & analytics can not find the 'Browse Catalog' i…Ayesha Thilakarathna 37 views 4 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
SQL to find jobs with Approval rules tiedSummary SQL to run in BI to find the jobs that are tied with approval rulesContent I would like to find the list of jobs that are tied or used in the Approval workflows.…Jagdish Varadraj 27 views 2 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Password Protecting BI Publisher Reports - Password ChangingSummary BIP Scheduled reports password changingContent Hi all, I've created a few BI Publisher reports with passwords and they've worked fine on the first part of the sc…User_2025-01-31-00-25-12-234 63 views 4 comments 2 points Most recent by User_2025-01-31-17-49-32-187 Reporting and Analytics for HCM -
Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any…User_2025-01-22-19-54-47-882 226 views 17 comments 3 points Most recent by Safdar Hassan Reporting and Analytics for HCM -
Analysis giving female managers as a percentage of headcountSummary Analysis giving female managers as a percentage of headcountContent Hi I've written an analysis that returns the assignment headcount for female managers for my …User_2025-02-06-09-29-18-902 60 views 5 comments 0 points Most recent by User_2025-02-06-09-29-18-902 Reporting and Analytics for HCM -
19C New Subject Area: Security - Roles & Privileges Real TimeSummary Unable to view the 19C New Subject Area: Security - Roles & Privileges Real TimeContent Reading through the 19c Readiness document, there is the new SA Security …Preston Schultz 172 views 15 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
"Extract Workflow Tasks for Archive " processSummary OTBI report is not pulling curent data.Content Hi , We are in 19C patch . Ran "Extract Workflow Tasks for Archive " to archive workflow tasks. Ran this process c…Vasu V 69 views 1 comment 0 points Most recent by Rachel Martorelli-Oracle Reporting and Analytics for HCM -
Need SQL to get Email Addresses for all Managers in Supervisor HierarchySummary SQL to get Email Addresses for all Managers in Supervisor HierarchyContent Hi Experts I am looking for a query which can get me a list of all supervisor's email …Mansur Khalil 576 views 3 comments 1 point Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Issue with Flexfield name in BISummary The FF name in BI are not aligned with name in BIContent Hi, we are facing some issue on BI displaying FF name. Do you know how to fix? Please see the attached d…Nicola Petri-70024 37 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Present Headcount on part of World MapSummary Instead of having a world map I want to have e.g. only EuropeContent Headcount van be presented on a Word Map, but we have only Workers in Europe. Can we have a …Wouter.Schaap 71 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Do Standard Job Roles have access to all Data?Content If an Employee has Job Roles like "Human Resource Analyst" or "Human Resource Specialist"? Will he has data access to all data or should we associate Data Role w…User_2025-02-05-15-05-03-822 37 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM