OTBI
Discussion List
-
Login Data from Identity Domain in Reporting and AnalyticsHello, Does anyone know if it's possible for login data from Identity Domain to be displayed somehow in HCM? I've tried the "User System Usage" OTBI subject area, and I'…Nick Dorfner 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 54 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to show the "job" of the manager in the "Assignment Manager (Unsecured)" Dimension?Summary: I am creating a report to look at if employees who are direct or indirect reports for a manager are in the same function area. For example, if a top level manag…Max W 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …
-
Workflow Transactions/Transaction Console Reporting (Rel 13)Content Hello, Just checking if anyone managed to create any Transaction Console related reports out of these two subject areas: 1) Human Capital Management - Transactio…SantoshKumarBhairi 901 views 11 comments 4 points Most recent by Samarpan Reporting and Analytics for HCM -
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin…Giuseppe Cannova 22 views 4 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 605 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI Data Missing After Excel ExportThere are two instances with OTBI reports where I have gotten the message below that have impacted reports. In one report, hyperlinks are not working, and in another, ro…Alexander George Demczak III 11 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
We have BI report but need to send custom schedule like 1st monday, 3rd monday in a monthSummary: Hi Team, We have BI report but need to send custom schedule like 1st monday, 3rd monday like this in a month how will send if through burshting how can we send …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 92 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
When manager run the BI report only need to get the details of direct or indirect reportiesSummary: HI Team, When manager run the BI report only need to get the details of direct or indirect reporties how can we develop this requirement? Thanks, Ajay Content (…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 11 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 32 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Report Job RequisitionWe have an OTBI report is the attached xml. I would like to add below fields in the report to show this information. Please suggest how we can add these fields and where…SauluriR 63 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report on Historical Organization Hierarchies?Summary: We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy … -
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi…
-
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Adding multiple phone numbers to analysisSummary Add multiple phone numbers to an analysisContent Hi All, I just need some direction on adding multiple phone numbers for an employee in an analysis I am modifyin…User_2025-02-04-08-51-08-912 35 views 4 comments 0 points Most recent by Alexis PJ Reporting and Analytics for HCM -
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need …
-
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 13 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType…
-
Gross earnings reportSummary: Is it possible to create a report in OTBI that shows gross earnings per pay for a specific date range? If yes which subject area should we use? can anyone help …Shameer Shaik 21 views 2 comments 0 points Most recent by Shameer Shaik Reporting and Analytics for HCM
-
Using dashboard prompts on multiple-subject area analysisSummary: Using dashboard prompts on multiple-subject area analysis Content (required): Hi all, I created an analysis to track a specific group of managers (narrower than…
-
OTBI with a List of Courses and a link leading to the course pageSummary: Content (required): Hi there, I have created a simple OTBI report with a list of all the courses we have in Fusion Learning - xml code is at the bottom. I wante… -
Employee Names in Local LanguageSummary Employee Names in Local LanguageContent Hi All I need to display the Employee Names (Example: First, Middle and Last) in local Language (i.e. Arabic) I entered t…Shabrawi 130 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c…
-
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records …
-
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…Malla Pratibha 22 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM