Reports
Discussion List
-
Need query to get the data loaded through HDL FileSummary Need query to get the data loaded through HDL FileContent Hi Experts, Greetings of the day!! We have loaded the Element entries to employees through HDL via diff…Charan Kollipara 1.2K views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Export Geography HierarchySummary How can I export the geography hierarchy?Content Hi, I couldn't find any option to export the full geography hierarchy as we defined in the "manage geography hie… -
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I…User_2025-02-04-08-51-08-912 44 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on data entry by useridSummary Is there a way to pull transactions by person?Content Hi All, is there a report (or do you know the tables) that could be used to find the transactions/data entr…Bonnie Lafferty 42 views 2 comments 0 points Most recent by Bonnie Lafferty Reporting and Analytics for HCM -
Assignment Changes Old and New ValuesSummary Reporting on Assignment ChangesContent I have a requirement for a report that shows Assignment changes with old and new values. For example, Department old and n…JHaden3 146 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Absence Report (back in time)Summary Is it possible to report absences as they were back in time?Content Hi, I provided a report to one of our customers yesterday that showed all absence between Jan…User_2025-02-05-22-44-35-842 43 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Insert the profile image in a BI Publisher report dinamicallyContent Hi, I need to show the employee profile image in a report built using a .XLS template in BI Publisher. The field I'm using is "IMAGE" (BLOB type) from the table … -
Performance issue in absence line manager in OTBI reportsSummary Performance issue in absence line manager in OTBI reportsContent Hi Experts, I'm facing performance issue in a simple otbi report, my report has below fields Emp…Pradvin Prabhakar 33 views 5 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
Workforce Trend Real Time PerformanceSummary Is there anything I can do to tune the performance of this subject area?Content Hello Experts! I'm starting to use Workforce Trends where we are trying to count …Rob F 42 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Do we have a feature in BIP reports to send a notification to certain email ids with the success/faiSummary Do we have a feature in BIP reports to send a notification to certain email ids with the success/failure status of the report?Content Hi, Do we have a feature in…User_MC37Q 102 views 3 comments 0 points Most recent by Abhishek Nigam Reporting and Analytics for HCM -
Creating a BIP report based on a Procedure CallSummary Creating a BIP report based on a Procedure CallContent Hi Team, I need to create a BIP report based on a Procedure call. Is there any documentation available aro…MandeepKGupta 538 views 3 comments 1 point Most recent by Abhishek Nigam Reporting and Analytics for HCM -
Conditional formatting on Pivot table - heat mapContent I have created a report to look at the amount of annual leave taken so far in the year by different teams. I am having trouble putting the conditional formatting…User_2025-02-06-11-18-47-896 44 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…User_2025-02-04-08-51-08-912 43 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Adding Hyperlink to InfoletSummary Want to add a hyperlink to an infoletContent Hi All - I want to leverage my infolet tile as a hyperlink. Have seen it done in the past at a prior company. Does a… -
How to find a report in analytics (Balance Exception Report)Summary How to find an base report in the analytics tool to see if it can be customized.Content Hi All, My users have asked if it is possible to add the Assignment Statu…User_2025-02-04-08-51-08-912 23 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM -
Workstructure and Employee Incumbent Report using Subject AreaSummary Workstructure and Employee Incumbent Report using Subject AreaContent Hi Friends, I am aware it is possible to get Workstruture and Incumbent Details using a cus…AshishERPCloud 34 views 12 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Duplicate LinesSummary What function or formula is best to useContent Hi, I have numerous OTBI Analysis reports that will have 2 or 3 lines per employee because certain columns will co…User_2025-02-05-22-44-35-842 56 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Employee change address reportContent Hello, we are looking to create a report that show changes to an employee address for that month, and to see there old address on the report as well. We want to …Vikki Guyan 99 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to limit Nationality in report?Summary Multiple nationalities for some employees - I only want the the main or primary nationalityContent Hi, I've attached the XML - can anyone modify the report so th…User_2025-02-05-22-44-35-842 31 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Organizational chart with performance ratingsContent Is it possible to create a chart in OTBI in org-chart form that shows position name, position incumbents, incumbents' performance ratings and demographic details?Michael Florescu-Oracle 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle BI publisher - Which tool oracle is decommissioning ?Summary Hi Team, Can you please confirm which part of BI publisher is going to decommissioned ?We are planning to move fully in OTBI but need BI as wellContent Hi Team, …User_2025-02-04-10-02-23-351 53 views 6 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Report on Remuneration Managers of Employees using matrix manager from Workforce Management - WorkerContent Hi Experts, I am trying to create an OTBI report listing all employees and their Remuneration Managers using matrix manager from Workforce Management - Worker as… -
Scheduled Report FailedSummary Scheduled Report FailedContent Hi Experts, Greetings of the day. I have scheduled a custom BI report and it has been failed with the below error after running lo…Charan Kollipara 66 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM -
Determine Time in Current and Previous positionsSummary Progression report that shows how long an employee has been in the current position and how long in the previousContent Hi All, I am hoping someone has a solutio…User_2025-02-04-08-51-08-912 198 views 3 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Issue adding OTBI Report to a dashboard through "Link & Image" ObjectContent Hi all, I am adding all of our reports (OTBI & BIP) to a dashboard as links to be easy to find. However, for one OTBI report, I am getting an error: "Selected it…User_2025-02-05-05-51-12-049 65 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Report Absence based on rolling 12 months from start of monthSummary How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent Hi I would like to report absence on a rolli… -
Dates not coming properly in Excel filterSummary Dates not coming properly in Excel filterContent When we open a Report the report opens in excel. So, now in excel when we trying to filter the date columns, and…User_2025-01-29-18-45-19-617 74 views 4 comments 0 points Most recent by User_2025-01-29-18-45-19-617 Reporting and Analytics for HCM -
OTBI date check End-of-timeSummary OTBI date check End-of-timeContent Hi, I am wondering if anyone has tried to check for end of time on a date column in OTBI. I wrote this. But it doesn't work. A…User_2025-02-05-23-02-10-916 40 views 3 comments 0 points Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM -
How to capture personal payment method deletes through ESS?Summary How to capture personal payment method deletes through ESS?Content Hi Experts, When i am trying to delete the personal payment method through employee self servi…Harish Kumar Kovi 215 views 11 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Connection to external data sources is not supported in Fusion and will be deprecated in a future reSummary Connection to external data sources is not supported in Fusion and will be deprecated in a future release.Content Hi Team, I am exploring the option of creating …MandeepKGupta 56 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM