OTBI
Discussion List
-
Pivot table not showing as intendedI am trying to create a Pivot table using a User Defined field in Compensation-Workforce as the main Row, except that it keeps totaling the user defined data instead of …Jamie Bradley 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Single Requisition BU or Multiple Requisition BUSummary Single Requisition BU or Multiple Requisition BUContent Here is a business case Three Legal Entities * LE1 * LE2 and * LE3 One Requisition BU and One Procurement… -
How is Absence Days metric is calculated?Summary: Hi, We would like to understand how Absence Days measure is calculated. It gives different results (one correct and the other is not) I don't know what the issu…HulyaAkan76 62 views 5 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can Area of Responsibility be on OTBI report?Summary: Area of Responsibility be OTBI report Content (required): We have 2 representatives in the Area of Responsibility that I need to put on an OTBI report. Is this …Donna Valentine 133 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Checklist Real Time not returning Pending Worker ChecklistsContent We are using Checklists for our Onboarding process, and these checklists and associated tasks are being assigned to Pending Workers automatically prior to their …User_2025-02-06-09-45-30-140 125 views 31 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Gross to Net YTD valuesSummary Require a report that shows the Gross to Net YTD valuesContent I found the base report in /Shared Folders/Human Capital Management/Payroll/Payroll Calculation Th…User_2025-02-04-08-51-08-912 70 views 3 comments 0 points Most recent by Shray N Reporting and Analytics for HCM
-
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
Is there a way to see where the OTBI Agent burst to?Summary: Wondering if there is a way to see where an OTBI agent sent reports to. Content (required): We have a report that bursts based on manager username. The details …
-
Creating analysis using user defined fields in Workforce CompWe are trying to create some reports using the Compensation-Workforce Compensation Real Time subject area and was under the impression this subject area would pull data …Jamie Bradley 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to calculate Turnover percentage between count attributes in OTBI ?Summary: How to calculate Turnover percentage between two count attributes in OTBI ? Content (required): We are working on an OTBI report where we have to create a summa…
-
Define OTBI prompt default depends on login userSummary Would like to define OTBI prompt default depends on login userContent Is it possible to define OTBI prompt default depends on login user?Raku Komatsu-Oracle 127 views 1 comment 2 points Most recent by Valeriy Gorbunov General Ledger & Intercompany -
Oracle Learning - is it possible to report all assignments/roles for an individual in one report?Summary: We have a business need to report on student learning (in the same way we report on staff learning - completions and overdue by department). However, some of ou…Michelle Taylor DU 51 views 17 comments 0 points Most recent by Michelle Taylor DU Reporting and Analytics for HCM
-
How to get plan start and end dates for a persons absenceSummary: I want to build a report to show the start and end dates of a person enrolment in a plan as we need to write to each person when a plan will expire. Content (re…Sharon Harper 12 views 6 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
HC trend working hoursSummary: Content (required): I am using workforce trend real time to pull period start and end HC by calendar month (2019/2020); however, when I want to drill down to wo…Riti Malhotra 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit Trail for OTBI ActivitySummary We would like to see an audit trail of who has made changes to a specific folder of OTBI reports and also who has generated specific reports.Content We have a nu…User_2025-02-06-10-48-34-019 106 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
How to use the average functionality per legal employer?Summary: Trying to use th avg functionality in OTBI but not getting the right results in Content (required): I want to show some simple statistics based on legal employe… -
How to pull Number of employees who dont have a development goal?Summary: The requirement is to build a OTBI dashboard that should display two donut charts (should be added a link) for #of Employees who has atleast 2 development goals…Iswarya Lakshmi Priya-Oracle 23 views 4 comments 0 points Most recent by Iswarya Lakshmi Priya-Oracle Reporting and Analytics for HCM
-
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to …BeachDreamer 253 views 6 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Cross SA Employee Census results in errorSummary: In building out an analysis that gives me one row per active employee, I've run into this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8…Kate V 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User Last Login Details Using OTBI ReportSummary: OTBI reports to pull out last login user Details Content (required): Hi, We have requirement to pull out last login user details using OTBI report. Is it possib…Vasanthakumar Ravi 1.5K views 5 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI- Need 'feedback provided for the manager effectiveness success factor, by managers" detailsSummary: Hi team, I need to build an analysis with the details "feedback provided for the manager effectiveness success factor, by managers". Content (required): I need …Satyabrata Nanda 11 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Security by Line ManagerSummary OTBI Security by Line ManagerContent MY OTBI security by Manager doesn`t work. I have the Line manager person profile secured by Manager hierarchy, but the Line …User_2025-01-30-21-52-52-008 285 views 17 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM