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
-
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r… -
OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? input - Report Name Output - list of users who ran thi… -
Reporting on a Additional Job FieldContent Morning All, If you see the document I have uploaded it will make more sense with Images. Wonder if you could help me to get the bottom of a reporting issue with…User_2025-01-28-18-35-09-769 33 views 4 comments 0 points Most recent by User_2025-01-28-18-35-09-769 -
Performance Reports - Leaders not seeing resultsSummary Report is blank when opened by a LeaderContent I have created 3 performance related reports (Document Status, Rating Detail and Rating Distribution). When I open…User_2025-01-28-20-43-56-568 51 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Performance Document Status with drill down capabilitySummary How to create drill down capabilityContent Hi. We are in the middle of our performance review process. I created a report (bar graph chart) for Leaders to use to…User_2025-01-28-20-43-56-568 57 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 -
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f… -
Overall Manager CommentContent Hi all, can you kindly help me? I really need to export to report the comment inserted by the manager in the overall performance section (please, see image attac… -
Seeking BIP report for Worker, Potential Life event and Processed Life EventSummary Seeking BIP report for Worker, Potential Life event and Processed Life EventContent I need a list of workers and their event information - Potential and Processe…User_2025-01-23-21-24-21-434 94 views 8 comments 0 points Most recent by User_2025-01-23-21-24-21-434 -
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i… -
OTBI limitationsSummary What are the main OTBI limitations compared to BI Publisher?Content Hi Folks, Is there any place where I can find the list of restrictions on using OTBI? For exa… -
BIP Schedule ReportsSummary Need SQL query to get the information if anyone change the schedules of the reports.Content Hi All, We scheduled couple of BIP reports based on UTC (Ex: 09:00AM … -
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting… -
AutomailerSummary There is a requirement to create an automailer to employees with pdf outputs of two different BI reports as attachmentContent There is a requirement to create an… -
Data PrivacySummary How do you share your reports with your users?Content Hi all - I submitted a post recently about how you share reports with users (through self-service and/or da… -
How to display data in one row?Content I created a custom analysis to show performance ratings of employees but it shows manager ratings and employee ratings in two rows for the same performance docum…User_2025-01-28-21-18-43-496 78 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976 -
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig… -
Ability to report on historic versions of the Org Tree using OTBISummary Ability to report on historic versions of the Org Tree using OTBIContent Hello Team, Does OTBI has the ability to report on historic version of Org tree? I tried… -
Hierarchical prompt for org tree strucutre in BI Data Model ReportContent Is it possible to create a prompt in BI data model report that will give us the whole org tree structure in a cascading way according to different levels as we h… -
BIP Report for Absences Taken & Absences EligibleSummary How do I report on taken absences vs eligible absences?Content Hi all - I have a customer request for reporting on the vacation an employee is eligible to take f… -
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it. -
Tip on how to remove the dashboard header when embedding in a screenSummary Tip on how to remove the dashboard header when embedding a dashboard into a custom pageContent I have been asked a few times recently if it is possible to embed …
-
how to get business unit name from assignments?Summary how to get business unit name of assignments in BI reportContent Hi, I'm developing BI report using SQL script on HCM Cloud. User requested to add business unit … -
BI Publisher - inner joinContent Hello, I have 2 questions about bi publisher data model is there a way to create an inner join between 2 data set in Bi publisher? by default when we create a li…User_2025-01-25-01-33-46-269 62 views 0 comments 0 points Most recent by User_2025-01-25-01-33-46-269 -
BIP Report DashboardSummary Wanted to provide graphical view of BIP report in Manager DashboardContent Hi All, We have developed BIP Custom reports and we wanted to place it in Dashboard wi… -
Learning Evaluations Report in OTBISummary Cannot Report Learning Evaluations DataContent I am trying to create an OTBI report that contains data from the Learning Evaluations folder in Workforce Learning…User_2025-01-28-17-24-53-863 213 views 3 comments 0 points Most recent by User_2025-01-28-17-24-53-863 -
How security works in case of custom report?Content Hello everyone, When we are using OTBI report it is following the security profile of the user logged in and in case of bip reports we have to use secured tables…User_2025-01-25-06-20-12-259 131 views 4 comments 2 points Most recent by User_2025-01-25-06-20-12-259 -
SQL Script for Worker's departmentContent Hi All, I am trying to get the worker's department along with his name, person number, manager etc. I use the following script to get the department; SELECT DIST… -
Term with RehireSummary When adding additional subject area, termination category is blank.Content I have a termination report with the Worker Assignment subject area, worked great. How… -
Manage Audit Policies -> AUDIT_CHANGE_BIT_MAP_Content Helo, I have activate the audit of assignment object : Navigator > Setup and Maintenance > All Tasks > Name : Manage Audit Policies> Search > Go To task > Audit … -
Issue in SQL script to get Overall Summary section commentsContent Hi All, I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my scree…