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
-
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 260 views 18 comments 0 points Most recent by User_2025-01-30-21-52-52-008 -
PDF/A output is not working as expected in BI Publisher reportSummary How to set PDF/A output for a BI Publisher report in HCMContent Hi All, I want to set output type of a BI Publisher report as PDF/A as my intention is not to let… -
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher? -
Detail Compensation Bonus StatementSummary Need report detailing components of an associate's bonus payoutContent We are looking for a detail Compensation Bonus Statement report that can help us see at th…
-
OTBI reports for Individual CompensationSummary Are we planning to launch any OTBI reports for Individual Compensation? If yes, do we have an ETA?Content We have quite a subject area for Workforce Compensation… -
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…
-
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
-
Assigment History - Old Value and New ValueSummary How can we get old value and new value for Assignment History?Content Hi All, Is there any way to get old value and new value for worker's assignment changes? We…User_2025-02-04-18-26-11-309 222 views 3 comments 2 points Most recent by User_2025-02-04-18-26-11-309
-
Reporting on Worker Comp Change Statement ActionSummary Comp Change Statements can be enabled in ESSContent We need to know when a worker accepted/declined/signed statements that are shared with them in ECC. Is there … -
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
-
How to trigger the sending of a report with an action typeSummary Is it possible to trigger the sending of a report with the performing of an action?Content Hi, Is it possible to trigger the sending of a report with the perform…
-
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…
-
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… -
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…
-
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 …
-
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…
-
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 79 views 3 comments 0 points Most recent by User_2025-01-28-00-10-14-788
-
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…
-
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
-
Unable to report on Element Entry HistorySummary 1=2 in SQL query?Content Hello Everyone, I'm trying to use Payroll - Element Entries History Real Time and have created a simple analysis (XML attached) to see e… -
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
-
Need Logic/Query to get base element_type_idSummary Need Logic/Query to get base element_type_idContent Hi Team, Need logic to get the Base element_type_id from Earnings results element. Ex: Currently i have Regul…
-
View Reversals on Element Entries pageSummary How to view reversals in Fusion UIContent Hi All, Reversal has been processed for an employee on a particular date but when I navigate to the Element Entries pag…
-
Looking for a simple element balance look up that captures Payroll reversalsSummary My element balance look up is missing negative values that occur from Payroll voids and revesal.Content Hi, I have this simple Payroll element balance look up th…
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a… -
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…
-
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 46 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle
-
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
-
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 … -
OTBI Employee report - how to stop delegated employees appearing on it ?Summary OTBI Employee report - how to stop delegated employees appearing on it ?Content I have a OTBI manager report that managers can use to see their direct reports ho…