OTBI
Discussion List
-
Creating reports with multiple subject areasSummary Creating report with columns from multiple subject areasContent Hi We are trying to create a report containing employee bank account details & National Identifie…Mohit Gupta-45440 47 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue…Rebecca Smith-27468 35 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o…Mansur Khalil 51 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Temp to RegSummary Need a report for temp to reg employeesContent Hi, I need to create a report that returns employees that moved from Full-time Temporary to Full-time Regular.User_2025-01-28-04-58-46-119 38 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle Cloud Reports and AnalyticsSummary Need scheduled New Hire Report with effective date for prior weekContent Hi. I am new to Oracle Reports & Analytics. I have a New Hire report that I would like t…User_2025-02-01-07-51-17-594 57 views 2 comments 0 points Most recent by DavidBlake Reporting and Analytics for HCM
-
Contact Person typeContent Hi, I am displaying the emp contact details using the "Workforce Management - Person Real Time". I want to exclude the contacts who is an existing employee , I c…
-
Set Operations trouble with visualizationsSummary Set Operations Cause graphs and visualizations not to workContent I've tried using set operations a few times for various reasons without much success. In today'… -
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the…Ivy__Valverde 78 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Security Roles - Country Role vs AoR RoleContent Hi experts - I am trying to understand how we can limit our view to reports based on the Area of Responsibility (AoR). Current State: We have a security role cal… -
Effective As-of-Date / Hire Date ProblemContent I am trying to create a report for HR to list all upcoming employees for our external payroll provider. Unfortunately I'm struggling with hire dates that are in …User_2025-01-31-17-16-46-301 140 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Logic Behind Calculated FieldsSummary Trying to find the actual logic behind calculated fields in OTBIContent We are trying to find the actual logic for calculated fields in OTBI. Some are self-expla…
-
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h…Mohit Gupta-45440 93 views 4 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM
-
Goal Counts Report by Goal PlanSummary Employee Goal CountContent I've been trying to create this very basic and most commonly asked for report for well over a year to no scalable avail. I've tried nu… -
Pulling All Rows of Data (All Effective Dates)Summary Has anyone found a way to easily pull all rows of data for an employee in an OTBI report?Content Has anyone found a way to easily pull all rows of data in an OTB…
-
Need to develop a BI Publisher report that will have filter mechanism in the output.Summary Need to develop a BI Publisher report that will have filter mechanism in the output.Content Need to develop a BI Publisher report that will have filter mechanism…Aloka Bhattacharya 60 views 4 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Join Grade Rate Real Time and Salary Details Real TimeSummary I want to create a report with information from Workforce Management - Grade Rate Real Time and Compensation - Salary Details Real Time but I can not join them p…Rogelio H 90 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Drill down to a specific part of the chart ?Content Hi Community, We noticed that in our reports, when we have a drill to details function enabled (eg headcount by country in this case), it sometimes drills to the…[Deleted User] 46 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Lenth of Service or Tenure FunctionSummary I'm looking to create a column that will show length of service in years.Content I'm looking to create a column that will show length of service in years. Is it …User_2025-01-25-00-37-41-739 154 views 7 comments 2 points Most recent by User_2025-02-01-05-55-45-070 Reporting and Analytics for HCM
-
OTBI Analytic: 2 values in one column - share it to two columns or show meassures only once in one cSummary Behind one field there are two different values . Under the results the two values are summarized in one column. Would need each value in a separate column. How …User_2025-01-25-03-41-47-642 119 views 2 comments 0 points Most recent by Karen B Reporting and Analytics for HCM
-
Question about Worker -> Parent Manager fieldsSummary Question about Worker -> Parent Manager fieldsContent I have a question on how the data in the parent manager fields (Parent Manager 1, 2, etc.) gets populated. …David Villegas 87 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reference Number in BI Publisher ReportSummary How to capture unique reference number for BIP report when you run each timeContent Hello Experts, We have BI publisher report (HR Letter) report like No Objecti…VinodKumar 51 views 7 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Assignment Status Reporting IssueSummary Assignment Status Reporting IssueContent Hi All, I am building a Global Payroll Transfers Report in OTBI with the SA "Workforce Management - Worker Assignment Ev…User_2025-07-18-02-05-33-261 58 views 4 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM