OTBI
Discussion List
-
ZIP output file of an OTBIHi All, We have a requirement to zip the output file of an OTBI analysis before emailing. Is this possible? Regards,Vibha Pandey - Oracle 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to use better the indexes on the Oracle HCM cloud tables for efficient SQL writing?Summary: Oracle HCM OBI tables list has list of indexes on each table. Can you please explain what is the significance of those indexes and how to make use of them for m…Amit Patil 113 views 2 comments 0 points Most recent by User_2025-07-18-00-53-38-974 Reporting and Analytics for HCM -
How do I find correct security type to add to a role to run report?I have created a dashboard and a new role which I had inherited to another role. The issue though is when I go to run the report I get the following error which I know i…Aaron Reynolds 22 views 5 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Export vs. "Open" Report Data OutputSummary: Hello there! I have a question regarding a discrepancy I noticed in the data output of a report that I'm using. The report pulls all active team members as of t…
-
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
User person Type is not capturedContent Hi all I have created an ORBI report with Subject Area > Workforce Management - Worker Assignment Event Real Time to capture user Person type detail of the user.…Dhajani Perera 52 views 5 comments 0 points Most recent by Erica Williams Reporting and Analytics for HCM
-
Show the pod or instance name on an OTBI Analysis?Summary: We need to be able to label the header of an OTBI Analysis with which pod or instance it comes from. It can be pulled into a data model using the following quer… -
Delegate Access - InfoletsHi all, I was just wondering if anyone know if it was possible for those who have delegate access to run infolets on front end and see the same results as the manager wh…MikeW 121 views 34 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Organization Name for PromptSummary: Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wante…
-
Duplicate person number in OTBI report.Summary: Hi Team, I am using the subject area " Worforce Management - worker Assignment Event Real Time" with below clolum and without any filter . Legislation CodeLegal…
-
Is it possible to pull ALL job applications (rejected, accepted, etc.) in an OTBI report?Summary: Is it possible to pull ALL job applications (rejected, accepted, etc.) in an OTBI report? Content (required): Is it possible to pull ALL job applications (rejec…Kim Buch 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to get outcome, where we can know how many users are set English/German as Language PreferencesSummary: We wanted to know how many users use English/German as a Language Preference set under set Preferences. Content (required): Example, We have 1,000 users, we wan…Deepak9 21 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
OTBI Date Prompts in Calendar FormatSummary OTBI Date Prompts in Calendar FormatContent I have added a Presentation Variable(Date Prompt) to my OTBI Report. I am using the prompt to run the report. However…User_2025-01-22-19-45-49-284 826 views 5 comments 1 point Most recent by Sovit-Oracle Reporting and Analytics for HCM -
Talent Management DashboardHi, I am working on a dasboard to count the number of employees have a performance document in the worker evaluation status. I have both a KPI and a drill down report. T…
-
pivot table sorting dataSummary: How to sort data in pivot table view Content (required): I created a report using a pivot table, but the data in pivot can be sorted in ascendent or discendent …
-
Calculations not working when joining Payroll – Element Entries Real Time and Workforce Management –Summary I have some calculations insing information from Payroll – Element Entries Real Time, but when adding fields from Person real time the calculations are not shown…
-
Report for failed attempted login with error messageSummary: Need to create a report for audit all the failed attempted logins with the error message. Content (required): Person number, name, date/time of login, error mes…Kumar, Nitin 13 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
how to build OTBI report that give grade rate name by citySummary: Content (required): how to build OTBI report that give grade rate name by city. I am encountering a situation wherin I see multiple salary plans or grade rate n…
-
OTBI Report as on effective dateSummary: Want to generate OTBI report as on effective date other than sysdate Content (required): We have a requirement to fetch data as on 1 day before the current date…
-
How to fetch details from Worker Assignment Real Time Subject area as of (current_date - 7)Summary: Hi All, In an OTBI Analysis, I'm trying to fetch all the employees who has their Assignment Category changed to "Leader" in the past week. But I don't see a sub…Akhila 55 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Current HTML Markup values are not working after 23B updateSummary: I've added BIP report to the UI using the HTML Markup. However, when I entered its HTML Markup values, the dashboard is not working as expected. Upon checking, … -
Audit Report for all tax code changes received from HMRCSummary: Need a report showing tax code changes from HMRC Content (required): Can anyone help with suggesting how do I go about building a report based on tax code chang…Isabela Radivoi 61 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI) -
Workforce Compensation Real Time issue in production vs test podsWe created a report in our test environment and vetted it fully. Everything is being pulled from the Workforce Compensation Real Time subject area, we are not using more… -
Ability to Report on Talent Profile Strength Indicator (Content Section Completion)Summary Ability to Report on Talent Profile Strength IndicatorContent Hi All, I am searching for some information on how I can report on employee talent profile completi…User_2025-02-08-03-57-26-191 77 views 2 comments 0 points Most recent by Revanth.Rondla Reporting and Analytics for HCM
-
Adding Worker Payroll Name to Custom Timecard ReportI have multiple custom timecard reports being developed. In these reports, I need to include the Pay Frequency (Payroll Name/Worker Payroll Name). The reports are develo…
-
Add a data into a domain - direct accessContent (required): I would like to be able to integrate the data "Group contract type" (see enclosed picture) directly through the domain "Workforce management - Assign…Jacqueline GRANDIN 2 views 2 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
how to join subject area work relationship real time with worker assignment real timeHello, I have an otbi report in there already have subject area (WorkForce Management Worker assignment Real Time) and (WorkForce Management Worker Person Real Time) and…Mirza_Adeel 366 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report showing employees not enrolled in benefitsSummary: Identify active employees not enrolled in medical that can be run at any time. This is not related to Open Enrollment. Content (required): Does anyone have a re…JHaden3 14 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Edit in Oracle standard absence approval notificationsHi, I want to make edits to the standard notifications in Oracle, such as changing the mail's to and cc information or the title of the mail.and I don't know how and whe…Cansel Karasoy 42 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp…