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
-
Performance - Feedback Requests ReportContent We recently rolled out a Manager 360 Review. As part of the review, managers request feedback from those in the organization. We are unable to create a report th… -
which field stores value for Primary for national_identifiersSummary: which field stores value for Primary for national_identifiers Content (required): For National Identifiers in Front end,we can enter more than 1 National Identi… -
Is there a transaction table that stores currently ongoing transactions on the page in HCM?Summary: Previously we have hr_api_transactions table in Oracle EBS but now i am not able to find a table like this, Would you please help? Content (required): It is nee… -
DATEVALUE Function is not working properly in excel templateAfter using DATEVALUE Function column values are not matching with the actual column values. Please refer the screenshot Not sure what is the issue. Template : Thanks, M…
-
Need help on Logical SQL with Inner JoinSummary Need help on Logical SQL with Inner JoinContent Hi Experts, Does any one has a sample logical sql where inner join has been used. -
% of Employees on Talent Review meeting w.r.t Succession PlanSummary: I am looking to calculate the % of employees on a Talent Review box those who are on Succession Plan. SO for example on the 9-Box matrix box- Future Star we hav…
-
Filters on multiple SA are not workingSummary: We are trying to create a new OTBI analysis, where we have a requirement to pull both the Worker assignment details and the person VISA details. So we used Work…
-
What is the usage & how to use a View Object validation type in Value set?Summary: Content (required): Version (include the version you are using, if applicable): 21D Code Snippet (add any code snippets that support your topic, if applicable):
-
How to implement a custom version of a standard BI ReportSummary: How to implement a custom version of a standard BI Report Content (required): Hi, I would like to edit a Standard Performance Notification (the report is the fo… -
previous Phase/State - recruitmentSummary: Is there a way of creating a OTBI analysis to show current Phase/State and previous Phase/State Content (required): We would like to create a report which shows…
-
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…
-
General Questions on Reports Data SecuritySummary: Content (required): Also, I need to know if a user has 2 Roles: 1. HR Specialist Custom Job Role assigned to 'View all people' data security profile 2. HR Analy…
-
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…