OTBI
Discussion List
-
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 101 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 71 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…Sovan Mishra-Oracle 1.2K views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we add spaces in between bar on a stacked bar graph in OTBI Analysis OutputSummary: Adding spaces in between bars on a bar graph in OTBI Content (required): On the output of a bar graph, the bars are connected with each other. Can we add extra …Vibha Pandey - Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to see Values BU wise Head countSummary: unable to see Business unit wise Count while select column Head Count and Business Unit Name. Content (required): In subject Areas "Workforce Management - Worke…
-
How to remove unwanted Folders on Catalog?Summary: Content (required): How to remove unwanted Folders on Catalog? Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Fetch Employee level details from comp worksheet and budget details in an OTBI reportSummary: We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manage…User_EJ1U2 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.Summary: I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center informat…RJ Blankenship 331 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
"Job Requisition - Posting Structure"."Job Function" and "Current Phase" ProblemSummary: Content (required): Hello Guys, We would report if we create a simple analysis from "Recruiting - Recruiting Real Time" subject area we lost a lot of data than …Giuseppe Iacono 11 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
Turnover Report Filtering 0-2 year TenureSummary: We have a requirement for a report that would have a rolling 3 year calendar that shows the headcount/termination counts for employees that are 0-2 years during…Rob Stahly 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Record Identifier In GL InformationSummary Record Identifier In GL InformationContent Is there any additional info resubject area apart from this note. Record Identifier In GL Information under Manager De…CraigX 71 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany