OTBI
Discussion List
-
User Roles for subject areasContent Hi is there somewhere where I can see what security is needed to see a subject area. I have built a report using Workforce Management - Absence Real Time and I e…User_2025-02-06-11-18-47-896 69 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM -
Person Extra Information Effective Start DateSummary I need to report on the Effective Start Date from the Extra Information screen within Manage ColleagueContent Hello, I need to report on the latest effective sta…User_2025-01-28-05-32-59-092 58 views 8 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
EFFECTIVE DATES IN EFF'SSummary EFFECTIVE DATES IN EFF'SContent I am 20 A and looking for effective start date and end date for Person EIT but dont find it in the OTBI. I am looking at followin…Ritwick Chatterjee 55 views 1 comment 1 point Most recent by Ritwick Chatterjee Reporting and Analytics for HCM -
OTBI Analysis results specific to user running requestSummary OTBI Analysis results specific to user running requestContent Hello, I created an OTBI analysis that i want to make available for specific users to run. The trou…Jose Castelan 53 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Newly Added Lookup Values not available in OTBI - Service date rule at person levelSummary Newly Added Lookup Values not available in OTBI - Service date rule at person levelContent Hi Team, Newly Added Lookup Values not available in OTBI. Lookup type … -
OTBI - Document name string restricted to 30 charContent Hi In OTBI Report, we are using "Workforce Management - Documents of Record Real Time" subject area and pulling Document names Any document name more that 30 cha…Anand.GK 11 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI - Workforce Management - Position Real TimeSummary No manager information related to the position.Content In the Workforce Management - Position Real Time subject area, there is no manager information? For exampl…User_2025-02-05-12-12-38-615 32 views 9 comments 0 points Most recent by User_2025-02-05-12-12-38-615 Reporting and Analytics for HCM
-
OTBI Subject area accessSummary How to limit the subject area accessContent Hi , How do i hide or delete the subject areas that i dont want the Line Managers to see in the Reports and Analytics…User_2025-01-30-21-52-52-008 168 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 331 views 7 comments 11 points Most recent by Claudio Civati Reporting and Analytics for HCM -
R13 20A - What are the common fields to join with Issue Details and Transaction details Subject areaSummary Need help with OTBI subject areaContent We are trying to create a transaction failure report for the transactions that are failed on a daily basis due to MSS tra…Suganthi Srinivasan 65 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to find PERSON ID Data mode in a subject areaContent Just wanted to see if there is a change in the data model in a subject area. We are trying to find the Person ID data model and could not it in the Worker folder… -
Get Data From Previous Row in AnaltycsSummary Get Data From Previous Row in AnaltycsContent Hi, I have null values in Analytics. I dont want to show like null values. So I want to get data from previous row …User_2025-02-05-02-38-04-251 63 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 57 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 18 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 161 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 46 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 112 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 53 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 84 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 48 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 168 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 35 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 41 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 21 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 …