OTBI
Discussion List
-
Need to count by hierarchy level only the managersSummary Need to create an OTBI analytic which will count from level to level only the manager not the ICsContent Hi all, I was able to create an analytic which shows alr…User_2025-01-23-22-38-50-675 75 views 4 comments 0 points Most recent by User_2025-01-28-20-24-47-566 Reporting and Analytics for HCM -
Count FunctionContent Hi Guys, I need to realize a report that bring me the number of course assignment characterized by a specific status, But if i use a simple count on name of empl…Giuseppe Iacono 48 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display condition based counts in OTBI pivot reports?Summary How to display condition based counts in OTBI pivot reports?Content Hello All - Looking for your inputs on this pivot report. I have a condition like this (CASE …User_2025-01-25-04-02-13-126 37 views 2 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Toggle to include/exclude a column on reportContent I have an analysis that I want to prompt the user to include or exclude the SSN. I would rather do this than to maintain two reports. How would I create a prompt…Annette M 29 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 176 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
To count the citizenship of an employee in OTBI ReportSummary An employee having how many citizenship in OTBI ReportContent Suppose Employee A contain 2 nationality, one is American and the other is Australian. So this empl…Soumya Goswami-Oracle 47 views 4 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
License and certifications Skill Area Attachments - Where are they stored?Summary Require ability to view attachments employees have added to their License and certifications in OTBIContent Hello, I am trying to view attachments employees have…User_2025-02-04-11-20-13-378 114 views 7 comments 1 point Most recent by User_2025-02-04-11-20-13-378 Reporting and Analytics for HCM
-
How can we exclude the login user from the Headcount in the OTBI AnalysisContent How can we exclude the login user from the Headcount in the OTBI Analysis. We have are requirement, If a manager logs in and execute the report to see the headco… -
Only able to see Line Mangers in Worker Assignment subject areaSummary When reporting manager's information, I can only see records of Line MangersContent Hi I'm doing a report where I need to pull all the different managers that an…Rogelio H 67 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Access to query in CloudSummary Ability to run sqlsContent Need to know what options exists to run sql queries in cloud. Also wanted to know if there is a way to connect sql developer to cloud?Praseetha Mohandas-Oracle 61 views 6 comments 0 points Most recent by Praseetha Mohandas-Oracle Reporting and Analytics for HCM
-
Create QR code in RTF template for OTBISummary Create QR code in RTF template for OTBIContent I am trying to implement a QR code for the employee number I have followed the documentation: https://docs.oracle.…Cesar Tepetla Corte 99 views 6 comments 0 points Most recent by Ognjen Pavlovic, HCM Product Management-Oracle Reporting and Analytics for HCM -
In otbi notifications, email is not trigerring properlySummary Manager is getting all employee recordsContent Created analysis by choosing Create Database Query. Now in otbi agent , recipients tab username field chosen from …Soumya Goswami-Oracle 43 views 8 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
Fields added to custom RTF don't show and fields removed still showContent Hello All, I have customized a seeded RTF where I added DFFs to the RTF template and removed unwanted fields from the RTF. However, when I print the document fro…PriyaPenugonda-SC 43 views 9 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
HR Specialist information- Which subject area contains the informationSummary Is there any Subject Area that can tell who is the HR Representative of an Employee?Content Hi I have the need to create an analysis and include who is the HR re…Rogelio H 49 views 8 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI analysis with date prompt pulling duplicate recordsSummary OTBI analysis with date prompt pulling duplicate recordsContent Hello, I was hoping to get some help with fixing my OTBI Analysis report that is pulling duplicat…User_2025-02-04-15-06-22-759 227 views 7 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
DFF in RTF for GoalsContent Hello, I created 4 DFFs in Goal Details page and would like to include them in the RTF. However i don't see them in the xml output to use in while editing the RT…PriyaPenugonda-SC 52 views 13 comments 1 point Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM
-
OTBI reporting on Areas of ResponsibilitySummary OTBI reporting on Areas of ResponsibilityContent I've not seen any recent posts on this so hoping there is some good news out there! Has anyone figured out how t…User_2025-02-04-10-43-02-447 140 views 6 comments 4 points Most recent by User_2025-01-29-02-58-08-021 Reporting and Analytics for HCM
-
How to bring citizenship and nationily in analaysis?Summary Creating a termination Report using subject area Workforce Management:Worker Assignment Event Real TimeContent Creating Analysis in OTBI using subject area Workf…User_2025-01-29-18-45-19-617 27 views 11 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…[Deleted User] 1.1K views 11 comments 2 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Allow Employee role to view data other than own record in OTBISummary Any approach that allows custom Employee role to view records other than own data in OTBI reportsContent Hi, We have a situation wherein we have embedded an OTBI…Kalyan Amaravathi 474 views 3 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
OBI - Cant view all employees in resultsSummary OBI - Cant view all employees in resultsContent Have a Custom HR data role with view all persons and view all everything else. This role also has Workforce Trans…User_2025-02-05-07-31-11-275 37 views 7 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
5 year history report for Salary + Element entriesSummary 5 year history report for Salary + Element entriesContent I am looking for an OTBI report to capture past 5 years details of salary along with element entries. b…User_2025-01-25-04-02-13-126 100 views 14 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
ERISA report or Form 5500Content Hi, Does anyone have any information about Form 5500 or if it's available ootb in our HCM Solution? Thanks,Dishti Malhotra-Oracle 30 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Person Real Time - Contact Phone and Contact AddressesSummary Why don't Contact Phones and Addresses appear?Content Hello Experts, I've created an analysis where I'm prompting for the Person number and we've found that we a…Rob F 36 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Assignment Manager missing or incorrectContent Hi, In the system I have 2 people reporting directly to me. I appear as their Manager under "Worker"."Manager Name" however I am not appearing under "Assignment …
-
Generate OTBI Report only if it meets specific population sizeContent I have a business requirement where an infolet (OTBI report) should not generate a report/data if the population size is less than 20. Does anyone know how to de…User_2025-02-04-10-47-55-876 65 views 2 comments 1 point Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
OTBI: Report that includes data and blanksSummary Creating a report that includes all employees, their external identifiers and work emailContent Hi all, I'm trying to build a report which will display all emplo…User_2025-02-05-05-51-12-049 137 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Infolet TabsContent Infolets are located at the bottom of the HCM home page/newsfeed. I have been told that you can add additional tabs in order to separate out infolets by topic/ty…User_2025-02-04-10-47-55-876 144 views 2 comments 5 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM
-
Need Help? Contact Us? InfoletSummary Need Help? Contact Us? InfoletContent Hi, The following post suggests the region 'Need Help? Contact Us.' on the Managers Terminate Work Relationship page is an …Karen Waddell 119 views 8 comments 1 point Most recent by Cristina Greyling - Oracle-Oracle Reporting and Analytics for HCM -
How to get the Top Down Manager Hierarchy in OTBISummary How to get the Top Down Manager Hierarchy in OTBIContent Hello Everyone, Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports …Harish Kumar Kovi 1.3K views 13 comments 0 points Most recent by User_2025-01-23-23-27-03-729 Reporting and Analytics for HCM