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
-
Document of Record ReportingSummary Document of Record ReportingContent As HR we are trying to report off the Workforce Management - Document of Record Real Time to look at employees and try and se… -
Reg OTBI CountHi we are have OTBI report which gives the count of enrollment for each plan , for some of the plan no emp is enrolled ,in the report we are not getting this plan detail…
-
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…
-
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…
-
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 146 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 -
How do we design action links to navigate to a web page related to that record in HCM?Summary: I would like to be be able to create Action Links in Oracle BI Analysis reports that allow the user to click and then be taken to the record that is being repor…
-
View Formatted CLOB Text in BI Report Excel TemplateSummary: We are trying to fetch a formatted CLOB Data in an Excel template. However, the report is fetching HTML tags in the Excel cell . We tried the solution given in …
-
21B - DFFs not populating in OTBIContent We recently added some DFF's to our health and safety module and I'm able to find them in the correct subject area but when I look at the results there's no data… -
Dashboard in Default collapsed modeContent Have any one tried using Dashboard for hosting the links of reports? Is there a setting available to open the dashboard with collapsed sections? We can see the s… -
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 53 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro
-
Subject Areas for Work SchedulesSummary Our clients requirement is to create on the ratio of Planned/Scheduled Hours vs Actual Hours.Content Dear Experts, Our clients requirement is to create on the ra… -
Can we Hide Exporting options from user while running BI Publisher Reports ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Report With the FileURL (Download Link) of an Employee DocumentSummary: We need a BIP report with a download link to an employee's document (DocumentRecords) Content (required): Hi, Is it possible to generate a BIP report with the d…
-
Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_idSummary: Content (required): We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It…
-
Amalgamated Absence DaysSummary: My report is totalling the absence days for all absences of the same reason name and displaying that total on each line of absence in the report. I need it to d… -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Pictorial Representation of Organization TreeSummary: Pictorial Representation of Organization Hierarchy Content (required): HI Team, How we can create Pictorial Representation of Organization tree. Need to display… -
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged. -
Unable to edit delivered RTF report templateSummary: Unable to edit delivered RTF report template Content (required): Hi, I'm attempting to edit the benefits summary delivered RTF template. The issue I'm running i…
-
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…
-
Report for Eligible Benefit plan details for EmpHi We have process Open enrollment and life event is in started state, and emp can enroll into the benefit plans , but we need to created a report which display emp deta…
-
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo… -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…
-
Drill down reportSummary: Drill down report Content (required): I have created analysis with two columns as department and head count, I have created action link on headcount column whic…
-
How to show all organization/department levels in hierarchical tableSummary: I'm trying to build an analysis showing all departments in each legal entity but only get departments that have employees connected to them. Content (required):… -
Adding a column that calculates the % based on absolute numbersSummary: Content (required): Hi there I am sure this must be fairly simple but ... I have a report with pie chart for people completed, not started and in progress for L… -
Seniority Date values are not available in OTBISummary Seniority Date values are not available in OTBIContent Hi Team, Seniority Date values are not available in OTBI, Workforce Management Assignment Real Time and Ev…
-
RestAPI -for HCMSummary: I have to extract organization information from HCM using RestAPI but I struggle to find the "organization tree" Could someone tell me how to get an overview of… -
In any of the OTBI Subject area, multiple Manager_Type are not available.Summary: When I am using workforce management checklist real time subject area for the 'Contact Person for external' type of manager I am unable to find column where the…