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
-
Combining historical headcount and turnover numbers in one OTBI reportSummary I would like to see the in one OTIB report the % from turnover vs. headcount from the past three yearsContent I know, how to report historical headcount numbers,…User_2025-01-23-22-38-50-675 298 views 10 comments 3 points Most recent by User_2025-01-28-07-39-27-221 -
Hiding or reordering Fusion Reports and Analytics folder in REL13Summary Hiding or reordering Fusion Reports and Analytics folder in REL13Content Can we hide or reorder the fusion seeded folders in REL13? Did anyone faced this issue t… -
Creating reports with multiple subject areasSummary Creating report with columns from multiple subject areasContent Hi We are trying to create a report containing employee bank account details & National Identifie… -
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue… -
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o… -
How to Calculate Annualized TurnoverSummary How to Annualize TO %Content Hi We are interested in adding annualized TO % to our current TO reporting. I have written a formula that returns the correct annual… -
EText Template: Count of rows not resetting at each LevelSummary Count the number of rows generated for each EmployeeContent Hi, We are trying to get a count of the rows generated for each Employee, but the count keeps increas… -
Temp to RegSummary Need a report for temp to reg employeesContent Hi, I need to create a report that returns employees that moved from Full-time Temporary to Full-time Regular. -
Oracle Cloud Reports and AnalyticsSummary Need scheduled New Hire Report with effective date for prior weekContent Hi. I am new to Oracle Reports & Analytics. I have a New Hire report that I would like t… -
Contact Person typeContent Hi, I am displaying the emp contact details using the "Workforce Management - Person Real Time". I want to exclude the contacts who is an existing employee , I c… -
After R13 Upgrade - Sample data are saved in xdm formatSummary After R13 Upgrade - Sample data are saved in xdm formatContent Hi, After uprading to R13, I am noticing when we try to save sample data by running a SQL in BI pu… -
Set Operations trouble with visualizationsSummary Set Operations Cause graphs and visualizations not to workContent I've tried using set operations a few times for various reasons without much success. In today'… -
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the… -
Security Roles - Country Role vs AoR RoleContent Hi experts - I am trying to understand how we can limit our view to reports based on the Area of Responsibility (AoR). Current State: We have a security role cal… -
Effective As-of-Date / Hire Date ProblemContent I am trying to create a report for HR to list all upcoming employees for our external payroll provider. Unfortunately I'm struggling with hire dates that are in … -
Logic Behind Calculated FieldsSummary Trying to find the actual logic behind calculated fields in OTBIContent We are trying to find the actual logic for calculated fields in OTBI. Some are self-expla… -
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h… -
Goal Counts Report by Goal PlanSummary Employee Goal CountContent I've been trying to create this very basic and most commonly asked for report for well over a year to no scalable avail. I've tried nu… -
Pulling All Rows of Data (All Effective Dates)Summary Has anyone found a way to easily pull all rows of data for an employee in an OTBI report?Content Has anyone found a way to easily pull all rows of data in an OTB… -
R13 Hide BI Catalog contentContent Hi, As we know R13 BI Catalog is lockdown , so we can not change the folder permission for all delivered catalog except Shared/Custom folder and with the Custom … -
New Hire NotificationsSummary Daily notifications of new hires created the previous dayContent Hi everyone - We are trying to create notifications of new hires created daily using analysis an… -
Need to develop a BI Publisher report that will have filter mechanism in the output.Summary Need to develop a BI Publisher report that will have filter mechanism in the output.Content Need to develop a BI Publisher report that will have filter mechanism… -
Join Grade Rate Real Time and Salary Details Real TimeSummary I want to create a report with information from Workforce Management - Grade Rate Real Time and Compensation - Salary Details Real Time but I can not join them p… -
Cross subject areas analysis reportsSummary adding salary to a 'worker assignment' analysis reportContent Hello. I have created an analysis report that takes all fields on Fusion I find important and shows… -
Drill down to a specific part of the chart ?Content Hi Community, We noticed that in our reports, when we have a drill to details function enabled (eg headcount by country in this case), it sometimes drills to the… -
Lenth of Service or Tenure FunctionSummary I'm looking to create a column that will show length of service in years.Content I'm looking to create a column that will show length of service in years. Is it …User_2025-01-25-00-37-41-739 154 views 7 comments 2 points Most recent by User_2025-02-01-05-55-45-070 -
Need to display only latest Talent MeetingSummary How can I adjust my analytic to show only the latest Meeting Version from the last yearContent Hi All, For our Talent analytic I need to show only the latest com…User_2025-01-23-22-38-50-675 44 views 8 comments 0 points Most recent by User_2025-01-23-22-38-50-675 -
OTBI Analytic: 2 values in one column - share it to two columns or show meassures only once in one cSummary Behind one field there are two different values . Under the results the two values are summarized in one column. Would need each value in a separate column. How … -
Not Able to Update Permission on Shared FolderSummary Not able to update Shared FolderContent Good day, We recently updated to R13 in our test environment. I was going through to add permissions on the Shared folder… -
Inability to Secure Seeded Reporting Folders in R13Summary We were informed that as part of R13 we are unable to individually secure the seeded report folderContent Has anyone found a work around for securing the seeded …