Sample Reports
Discussion List
-
How to compare BU to TRU.I was wondering if there's a way to compare BU to TRU. I've tried using different logic to compare the two, but haven't had much luck. TRU has the official name, while B…Michael Angelo Lucena 1 view 1 comment 0 points Most recent by Srilatha S-Oracle Reporting and Analytics for HCM -
Employee / Line Manager / HR Specialist seeded analyticsSummary: Customer want to know any seeded list of Employee / Line Manager / HR Specialist analytics or dashboard Content (please ensure you mask any confidential informa…Suresh Manoj Kumar-Oracle 21 views 5 comments 0 points Most recent by Suresh Manoj Kumar-Oracle Reporting and Analytics for HCM -
OTBI icon with starSummary: Regards Oriana Content (please ensure you mask any confidential information): Hello experts, does anyone know what this icon refer to? I basically have an otbi …Oriana L. 21 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
How can we change BI report name dynamically while downloading as per selection parameter.I have created a BI report as 'Job Application Report' and in this report I have created many parameters. One of them is the parameter name 'Requisition Name'. And After…Anjali_Jaiswal 101 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Learning Enrollment status blank in OTBISummary: Content (please ensure you mask any confidential information): Hello Experts, we are trying to create an OTBI report with the Subject area: Learning record real…
-
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 273 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay Content (please ensure …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Oracle Recruiting Internal and External Selected Canidates - OTBI ReportSummary: We have requirement to show selected internal and external candidates in an OTBI report. Please advise. Please provide a sample report. Content (please ensure y…MadhuLekkala 33 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Restricting BI Publisher folder not workingSummary: We are trying to restrict folders in BIPublisher using the roles. However it seems , this is not working. like Folder /shared/Custom/Human Capital Management/Be…
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor…
-
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Milestone date showing as Hire Date in Long service Employees Report ?Summary: Hi Team We have long service employees report on who completed the 5, 10, 15 years like and we applied filter on as below. TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker".…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,…AjayKumar Maddipati 61 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e…AjayKumar Maddipati 42 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 12 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
How to add two subject areas event real time and performance real timeSummary: Hi Team, Any one help me on it's urgent requiremnt . How to add two subject areas workforce management—worker assignment event real time and workfroce performan…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 81 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…Patrick Scally 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th…
-
Logic to calcuate LOP days including the public holidays and weeklyoffsHi , I able to find of the absent days of employee for a month. Now i need help in deriving the logic to include weekly off and holiday if these days falls in between 2 …
-
Information about who rejected the rejected absence recordsHi, I need to add information about who rejected the rejected absence records to my report. When I use the 'fa_fusion_soainfra.wftask table', I cannot access it for reje…Cansel Karasoy 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d…
-
Need to pull working days from Published SchedulesSummary: Hi.. we have a report were we need to pull the working days of an employee from published schedules. We need to know which days are working days and which ones …Alejandrina Vidal 21 views 0 comments 0 points Started by Alejandrina Vidal Reporting and Analytics for HCM
-
How to bursting the BIP report and where we use the bursting conceptSummary: Hi Team, I'm still send the reports through schedule job only but we have butsting concept in BIP reports how can we send through bursting and where we can use …AjayKumar Maddipati 89 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM