Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
5 year history report for Salary + Element entriesSummary 5 year history report for Salary + Element entriesContent I am looking for an OTBI report to capture past 5 years details of salary along with element entries. b… -
Multiple Worksite ReportingSummary I need a report that has the headcount for each work location over the last quarter and the gross wagesContent Hi, In our previous system, we have a report calle… -
SQL query fetching Duplicate rows for terminated employees with pending worker recordsSummary SQL query fetching Duplicate rows for terminated employees with pending worker recordsContent I created a SQL BI Publisher report to fetch all active employees a…User_2025-01-30-21-52-52-008 269 views 18 comments 0 points Most recent by User_2025-01-30-21-52-52-008
-
History of benefit element entry electionsContent Is there a way to report the history of a benefit element assigned to employees and the rate value (communicated rate value)? I am trying to find out what the em… -
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 86 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540
-
Custom HR View Only Role to Run HR ReportsSummary Need HR Custom Role BuiltContent Hi all, I need to create custom role that provides access to run some reports in our HR folder, without granting HR roles to tha… -
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around… -
Need subject area for cost center and companySummary Need subject area for cost center and companyContent Hi, I assign cost center and company values at department level . Now I want subject area for extract detail…
-
Arrange Order and Delete Fields in Data ModelContent I'm dragging and dropping to change the field order in the data model but when I go to run the export, the fields are in the exact same order. I have saved it an…
-
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo…
-
Remove formatting characters from text in Data Model reportSummary Reporting on a free-text field in a Data Model results in formatting charactersContent We have a report set up to capture employees "career statement" from Caree…User_2025-02-03-23-33-26-899 26 views 5 comments 0 points Most recent by User_2025-02-03-23-33-26-899
-
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher? -
BI Publisher Report - Disable Schedule Report option for ESS/Employee roleSummary Ways to disable Schedul Report option for the users with only ESS/EmployeeContent Hi, We have developed a custom BI Publisher Report, the access to which, will b…
-
Payroll - Element Entries Real Time not giving any dataSummary Payroll - Element Entries Real Time not giving any dataContent i am trying to create a report pull the element entries for all the employee. but it is not giving…
-
Learning subject area is not giving dataSummary Learning subject area is not giving dataContent Hi All, 'Workforce Learning - Learning Management Real Time' subject area is not giving data, if a learner not en…
-
Position hierarchy based on logged in person position in OTBISummary Position hierarchy based on logged in person position in OTBIContent Hi All, We are trying to get position hierarchy based on logged in person position. Suppose …
-
Exclude logged in user from indirect reportsSummary Exclude logged in user from indirect reportsContent Hi, I have a Direct and Indirect selector prompts for managers to use which displays direct and indirect empl…User_2025-01-30-03-54-32-528 47 views 9 comments 0 points Most recent by User_2025-01-30-03-54-32-528
-
Performance Tile IsseContent I'm trying to make a performance tile with number of Assignment events using the attached XML. I've done the same with Salary events, but for some reason its not…User_2025-01-31-00-25-12-234 51 views 9 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Open Enrollment ReportSummary Open enrollment report that indicates employees have not enrolledContent Hello Everyone, Do you know any OTBI Subject area or back end tables to create a open en…
-
Users Record History in fusion HCMSummary Users Record History in fusion HCMContent Hi Everyone, Do we have any diagnostics report where we can get user records history ,complete changes happened on user…
-
Report to fetch Hire Dates in a letterSummary Not able to compare among three date in BI PublisherContent I have developed a BI Report to extract salary of a person. And after this developed RTF template in …User_2025-01-29-18-45-19-617 39 views 2 comments 0 points Most recent by User_2025-01-29-18-45-19-617
-
Goal Weight for Mass Assigned Goal - OTBI ReportingContent We've developed a performance goal tracking report with basic information regarding an associate's goals. When pulling in the weight of the performance goal, we …User_2025-01-23-23-27-03-729 48 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
OTBI Reports - Access to ResultsSummary OTBI Reports - Access to ResultsContent Hi we have created a HR Admin where they should be able to see all employee results. But this user only has access to his…
-
Page Composer Changes and OTBI Subject Area ImpactContent Will a change done by Page Composer, like Field Label change, get reflected on OTBI Subject Areas? For example if I change Person number to Employee ID on a page…
-
Not able to restrict edit rights to analysis in specific folderContent We provided employees with the 'Human Resource Analyst' in order for them to be able to create reports. This is what we want, however with this new role they are…
-
Adjust default reports in Line Manager DashboardSummary The section headcount has default reports, how to adjust en add to dashboardContent The line manager dashboard has a section 'headcount' showing headcount and FT…
-
Benefit Enrollment VS ActualContent We are finding that employees enrolled in a benefit and their actual element amounts from the payroll may be different. Is there a report or can someone give me …
-
Unable to create new infoletSummary In sandbox mode but can’t see create infoletContent Hi, can anyone please direct me to a document in MOS or something here which explains steps to create infolet… -
Payroll balance value using PAY_RUN_BALANCESContent Hi All, We have a custom payroll balance (XX_MISC_BAL) and added dimension as "Assignment Tax Unit Year to Date" and "Relationship NoCB Year to Date" as on 01-Ja…
-
Tables to track employee activity to HCMContent Hi All, Can anyone tell us if there is a report,tables...or fields that we can use to create a report...to track if an employee has: 1) Attempted to login to HCM…User_2025-02-04-18-22-33-673 82 views 3 comments 0 points Most recent by User_2025-01-28-00-10-14-788