OTBI
Discussion List
-
Performance Goals Version TypeSummary When an employee updates their goal, update does not reflect in report until Version Type = ACTIVEContent Is it normal behavior for when an employee updates a pr…User_2025-01-28-20-36-10-715 56 views 4 comments 0 points Most recent by User_2025-02-04-23-22-13-274 Reporting and Analytics for HCM -
Approval Status in the Goal ReportContent I have created an OTBI analysis based on Goal Status Overview Real Time subject area. After running the report identified that goal approval status is not showin…User_2025-01-28-21-18-43-496 141 views 5 comments 0 points Most recent by User_2025-02-04-23-22-13-274 Reporting and Analytics for HCM
-
Limit results to terminated employees in the last 13 monthsContent Hi, I need to limit the report to the terminated employees of last 12 months ( the current month has to be excluded) I'm using the field Workforce Management - W…Nicola Petri 19 views 2 comments 1 point Most recent by User_2025-02-05-12-12-38-615 Reporting and Analytics for HCM -
Duty Roles Required to Access OTBI Subject AreasSummary Looking for the Document that lists Duty Roles Required for each Subject AreaContent I thought I had this document saved, but now I can't put my finger on it. Pl…User_2025-01-25-06-00-22-809 166 views 6 comments 0 points Most recent by Claudio Civati Reporting and Analytics for HCM
-
Duplicate Element EntriesSummary Element entries for employees are appearing twiceContent Hi, Please see attached XML file/ If an employee has more than one element entry then that will appear o…User_2025-02-05-22-44-35-842 48 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
R13 20A - How to include OTBI subject area in BI SQLsSummary Wanted to include in the BI SQL select statement OTBI subject areaContent How can i include OTBI subject areas in my BI SQL reports being created Version 20ASuganthi Srinivasan 55 views 4 comments 0 points Most recent by Suganthi Srinivasan Reporting and Analytics for HCM
-
Reporting through Payroll Balances Real TimeSummary Guideline to build reports using Payroll Balances Ream TimeContent This document will help user build scalable reports using OTBI Payroll Balances Subject Area. …Niraj Kumar-93373 114 views 1 comment 4 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Adding Home Email AddressSummary adding home email address without having people drop off reportContent I need to add the home email address to an existing analysis, however, employees who don't…Shelly Feyerherm 54 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where to find definitions for each standard OTBI measure?Summary I'd like to see the definitions or specific criteria used for defining which HCM transactions affect each of the predefined standard measures in OTBIContent Is t…James Hoffmann 86 views 10 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Will it be possible to get direct & Indirect employee assign to managerSummary Will it be possible to get direct & Indirect employee assign to managerContent Hi All, Will it be possible to get direct & Indirect employee assign to the manage…User_2025-02-05-01-04-36-989 49 views 11 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
LSQL QuestionsContent Hi all - I am working on an LSQL report for combining salary/assignment data to show old/new information. I have run into a few questions that I am really hoping…Prudence K 57 views 10 comments 0 points Most recent by Aslam Khuajah Reporting and Analytics for HCM -
Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBISummary Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBIContent I have a report using a Data Model that uses 2 data sets. I use an…DavidBlake 166 views 13 comments 0 points Most recent by Gregg Vadasz Reporting and Analytics for HCM -
Agents querySummary Recipient / Specified UserContent Hi, If I set up an agent as a specified user i.e. (me), will the recipient who is located in a different region still only see …User_2025-02-05-22-44-35-842 34 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Need inputs to display data under "Calculated Time" section in OTLContent Hi All, As per the OTL setup we are referring two layouts while displaying OTL data. Initially employee will enter hours , Payroll time type, Hours and related f…Visu 42 views 4 comments 0 points Most recent by User_2025-02-06-14-40-18-938 Reporting and Analytics for HCM
-
Job field empty for one employee but filled for other employeeSummary In a report the job field for some employees is empty and for some it does contain informationContent I have created a report with two subject areas (workforce m…Inge Marinus 22 views 3 comments 0 points Most recent by Inge Marinus Reporting and Analytics for HCM -
Managers are unable to view Performance Document Task Status OTBI reportSummary Managers are unable to view the Performance Task Status OTBI report, whereas they can view the data on Front end. We are using the delivered Line Manager role. A…User_2025-02-06-20-49-14-481 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Analyses report to fetch Supervisor Level 2 and aboveSummary Analyses report to fetch Supervisor Level 2 and aboveContent Hi, I am looking to fetch the following using Analyses. * A list of Supervisors with Level 1 (not ma…Manoj.Gupta 48 views 6 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement …
-
Performance Tile - create a measure of maxium distance from CEOSummary How to create a measure of max of levelContent Hi, we need to create a measure that is the maximum distance from CEO. Level is calculated by the following formul…Nicola Petri 26 views 4 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Performance Tile - create a measure #managers/#employeeSummary How to create a measure #managers/#employeeContent Hi, we need to create a measure that is the ratio within the number of managers and the numbers of employees. …Nicola Petri 30 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filled Requisition ReportSummary Need help troubleshooting a few things on a filled requisition reportContent Hello! Looking for some help troubleshooting the attached filled requisition report.…Jennifer Eichholz 45 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI job history report with previous/current values?Summary I'd like to report with previous and current valuesContent Any one have examples or advice on developing an OTBI which will display both the previous and current…User_2025-01-28-08-47-04-905 207 views 3 comments 0 points Most recent by RamaKrishna Vemula Reporting and Analytics for HCM
-
Pending Workflow Notifications DashboardSummary Dashboard to be created for pending workflow notiifcationsContent Hi all, We are trying to create a dashboard which will display the number of pending workflow n…User_U7T4G 116 views 11 comments 0 points Most recent by Ankush Rode Reporting and Analytics for HCM
-
Assignment Overview with effective date (Report)Summary This report gives an overview over changes to assignments within your organizationContent The main purpose of this report is to give a manager or HR an overview …Even Kjorsvik-Oracle 73 views 0 comments 8 points Most recent by Even Kjorsvik-Oracle Reporting and Analytics for HCM -
Slow Performance when Department tree columns are includedContent We have built a simple report using ‘Goal Alignments Real Time’ subject area. The report runs in few seconds if we do not include Department tree columns. Howeve…User_2025-02-05-23-59-37-171 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Aligned Goal information missing in report outputContent We are setting up Goal Alignment report using the "Workforce Goals - Goal Alignments Real Time". Subject Area. The report works fine when running with a HR View …User_2025-02-05-23-59-37-171 60 views 4 comments 0 points Most recent by User_2025-02-05-23-59-37-171 Reporting and Analytics for HCM
-
Benefit Eligible - Working Hours ChangesContent Hi all - we have requirements for our benefit eligible population: Person Type = Regular Employee, Limited Term Employee, Casual/Seasonal Employee Assignment Cat…
-
Workforce Trend Headcount by User Person TypeSummary We have a requirement to trend headcount by person type. It appears the workforce trend real time subject area only returns the latest person type and not the pe…Ryan_Sullivan 60 views 5 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin…User_2025-01-28-05-39-23-766 126 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Revoking User Access to the Shipped OTBI Content in Fusion HCM 19CSummary This white paper documents the steps to revoke access to the seeded OTBI content for all users in 19C.Content In 19C, OTBI introduced a new set of BI reporting r…User720640-Oracle 175 views 6 comments 11 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM