OTBI
Discussion List
-
How to make the shown value of one column depend on the value of another column?Summary: How to make the shown value of one column depend on the value of another column? Content (required): I've made an analysis from the assignment real time subject…Matti Bugge 104 views 4 comments 0 points Most recent by Matti Bugge Reporting and Analytics for HCM -
How to convert State Code into State name in BI AnalysisSummary Convert state code into description using subject area or table.Content Hi, I am building an analysis to get some information from a Person's payroll run results…Senthilkumar D 146 views 7 comments 0 points Most recent by Dhinakaran-Venugopal-Oracle Reporting and Analytics for HCM -
Busting OTBI Myths - Using Agents to BurstContent Myth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase comp…Julian Challenger-Oracle 446 views 18 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI: Custom message while opening DashboardSummary: Custom message while opening Dashboard Content (required): We have a requirement where cutomer wants to have custom message of dashboard prompt. Can we edit OOT…
-
Report on Temporary Global TransferHello Is it possible to report on the field 'When do you expect the new work relationship to end?' available on Temporary Global Transfer through OTBI?
-
22B - Manager Resources Dashboard - white screen for around 15 seconds before loadingSummary: Since 22B deployment, our dashboards are taking around 10 - 15 seconds to load... Content (required): Has anyone else got an issue loading dashboards? Since 22B…Kevin M Storrie 61 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Calculate time between interactions ORCSummary: Hello - we are trying to report on the time between interactions in ORC. We can pull in the creation dates for each interaction, but we are unsure how to calcul…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Getting error in Headcount OTBI ReportSummary: Hi all I am using the below Subject area Workforce Management – Worker Assignment Real Time Compensation – Salary Details Real Time Workforce Management – Perso…Deepak Bhatt 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Front-Loaded Accrual BalanceContent I've been trying to create an Absence Balance OTBI Report that reports both the Incremental and Front-Loaded Balances (for the Incremental Accrual Balance, I use…
-
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 -
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 54 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 123 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 124 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 71 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…
-
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 52 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 13 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 97 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 21 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 227 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
-
Unable to join "Workforce Management - Absence Real Time" and Accrual real time subject area.Hi Team, I have a requirement where I need to fetch the absence details and accrual balance if the employee takes the absence under the plan which he is enrolled in. For…Khush Tiwari 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM