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
-
Individual Compensation ReportSummary: We are using individual compensation plans to process additional overtime for the employee with defined approvals but approvers wanted to see analytics before t… -
Manager Filter and Direct Reports To FilterSummary Manager Filter to display the dashboard with direct and indirect reporting associates, and "Direct Reports to" filter Drive from Manager filterContent We have re… -
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when …
-
Two Employee Rows Created only one shows Gender but not dual AssignmentSummary: Content (required): We are running an "All Employees" report and there appeared to be an anomaly on a single employee where it returned two rows of identical da… -
One report containing all assignment, elements and work schedule assignment changesSummary: The organisation requires a combined report containing history of all assignment record, element entries and work schedule assignment changes. Content (required… -
'Payroll - Element Entries Real Time' subject area does not display any data for Line ManagersSummary: I have built a OTBI Report using ‘Payroll - Element Entries Real Time’ subject area for line Managers to see who has Skills Allowance. I have deployed this repo…
-
Is there a way in OTBI and/or BIP to automatically push a scheduled report to SharePoint?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Workforce Succession Management - Talent Pools Real Time Subject AreaSummary Reporting on Talent Pools through OTBIContent Has anyone had any luck reporting on Talent Pools through this subject area? I have been unable to get any results.…
-
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 …