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
-
Report used in another ReportContent I have built a report that pulls a list of employee numbers based on a specific set of filters. I then have another report that pulls data based on the employees… -
Absence Attachment in Report OutputSummary Absence Attachment in Report OutputContent Hi All, I have a requirement in which i have to display absence attachment content in report output for each employee.… -
From where to get (table name) the value of Candidate Type When Applying field.Summary: From where to get the value of Candidate Type When Applying field.Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
How to Add Sort Order to Table or GraphContent This document explains how to •Add a ‘sort order’ column to an OTBI report•Add the ‘sort order’ column to Table or Graph view•Hide the ‘sort order’ column on a P… -
Concat string values in OTBI/BI AnswersSummary: Concat string values in OTBI/BI Answers Content (required): Is there a possibility to have a function like listagg for strings in OTBI/BI Answers? -
Learning Records Real Time Report cannot add Hire Date field without rendering an errorSummary: Content (required): Since the Learning Management - Learning Real Time Assignment Subject area has been deprecated, we've been directed to use 'Learning Records… -
How to apply Line Manager data security in BIP report running from OTBI dashboardSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
OTBI and pulling yesterdaySummary: Hi All, I must admit I am pretty bad with dates in OTBI. I am attempting to build a report that will pull something entered the day before. Content (required): … -
Fetching single latest row per person in logical SQLSummary Fetching single latest row per person in logical SQLContent Hi Team, I need to fetch Top row for a person and am using assignment real time subject area.. But, i…
-
Security Slowing Down ReportsContent Hi all - We have a security role, Global Reporting, that allows me to create, edit, run reports and see all data. We give this role out to our report developers …
-
Latest Assignment Row in OTBISummary: How to get the latest assignment row in OTBI Report Content (required): I am looking to develop a OTBI report to fetch the latest effective row in assignment. C…
-
OTBI Report to identify the populationSummary: Our client has asked that I share a report that identifies the population. Is there anyone who knows how I'll be able to do it? Could you please send me a sampl…
-
ORC: Candidate EIT info Reporting via OTBI Subject AreasSummary: Can we extract ORC Candidate EIT info via OTBI Subject Areas? Content (required): Can we extract ORC Candidate EIT info via OTBI Subject Areas? What will be the… -
Oracle HCM Cloud Mobile Apps usage reportSummary: Oracle HCM Cloud Mobile Apps usage report Content (required): Please we have a request from our Executive Management, we need a report that can show us how man… -
Does BI Consumer role has data access to reports?Summary: Content (required): Does BI Consumer role has data access to reports? If a user has BI consumer role, he can access reports, but how to control reports data sec…
-
OTBI report to Fetch Details of learning items assigned based on learning user groupsSummary: Hi Team, I am working on one OTBI report requirement - to fetch the details of learning course completion eg. learning item name, course completion date e.tc. T…
-
OTBI Report filter using Date of BirthSummary: Unable to filter data based on a specific DOB Content (required): Hi All I have a requirement to filter contingent workers whose DOB is equivalent to 01/06/1960…
-
Additional Criteria Dropping out International EmployeesSummary: I have a report built that is supposed to show everyone that is Active as of a certain date along with their job information and some personal information (phon…
-
Extracting String from a text field in OTBISummary: Hi all, I need to extract the last part of an email address so I can include the exceptions in a CASE statement. Content (required): What I need to do is extrac…
-
Phone Number Format in OTBI outputSummary: We created an agent to send employee data from HCM to Service Now twice daily. This includes phone number. However, the requirement is to not include the countr… -
How to control data security on the catalog reports for a custom HR specialist role?Summary: Content (required): What controls catalog reports data access? Should a custom 'Human Resource Analyst' be assigned to a security criteria? If I add access to a…
-
Display Instructor and virtual classroomSummary/Content: We are building up some reports in OTBI for learning. In these reports we want to have a more or less complete view on the learning item and its enrollm…
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…
-
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…
-
How can I combine HCM and Projects subject areas in OTBISummary: I would like to know if it is possible to combine HCM subject areas with e.g. Projects subject areas in OTBI. Content (required): Hi! I'm creating a rather larg…
-
Phase/ State Application ReportsSummary: Content (required): Hello, We would create an simple OTBI analysis that show for each phase/state the number of active job application, We would order the phase… -
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e… -
Sub query in Case Statement in OTBISummary: Hello , I would like to know if we can use subquery in case statement using OTBI Reporting subject areas . For Input Value , 'Payout Date 3' , I need to get the…
-
OTBI - Combining year and quarter in a date columnSummary: Need help to show both quarter and year in a table Content (required): Hi I'm running a learning completion report and want to show quarter and year in one colu…
-
New Manager type not showing in OTBISummary: We've added a new manager type in HCM and it's currently not showing in OTBI. I've ran the Refresh Manager Hierarchy and the Transfer the Flex fields to OTBI. I…User_2025-01-31-00-25-12-234 66 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle