OTBI
Discussion List
-
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are …Ryan_Sullivan 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce ManagementSummary Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce Management - Worker Assignment Real-Time subject areas in Fusion HCMCon…Mahendra 167 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fiscal CalendarSummary Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar.Content Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year …Chris Campbell 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated item for % assigned to courseSummary Learning DashboardContent I`m using a new calculated measure to work out the 'Capacity % Filled' for each of the courses but it won't calculate correctly. Any id…User_2025-02-06-11-18-47-896 35 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…user9020833 103 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Can you find what fields are used in reportsSummary With upgrade to talent, how can i find the reports that the using the old fields?Lynn B 34 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Error when Editing Reports: Panel Div 'idView' not found in document oracleContent I've started receiving the error below when I'm editing reports. Has anyone seen this before? Panel Div 'idView' not found in document oracle Version 20AUser_2025-01-31-00-25-12-234 34 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to use FILTER USING function in edit formula in oracle otbiContent Hi All, Can anyone explain how this function FILTER(Column name USING() works in oracle OTBI. Regards, ShreyUser_2025-02-07-13-49-29-960 88 views 2 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Checklist Configurable Form ReportingSummary Pulling data from configurable form in checklistContent What is the best way to pull dff's that make up the configurable form within a checklist? After the 19B r…Shelly Feyerherm 372 views 7 comments 3 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Extract Month name in Oracle OTBIContent Hi All, Can we extract month name from any date by using any function in oracle OTBI. Except function monthname because it gives the month number not name. I wan…User_2025-02-07-13-49-29-960 719 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 236 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Get AOR Type and Scope in OTBIContent Hi All, I want the Area of Responsibility Type name and Scope( Wheter it is Business Unit,Grade or Department) in the oracle OTBI Analysis. Please let me know th…User_2025-02-07-13-49-29-960 39 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to get list of past 25 years from current year in OTBI ParameterContent Hi All, We want to display the list of past 25 Financial years in the oracle OTBI analysis parameter which will be dependent on another parameter. We have 3 para…User_2025-02-07-13-49-29-960 97 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Printable Department Hierarchy chartContent Hi All, Can someone share a sample for department hierarchy printable chart? I tried with the link https://cloudcustomerconnect.oracle.com/posts/9510552320 ,But …Nivya Mathire 70 views 8 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
All worker - active and terminated employeesContent Hi, i need to implement a OTBI report with all the employees, active and terminated. I started to work on it, but, as outcome the report havs also the old lines.…Nicola Petri 67 views 10 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
OTBI HCM Employee ReportSummary Required HCM OTBI database mapping with UI screensContent Dear All, I'm new to OTBI reporting. I need to create a employee report using OTBI and I'm unable to fi…User_2025-02-06-00-25-05-847 129 views 6 comments 1 point Most recent by Tejaswini-Oracle Reporting and Analytics for HCM
-
Recruiting OTBI Report: Job requisition completed: phase and status of candidate selected brigs an eSummary I´m creating a report listing all job requisition in phase open with state complete, cancel or closed and we need to show the name of selected candidate if are. …Christian_Kaladjian-Oracle 304 views 2 comments 0 points Most recent by Christian_Kaladjian-Oracle Reporting and Analytics for HCM -
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are …User_2025-01-31-00-25-12-234 104 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
OTBI : non-Fusion data sourceSummary Adding non-Fusion data source connection is not supported and will be deprecated in a future release.Content Got this message on the Admin page for data sources.…User_2025-02-05-23-02-10-916 36 views 10 comments 1 point Most recent by User_2025-02-05-23-02-10-916 Reporting and Analytics for HCM
-
Course training hoursSummary Learning DashboardContent Hi I am trying to pull through the training hours for the course against each of the offerings under the course, but nothing is pulling…User_2025-02-06-11-18-47-896 33 views 8 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
OTBI Report for OTL - Subject Areas with Dimensions and NavigationsContent Dear Team, Kindly share the documentation / useful link for below details. 1. OTL - OTBI report with Subject Areas and Dimensions with Navigations. Thanks, ArunArun Kumar Krishnan [AK] 65 views 5 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calculated Sum of Gross paySummary need a new calculated value say Semester 1 (Jan-May) and Semester 2 (Aug-Dec). It should return the sum of the gross pay for all the pay periods falling under Ja…Kalyani Koylada 69 views 2 comments 0 points Most recent by Kalyani Koylada Reporting and Analytics for HCM
-
Logical SQL - adding column selectorSummary Is it possible to add a "column Selector" to a Logical SQL report?Content Hi, I am trying to add a "column selector" to a logical SQL report. I would like to giv…Mitch_123456 50 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Values Based on custom SQLSummary Values Based on custom SQLContent I would like to display the Data for last 4 years based on data from initial setup. Eg : Need to display value 100 for each of …
-
Get a list of languages for people in the systemContent Hi, We have 10,000 people in our HCM instance. How do I bring back each individuals language skills So given a suffix or a person_id, I want to bring out the fol… -
Salary and Assignment Changes ReportContent Hi all - I am working on a few changes reports, and the next one we are working on is assignment changes AND salary changes. I am very comfortable with doing an …Prudence K 122 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on Benefit Elections during enrollment periodSummary report on those who select an option before enrollment is completeContent Is there a way we can report on newly hired employees who have selected a certain benef…Shelly Feyerherm 63 views 4 comments 0 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM
-
Need to find the Owner of the BI ReportSummary Need to find the Owner of the BI ReportContent I need to know the owner(who has created) the report for almost 85 reports.is there an easy way to do that. Or do …User_2025-02-05-02-11-29-794 29 views 5 comments 0 points Most recent by User_2025-02-05-02-11-29-794 Reporting and Analytics for HCM
-
Salary History As of Year EndSummary Salary History As of Year EndContent I have a requirement to display salary as of 31-Dec-YYYY (YYYY is the Year end date) . Am able to get the value based on Cal…
-
Time Card Cost Center in OTBIContent I'm trying to fetch All Approved Time Cards where the Employee hours are charged to a different cost center than the employee home cost center in OTBI. Which Sub…Nithin Channa 33 views 2 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM