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
-
Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogSummary Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogContent We have developed some analytics and dashboards and the cl… -
Table name to query the Delegation Approval rule and categorySummary Table name to query the Delegation Approval rule and categoryContent I have a requirement to create a report for Delegation Approval Rule and category informatio… -
Does Drill down feature work for Logical SQL based Analytics?Summary Want to know if the drill down feature works with analytics developed using Logical SQLContent For one of the requirement it was not possible to use the fields d… -
Publishing a custom dashboard to one user from OTBI in HCM FusionSummary Need assistance in publishing a custom dashboard in OTBI out to a single userContent I have a custom dashboard that I only want one user to have access to. I kno… -
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the … -
Absence leave duration issueContent Hi, I am unable to get the correct leave duration in the analysis , employee has applied for 0.5 days leave , but in the analysis it is showing as 1 day , I have… -
CONCAT Area Code and Phone NumberSummary I want to combine an employees work, home, and cellular phone number so area code isn't a seperate columnContent Using this forum topic https://cloudcustomerconn…User_2025-01-28-08-47-04-905 141 views 5 comments 0 points Most recent by User_2025-01-28-08-47-04-905 -
Usage statistics for analysis in OTBISummary We want to monitor the usage of our reportsContent Hi, Does someone know if there is possibility to track the usage for reports in OTBI. For example, to see how … -
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones … -
how to create an OTBI Report to extract Employee details who do not have Line Manager RoleSummary OTBI Report to extract Employee details who do not have Line Manager RoleUser_2025-01-29-02-01-53-212 61 views 7 comments 0 points Most recent by User_2025-01-30-20-59-13-989 -
DBI Item for Representative of an employeeSummary DBI Item for Reprensentative of an employeeContent Hi All, I want to know is there any DBI item for Representative of employee based on position. Thanks RatnakarUser_2025-01-30-22-34-07-335 35 views 2 comments 0 points Most recent by User_2025-01-30-22-34-07-335 -
OTBISummary in otbi how to get the count of same salaried employeesContent Hi, in otbi how to get the count of same salaried employees. -
Termination Report for Managers not reflecting all terminationsSummary I have created a termination report for managers but when a manager views, it is not accurate.Content The Termination Details Report was created for use in a Das… -
Creating a Filter Based on Staff with Multiple Rows of Data in AnalysisSummary Creating a filter that will only produce records when an employee has more than one row on the reportContent Hi- I'm working on building a report to focus specif… -
EEO-1 Report - R13Summary DUNS Number does not fit in field on reportContent Hello Community, The DUNS number on the delivered EEO-1 audit report in R13 does not fit and is cut off. In R1… -
User Audit RolesSummary Can we report on roles removed?Content Hi all - I have seen multiple postings about how to report on what a user has for roles, but those are current roles. Is i… -
Can't get Scheduled Hours of employee that shows on OTL Time Card into OTBI ReportSummary I need to get field Scheduled Hours per week that shows on employee time cardContent Hello , I assigned a work schedule to worker and I need to get value of Sche… -
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way…User_2025-01-22-19-43-38-766 41 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 -
Report off of Attachments Within Performance ModuleSummary Managers and employees can add attachements to their performance form. I need to know who has an attachment.Content Our managers can use the attachment field at …User_2025-01-25-00-37-41-739 63 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…User_2025-01-30-03-54-32-528 65 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Show those with No Goals in a Goal ReportSummary Creating a report which shows those with no goals in a particular goal planContent I'm looking to create a report that shows a count of goals for users along wit…User_2025-01-22-19-54-00-543 91 views 4 comments 0 points Most recent by User_2025-01-22-19-54-00-543 -
Individual Compensation Plans - OTBI subject areaContent Hi All Sorry if I've missed something but I am struggling to find how to report in OTBI on Individual Compensation Plan requests made by an employee and the asso…User_2025-01-29-19-59-51-150 90 views 2 comments 0 points Most recent by User_2025-01-29-19-59-51-150 -
Element Data History reportContent I am having issues getting a history report of the element data to work correctly. I am trying to pull in the data in a date range, and present the element data …User_2025-01-30-00-38-09-143 175 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could… -
Active assignment - Prompt between datesSummary OTBI - Active Assignment by dates promptContent Hi, I want to create a report that will show us employees which were active between dates. The end user will choo… -
Dashboard Access RoleSummary Need to Set Someone Up With Access to a DashboardContent Need to Set Someone Up With Access to a Dashboard --- I've created a company-wide demographic dashboard … -
Creating a drill down report from a pie chartSummary Want to have ability to click on a pie slice and have it open to details.Content I have created a Goals Status report. I would like to have the ability for someo…User_2025-01-28-20-43-56-568 46 views 6 comments 0 points Most recent by User_2025-01-28-20-43-56-568 -
"Failed - Blocked" Message on DownloadSummary Our teams are receiving a "Failed - Blocked" error message when using ChromeContent Hi - Thursday (25 JAN) our users could use Chrome to access Fusion and downlo… -
Bursting in BIP report using the rolesContent Is bursting possible based on the roles the user is assigned. For Example, if I have a report containing the data for US and UK, then all the person who has the …