OTBI
Discussion List
-
Learning Initiatives for New Hire and Promotion ChangesHello, We have a client requirement to define a auto-Assignment of course for all the new hires and also for all promotion cases? Can anyone please suggest how we can ac…User_2025-02-10-16-20-46-816 51 views 8 comments 0 points Most recent by Leonor Medrano Oñoro Learning -
Does BI Consumer role has data access to reports?Summary: Content (required): Does BI Consumer role has data access to reports? If a user has BI consumer role, he can access reports, but how to control reports data sec… -
OTBI report to Fetch Details of learning items assigned based on learning user groupsSummary: Hi Team, I am working on one OTBI report requirement - to fetch the details of learning course completion eg. learning item name, course completion date e.tc. T…Kamini Kaushik-Oracle 161 views 0 comments 1 point Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
OTBI Report filter using Date of BirthSummary: Unable to filter data based on a specific DOB Content (required): Hi All I have a requirement to filter contingent workers whose DOB is equivalent to 01/06/1960…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Additional Criteria Dropping out International EmployeesSummary: I have a report built that is supposed to show everyone that is Active as of a certain date along with their job information and some personal information (phon…Kyle Norris 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extracting String from a text field in OTBISummary: Hi all, I need to extract the last part of an email address so I can include the exceptions in a CASE statement. Content (required): What I need to do is extrac…
-
Phone Number Format in OTBI outputSummary: We created an agent to send employee data from HCM to Service Now twice daily. This includes phone number. However, the requirement is to not include the countr… -
How to control data security on the catalog reports for a custom HR specialist role?Summary: Content (required): What controls catalog reports data access? Should a custom 'Human Resource Analyst' be assigned to a security criteria? If I add access to a…Mostafaaa 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Display Instructor and virtual classroomSummary/Content: We are building up some reports in OTBI for learning. In these reports we want to have a more or less complete view on the learning item and its enrollm…Yves Chassein 21 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
How can I combine HCM and Projects subject areas in OTBISummary: I would like to know if it is possible to combine HCM subject areas with e.g. Projects subject areas in OTBI. Content (required): Hi! I'm creating a rather larg…Nicolas Vahman 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Phase/ State Application ReportsSummary: Content (required): Hello, We would create an simple OTBI analysis that show for each phase/state the number of active job application, We would order the phase…Giuseppe Iacono 11 views 2 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 103 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Sub query in Case Statement in OTBISummary: Hello , I would like to know if we can use subquery in case statement using OTBI Reporting subject areas . For Input Value , 'Payout Date 3' , I need to get the…User_C36BE 771 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - Combining year and quarter in a date columnSummary: Need help to show both quarter and year in a table Content (required): Hi I'm running a learning completion report and want to show quarter and year in one colu…Jane Warwick 31 views 1 comment 0 points Most recent by Jane Warwick Reporting and Analytics for HCM
-
How do you manage reporting in OTBI for courses with reassignment rules?Summary: What is the best way to report on compliance courses with reassignment rules so that you can filter down to a report which only shows the lastest record for eac… -
How to report on training with active reassignment rules & multiple records per employee?Summary: We've got a number of courses with reassignment rules set up and our employees are starting to complete the course for a second time. How do you manage reportin…
-
New Manager type not showing in OTBISummary: We've added a new manager type in HCM and it's currently not showing in OTBI. I've ran the Refresh Manager Hierarchy and the Transfer the Flex fields to OTBI. I…User_2025-01-31-00-25-12-234 73 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM