OTBI
Discussion List
-
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 156 views 7 comments 0 points Most recent by Dhinakaran-Venugopal-Oracle Reporting and Analytics for HCM -
Busting OTBI Myths - Using Agents to BurstContentMyth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase compa…Julian Challenger-Oracle 494 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 -
Net weight, Tare weight, Net weight UOM, Tare weight and Gross weight fields are not appear.Summary: Net weight, Tare weight, Net weight UOM, Tare weight and Gross weight fields are not appear in receiving window Content (required): Hi, As per 21D update this a…Navindu Amarasinghe 132 views 3 comments 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management -
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 61 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 131 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 69 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 11 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 104 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM