OTBI
Discussion List
-
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 71 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 65 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 306 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 103 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 35 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] 66 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 70 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 120 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 65 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 35 views 2 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM
-
OTBI Union ALL Sort OrderSummary Need to sort the first union query using UNION ALLContent Hello, Just wanted to ask if there was a way to sort the first query created that is then UNION'd ALL w…User_2025-02-05-12-12-38-615 77 views 4 comments 0 points Most recent by User_2025-02-05-12-12-38-615 Reporting and Analytics for HCM
-
How to compare EE and Manager DetailsSummary OTBI report neededContent We are auditing some of our HCM data. We would like to compare an employee's department against their manager's department. Most of the…Ashley Cossey 19 views 2 comments 0 points Most recent by Ashley Cossey Reporting and Analytics for HCM
-
OTBI CASE Statement across Subject AreasSummary Attempting to write CASE IF statement for data across subject areas in OTBI and receive errorContent Business requirement is to write a CASE IF statement to popu…user9020833 118 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Age BinsSummary Invalid Alias FormatContent Hi, I've copied a formula that calculates the age of an employee from the following Oracle video: https://www.youtube.com/watch?v=QpG…User_2025-02-05-22-44-35-842 26 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to get the classroom for an Activity learning item?Content Hi everybody, I should report the classroom for Activities but I am not able to get it. I don't find the link between the activity id and the classroom id (this … -
OTBI - How to download Archive file via web serviceSummary OTBI - How to download archive file via web serviceContent Hi, I'm considering to automate below archive process through web service. 1. Navigate to report path …
-
Unable to Export HTML Narrative View for OLC Learning CertificateContent Hello, I followed this post to create an Oracle Learning Cloud certificate in OTBI using HTML with the attached report and Narrate View code. It is displaying pr…User_2025-01-31-00-25-12-234 38 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to delete duplicated records in OTBI AnalysisContent Hello experts, I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only. However, the analysis return…Valerio Curzi 1.2K views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Understand SQL Query for Talent profile data modelContent Hi Everyone, I have created the data model for talent profile print action with the help of delivered data by oracle. In delivered data model oracle has used a s…Misbahul Khair 101 views 3 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
"Department Name" Attribute Missing from "Workforce Management - Person Real Time"Summary "Department Name" Attribute Missing from "Workforce Management - Person Real Time"Content Hi Experts, While trying to build a custom OTBI Analysis on "Workforce …AshishERPCloud 39 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Reports (and Dashboard) SharingSummary Request for best Practice for Reports (and Dashboard) SharingContent Hello all! We have newly implemented HCM Fusion and received little guidance concerning Repo…User_2025-02-05-11-42-08-011 147 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get UI value on SQL outputContent Hello Experts, How we can pull or put some conditions to get the result. Eg. There are few fields with drop value like Yes, No but when I am pulling the data thr…Misbahul Khair 23 views 3 comments 1 point Most recent by Karthik K-Oracle Reporting and Analytics for HCM
-
Unable to view Full-Time Equivalent value from OTBIContent Hi All, We created OTBI report based on "Workforce Management - Worker Assignment Real Time" subject area but unable to view "Full-Time Equivalent" data from OTB…