Reports
Discussion List
- 
             Payroll Table and Column that Holds Element Entry Override CostingSummary I need to locate this using SQL not the Subject Areas in OTBIContent I've written an SQL query to pull off the element entries and their values from the various …Helen Bennallack 154 views 4 comments 0 points Most recent by Helen Bennallack Reporting and Analytics for HCM Payroll Table and Column that Holds Element Entry Override CostingSummary I need to locate this using SQL not the Subject Areas in OTBIContent I've written an SQL query to pull off the element entries and their values from the various …Helen Bennallack 154 views 4 comments 0 points Most recent by Helen Bennallack Reporting and Analytics for HCM
- 
             Employee list with Performance Document status - whether document exists or notSummary I'm trying to get one consolidated current employee list with the performance document status of a particular document with one row per employee.Content Hi all, …Gary Miller-39965 162 views 14 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM Employee list with Performance Document status - whether document exists or notSummary I'm trying to get one consolidated current employee list with the performance document status of a particular document with one row per employee.Content Hi all, …Gary Miller-39965 162 views 14 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
- 
             Expense concatenated details with worker details.Summary I am using the right SA's but when trying to Cross Getting error.Content I am including the fact column it is still getting error. The intention to cross Expense…Praveen uppari 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Expense concatenated details with worker details.Summary I am using the right SA's but when trying to Cross Getting error.Content I am including the fact column it is still getting error. The intention to cross Expense…Praveen uppari 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             How to get Matrix Manager email by OTBISummary How to get Matrix Manager email by OTBIContent Hi Experts, we are trying to create a report that will show also Matrix manager data, so we used the Matrix manage…kobi 64 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM How to get Matrix Manager email by OTBISummary How to get Matrix Manager email by OTBIContent Hi Experts, we are trying to create a report that will show also Matrix manager data, so we used the Matrix manage…kobi 64 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Find who a Requisition is sitting withSummary Want a Report that shows who a recruitment requisition is sitting withContent Hello all, In Oracle Recruitment Cloud, we have recruitment requisitions. I've been…User_2025-02-06-00-01-08-606 55 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM Find who a Requisition is sitting withSummary Want a Report that shows who a recruitment requisition is sitting withContent Hello all, In Oracle Recruitment Cloud, we have recruitment requisitions. I've been…User_2025-02-06-00-01-08-606 55 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
- 
             Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…Mohit Gupta-45440 808 views 5 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM Report to get data of direct & indirect Reportees of a managerSummary Looking at a way for creating a Report to get data of direct & indirect employees of a managerContent Hi I am looking to create a report which will fetch te data…Mohit Gupta-45440 808 views 5 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM
- 
             Does anyone have a Gender Pay Analysis?Summary Looking for a gender pay analysisContent Hello - Wondering if there is a seeded gender pay analysis report in Reporting and Analytics (OTBI) or if someone has on…Jess Thorn 93 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM Does anyone have a Gender Pay Analysis?Summary Looking for a gender pay analysisContent Hello - Wondering if there is a seeded gender pay analysis report in Reporting and Analytics (OTBI) or if someone has on…Jess Thorn 93 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
- 
             Selected Performance Goals Report Not Printing Success CriteriaContent Hello - Our goal plan is no longer printing Success Criteria. We noticed that the data now sits in SUCCESS_CRITERIA_TEXT and have update our BI document but it s…Becky Mixon 33 views 2 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM Selected Performance Goals Report Not Printing Success CriteriaContent Hello - Our goal plan is no longer printing Success Criteria. We noticed that the data now sits in SUCCESS_CRITERIA_TEXT and have update our BI document but it s…Becky Mixon 33 views 2 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
- 
            Questionnaire data model for checklist taskSummary data model to show questions and responses from checklist task questionnaireContent Does anyone have a data model example to share on the checklist task for the …Shelly Feyerherm 98 views 2 comments 1 point Most recent by Meeghan_Rodrigues Reporting and Analytics for HCM
- 
             Line Manager to access previous worker too through reports.Content Hi Experts: We have this requirement where Line Manger should be allowed to access previous worker as well through the reports, analytics on the LM dashboard. Bu…Ashish Kumar Pandey 37 views 0 comments 0 points Most recent by Ashish Kumar Pandey Reporting and Analytics for HCM Line Manager to access previous worker too through reports.Content Hi Experts: We have this requirement where Line Manger should be allowed to access previous worker as well through the reports, analytics on the LM dashboard. Bu…Ashish Kumar Pandey 37 views 0 comments 0 points Most recent by Ashish Kumar Pandey Reporting and Analytics for HCM
