Reports
Discussion List
-
How can we have a Notification when an employee becomes a line manager ?Summary How can we have a Notification when an employee becomes a line manager ?Content Hello, We would like to have a notification that will trigger when a user is assi…Revital Mefano 46 views 2 comments 0 points Most recent by Abhishek Nigam Reporting and Analytics for HCM -
Latest Hire Date in OTBI without using Seniority DatesContent Hi All, We have a requirement at our project where we need to get the “Latest Hire Date” for any Person in OTBI. The challenge is Seniority dates are not exposed…User_F89L9 155 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tuning a rolling 12 Months turnover reportSummary How to performance tune a trend based report when using Ago and Rolling PeriodContent Hello Experts! In my ongoing saga of working with the trends subject area t…Rob F 146 views 4 comments 0 points Most recent by Abhishek Dixit-Oracle Reporting and Analytics for HCM -
How can I get assignment manager list details when subject area doesn't have themSummary Subject area doesn't contain assignment manager listContent Hi I am trying to adapt a report for direct reports to a line manager only. However I've noticed some…LTalbott2 19 views 3 comments 0 points Most recent by Virginia M. Calvi Reporting and Analytics for HCM -
Absence balance reportContent I am trying to create an absence balance report for each accrual plan by employee. The report would look like the attached using the "Employee Plan Participation…Annette M 130 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Missing direct deposit or personal payment end dateContent We are finding that we are deep into payroll processing before we recognize an employee forgot to enter their direct deposit information and a paper check is a r…
-
Infolet for line managers visible to all employeesSummary Issue with none manager workers viewing Line manager's InfoletContent Hi, I am new to creating Infolet's and I have been able to create an Infolet for our manage…User_2025-01-30-03-54-32-528 147 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Agents for scheduling reportsSummary Can I move a live agent to a different folder?Content Hi, I want to tidy up some folders and would like to move several agents that are currently active (in use)…User_2025-02-05-22-44-35-842 24 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Dashboard with auto refreshSummary Need to know if there is a possibility to auto refresh dashboard to show 'live' view when it's openContent Hello, I was wondering if it is possible to auto refre…User_2025-01-28-05-11-13-165 94 views 5 comments 7 points Most recent by Max Prestes Reporting and Analytics for HCM
-
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the…
-
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 25 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Union Dues reportContent Hello, I am looking for a Union Dues report that is created in BI publisher. Please advise if anyone knows if it exists in the forum. ThanksUser_WHB5J 33 views 5 comments 0 points Most recent by User_2025-02-06-12-47-14-341 Reporting and Analytics for HCM
-
Can't unarchive catalog from Prod to DevSummary Get error message Compression - inflate Error -3 OK when trying to unarchive from Prod to DevContent Hi Apologies if this has been covered before but I couldn't …
-
Regd tracking name change in OTBISummary Regd tracking name change in OTBIContent Hi , We have name change report where we track any changes to person name in past 7 days and display the person's detail… -
OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Summary OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Content Hi All, When we will see data in the Worker"."Previous Last Name"…User_MC37Q 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Exported analysis output is not formatting correctly in ExcelSummary Exported analysis output is not formatting correctly in ExcelContent Hi Team, PFA catalog file of analysis. We have created an analysis which we use to pull dire…
-
CEO direct reportee nameSummary CEO direct reportee nameContent Hi all, We have a requirement to pull CEO direct reportee name For eg. Get the name of manager4 Employee->manager1->manager2->man…Reddykrishna 27 views 3 comments 0 points Most recent by User_2025-02-05-06-26-19-951 Reporting and Analytics for HCM -
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed…Annette M 80 views 8 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM
-
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 265 views 12 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…Sian S 100 views 6 comments 6 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Empty spaces in RTF if there is condition not to show a sectionContent We are working on Talent Profile print and it has multiple section so we are creating an RTF template and having a condition to display section conditionally to …User_2025-02-08-10-09-54-910 327 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
what are the duty roles for viewing worker detailsSummary what are the duty roles for viewing worker detailsContent Hi - Already have the following duty roles added to the custom role: 1. Workforce Profile Transaction A…C.R.Balaji 55 views 4 comments 1 point Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
EEO reporting with the new check box system for Personal Details?Summary How are you getting around the removal of "Two or More Races" as an option? How are you adapting to multiple choices for ethnicity?Content Hi all, We recently up…CIT Shane 186 views 25 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Help BIP Report not pulling correct infoSummary We recently went Live with OLC. One of the reports we built is a BIP report with several parameters.Content Here is the WHERE Clause with parameters. For some re…Mike Borghoff 32 views 3 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 93 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to Pull List of Candidates and Their Supporting DocumentsSummary Query to Pull List of Candidates and Their Supporting DocumentsContent Hi Experts! Looking for some guidance. We need to build a query that lists all candidates …Lindsay Lamont 60 views 7 comments 0 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
Dinamically printing contents in a RTF templateSummary does not work in one caseContent Hi, I am using a RTF template for a Report that should display different contents on the basis of the field named "ANNO", whose… -
Possibility to notify an employee when dashboard updated with new dataContent Hello All, I will appreciate your support in the following issue: We have configured the following dashboard (PFA). Can you please advise if possible to notify t…
-
Could not able to find the "Sequence" field in Checklist Real Time subject areaContent Hi Experts, I am trying to build a OTBI report using Checklist Real Time subject area but i cannot able to see the "Sequence" Field. Has anyone faced this issue?…Harish Vummidi 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Output file is not getting multiple records using EText template.Summary Output file is not getting multiple records using EText template.Content Hi Experts, Output file is not getting multiple records using EText template. I am attac…Bala Kasineedi 46 views 3 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM