OTBI
Discussion List
-
can we customize the labels of 9 box in the talent tab of line manager dashboard reportSummary: Wee need to customize the labels of 9 box in graphical view in the talent review tab of line manager dashboard report Content (required): Version (include the v…Arpita Maitra 22 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI formulas to combine 2 criteriasSummary: Help on OTBI formula Content (required): I would like to create a formula that would allow me to get the AVERAGE individual bonus achievement BY workers and BY …Jacqueline GRANDIN 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I am getting exception error for a scheduled report through bursting for an OTBI querySummary: Scheduled an OTBI report through bursting but getting an exception error. Content (required): Job processor caused exception [INSTANCE_ID=bip.bi_server1] [INSTA…Srini Padmanabhan 213 views 13 comments 0 points Most recent by Supriyaa Damodaraswamy Reporting and Analytics for HCM -
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 131 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 21 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… -
Absence Accrual OTBI ReportSummary: Hi All, We have a requirement to develop OTBI Report for Absence Accruals. I couldn't able to get the accrual details. Does any one have catalog file or know ab… -
Created initiative for learning but not getting enrollmentsSummary: We would like to assign learning automatically to the new hires. We would like to assign learning automatically to the new hires. We created the initiatives and… -
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… -
Holds, Approval and Due payables infotile displaying data for all available BUsSummary Holds, Approval and Due payables infotile displaying data for all available BUsContent Team, User can able to see all available BUs information on the Holds, App…Surya01 36 views 5 comments 0 points Most recent by Arvi Dinavahi-Oracle Payables, Payments & Cash Management -
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… -
Learning Initiative - New Starter Courses then added to Cyclic Courses - Not WorkingSummary: Content (required): Good Day, We have 8 mandatory course that have to be completed by New Employees within the first 30 days so they become compliant for a Year… -
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 23 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 848 views 5 comments 1 point Most recent by Sovit-Oracle Reporting and Analytics for HCM -
Fusion Role Required for Approval & ReportsContent This sounds like a basic question, however we did not get a convincing answer via My Oracle Support. We are a Finance & SCM customer, and we would like to know (… -
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 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Trying to default Selling Profit center BU on SO line using pre transformation rules but could not fSummary Trying to default Selling Profit center BU on SO line using pre transformation rules but could not find right attributeContent Trying to default Selling Profit c…