- 
             Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any…User_2025-01-22-19-54-47-882 226 views 17 comments 3 points Most recent by Safdar Hassan Reporting and Analytics for HCM Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any…User_2025-01-22-19-54-47-882 226 views 17 comments 3 points Most recent by Safdar Hassan Reporting and Analytics for HCM
- 
             When joining 3 subject areas in an OTBI report, is it better to add the common columns and hide themContent A client has requested help in joining 3 subject areas in OTBI: Talent, Recruitment, and Core HR. What we did was join all 3 subjects areas with common elements … When joining 3 subject areas in an OTBI report, is it better to add the common columns and hide themContent A client has requested help in joining 3 subject areas in OTBI: Talent, Recruitment, and Core HR. What we did was join all 3 subjects areas with common elements …
- 
             I need help with building a report on Approved Job RequisitionsContent Hi, I have a requirement of building reports on all approved job requisitions. I have tried on my own but I can't really seem to get it right. Have any of you do…User_2025-02-05-16-50-03-083 26 views 2 comments 0 points Most recent by User_2025-02-05-16-50-03-083 Reporting and Analytics for HCM I need help with building a report on Approved Job RequisitionsContent Hi, I have a requirement of building reports on all approved job requisitions. I have tried on my own but I can't really seem to get it right. Have any of you do…User_2025-02-05-16-50-03-083 26 views 2 comments 0 points Most recent by User_2025-02-05-16-50-03-083 Reporting and Analytics for HCM
- 
            Error when Unarchiving a CatalogSummary Receiving an error when unarchiving a catalogContent Hi all, I am trying to unarchive a catalog but receiving the following error: - Compression - inflate Error …
- 
             Reporting performance differences between BI Admin & BI consumer rolesSummary We are seeing reports run much slower for users who only have a BI consumer role compared to BI AdminsContent We have been receiving reports from our end users t…User_2025-01-28-01-47-48-868 47 views 8 comments 1 point Most recent by User_2025-01-28-01-47-48-868 Reporting and Analytics for HCM Reporting performance differences between BI Admin & BI consumer rolesSummary We are seeing reports run much slower for users who only have a BI consumer role compared to BI AdminsContent We have been receiving reports from our end users t…User_2025-01-28-01-47-48-868 47 views 8 comments 1 point Most recent by User_2025-01-28-01-47-48-868 Reporting and Analytics for HCM
- 
             Questionnaire Reporting IssueSummary Report using questionnaire section not returning results as expectedContent One of our business units is using a questionnaire section in their performance revie…Whitney Van Way 37 views 2 comments 0 points Most recent by Whitney Van Way Reporting and Analytics for HCM Questionnaire Reporting IssueSummary Report using questionnaire section not returning results as expectedContent One of our business units is using a questionnaire section in their performance revie…Whitney Van Way 37 views 2 comments 0 points Most recent by Whitney Van Way Reporting and Analytics for HCM
- 
             Group's drill errorContent Hi everybody, I created this analysis : It displays all of employees by country who have completed or is going to the Developpment Interview. This one is "Americ…User_2025-02-06-00-11-44-868 7 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM Group's drill errorContent Hi everybody, I created this analysis : It displays all of employees by country who have completed or is going to the Developpment Interview. This one is "Americ…User_2025-02-06-00-11-44-868 7 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Present Headcount on part of World MapSummary Instead of having a world map I want to have e.g. only EuropeContent Headcount van be presented on a Word Map, but we have only Workers in Europe. Can we have a …Wouter.Schaap 70 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Present Headcount on part of World MapSummary Instead of having a world map I want to have e.g. only EuropeContent Headcount van be presented on a Word Map, but we have only Workers in Europe. Can we have a …Wouter.Schaap 70 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Absence Calendar Details Real time Subject area Calendar view not showing Days absenceSummary Absence Calendar Details Real time Subject area Calendar view not showing Days absenceContent Experts, Created Team Absence calendar using the Absence Calendar D…VijayaBaskar Ranganathan 200 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Absence Calendar Details Real time Subject area Calendar view not showing Days absenceSummary Absence Calendar Details Real time Subject area Calendar view not showing Days absenceContent Experts, Created Team Absence calendar using the Absence Calendar D…VijayaBaskar Ranganathan 200 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             Do Standard Job Roles have access to all Data?Content If an Employee has Job Roles like "Human Resource Analyst" or "Human Resource Specialist"? Will he has data access to all data or should we associate Data Role w…User_2025-02-05-15-05-03-822 36 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM Do Standard Job Roles have access to all Data?Content If an Employee has Job Roles like "Human Resource Analyst" or "Human Resource Specialist"? Will he has data access to all data or should we associate Data Role w…User_2025-02-05-15-05-03-822 36 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
- 
             IT: Looking for analytic/report versioning best practices and tipsSummary I'm looking for advice and best practices on versioning reports, analytics, and dashboards in a repository.Content Hi everyone, I'm looking for advice and best p…User_2025-01-22-18-30-18-571 96 views 6 comments 7 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM IT: Looking for analytic/report versioning best practices and tipsSummary I'm looking for advice and best practices on versioning reports, analytics, and dashboards in a repository.Content Hi everyone, I'm looking for advice and best p…User_2025-01-22-18-30-18-571 96 views 6 comments 7 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
- 
             Conditional Formatting Not WorkingSummary Simple OTBI Analysis - I'd like blank cells to turn red. This isn't working and a couple of cells with data are red.Content Hi All, I have a basic issue that I c…User_2025-02-05-05-51-12-049 55 views 13 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM Conditional Formatting Not WorkingSummary Simple OTBI Analysis - I'd like blank cells to turn red. This isn't working and a couple of cells with data are red.Content Hi All, I have a basic issue that I c…User_2025-02-05-05-51-12-049 55 views 13 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
- 
             In Depth Report Building GuideSummary I'm looking for a guide or free resource on report building and editing.Content I've been building SQL reports for a few weeks now and am looking for resources t…David Rabalais 57 views 4 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM In Depth Report Building GuideSummary I'm looking for a guide or free resource on report building and editing.Content I've been building SQL reports for a few weeks now and am looking for resources t…David Rabalais 57 views 4 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM
- 
             Bar chart - Show null valuesContent Attached xml is a report I have. I have an expression to break out ratings by certain groupings. In the chart, even if null I want to show the column. When I cli…Mike Borghoff 25 views 5 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM Bar chart - Show null valuesContent Attached xml is a report I have. I have an expression to break out ratings by certain groupings. In the chart, even if null I want to show the column. When I cli…Mike Borghoff 25 views 5 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
- 
             OTBI Customer SurveyContent p.p1 {margin: 0.0px 0.0px 14.0px 0.0px; line-height: 46.0px; font: 13.0px 'Helvetica Neue'; color: #000000; -webkit-text-stroke: #000000; background-color: #ffff…User720640-Oracle 42 views 0 comments 2 points Most recent by User720640-Oracle Reporting and Analytics for HCM OTBI Customer SurveyContent p.p1 {margin: 0.0px 0.0px 14.0px 0.0px; line-height: 46.0px; font: 13.0px 'Helvetica Neue'; color: #000000; -webkit-text-stroke: #000000; background-color: #ffff…User720640-Oracle 42 views 0 comments 2 points Most recent by User720640-Oracle Reporting and Analytics for HCM
- 
             Status Changes with Assignment CategorySummary Need to get a report that shows both previous & current categoryContent Do any of you know of a way to capture the previous Assignment Category (full time, part …Deb Luisi 124 views 8 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM Status Changes with Assignment CategorySummary Need to get a report that shows both previous & current categoryContent Do any of you know of a way to capture the previous Assignment Category (full time, part …Deb Luisi 124 views 8 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
- 
             Headcount Report with data as at a specific dateContent Morning all, I currently have a headcount report that uses standard fields (job, department, business unit, etc.). The filter I use for this report is attached. …User_2025-01-28-05-39-23-766 167 views 5 comments 2 points Most recent by James Hoffmann Reporting and Analytics for HCM Headcount Report with data as at a specific dateContent Morning all, I currently have a headcount report that uses standard fields (job, department, business unit, etc.). The filter I use for this report is attached. …User_2025-01-28-05-39-23-766 167 views 5 comments 2 points Most recent by James Hoffmann Reporting and Analytics for HCM
- 
             Performance Eval by StatusSummary Trying to create a report to get a count of performance eval by statusContent I am currently trying to create a report for Performance Evaluation by Status. Here…User_2025-01-29-19-46-35-367 46 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM Performance Eval by StatusSummary Trying to create a report to get a count of performance eval by statusContent I am currently trying to create a report for Performance Evaluation by Status. Here…User_2025-01-29-19-46-35-367 46 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
- 
             Making the most of the Report Sharing CenterContent Here's a short video to get you started if you haven't tried the Report Sharing Center yet: https://www.youtube.com/watch?v=BcRB7CUGIk4Julian Challenger-Oracle 355 views 1 comment 6 points Most recent by Mark_Daynes Reporting and Analytics for HCM Making the most of the Report Sharing CenterContent Here's a short video to get you started if you haven't tried the Report Sharing Center yet: https://www.youtube.com/watch?v=BcRB7CUGIk4Julian Challenger-Oracle 355 views 1 comment 6 points Most recent by Mark_Daynes Reporting and Analytics for HCM
- 
             R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…