OTBI
Discussion List
-
What roles needed to let custom HR Specialist Role able to open any report or analysis?Content What roles needed to let custom HR Specialist Role able to open any report or analysis? and what controls reports and analysis data security? BI consumer Role? B…Walid Hamdy 47 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 36 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Number of days a requisition is suspendedSummary Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBIContent Hello ever…Tom John Bontoyan 54 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Benefit Eligibility CriteriaContent Hi All, When we click on the Eligibility profile able to see View hierarchy and Eligibility criteria. Can you please share inputs in which Table/OTBi subjetc are…
-
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …Helen Tilling 137 views 4 comments 0 points Most recent by User_2025-02-08-06-26-45-662 Reporting and Analytics for HCM
-
Conditional format image - The file type is invalid, only .png .jpeg .jpg .gif and .bmp files are suContent I am trying to add a image if a condition holds true but I am getting this error message trying to upload an image. I confirmed the image format I am trying to u…User_2025-02-10-08-27-16-805 11 views 6 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. …
-
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 211 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 43 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM
-
Individual prompts for two analysis on a dashboardContent Hello, I've been working on a dashboard where we need to have two analysis. There is one column which I wanted to use as prompt individually for each analysis. I…Praneeth K-261878 19 views 6 comments 0 points Most recent by Praneeth K-261878 Reporting and Analytics for HCM
-
Calculating Difference from Headcount factContent I am trying to calculate difference between Headcount (Fact from Assignment Real Time) by work location and the number of employees that uploaded a document type…Riti Malhotra 38 views 5 comments 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Analysis with EIT fieldsSummary Need to display current Parent Position Code for the record but EIT causing duplicationContent HI all, I need some help with an Analysis - I have paired the anal…User_2025-02-04-08-51-08-912 157 views 4 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp…
-
Out of control sessions since upgradeSummary SessionsContent We're mid-upgrade and while investigating performance in reporting I noticed that we have an unreasonable amount of active sessions. We have +400… -
Trend Lines in OTBI ChartsContent Hello, Is it possible to add trend lines to an OTBI bar graph? We are creating a dashboard for HRHD and want to add a trend line on top for number of cases. I've…User_2025-01-31-00-25-12-234 84 views 10 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 23 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
ORC Candidate Diversity - SummarySummary Getting to one row per job requisition?Content I've created an analysis that uses the delivered counts of applications, veterans, gender, and disability status t…User_2025-02-10-15-34-12-310 148 views 2 comments 0 points Most recent by User_2025-02-10-15-34-12-310 Reporting and Analytics for HCM
-
Adding Action link on Performance Document Created vs Not createdSummary Adding Action link on Performance Document Created vs Not created Content Hi, We have requirement to add an action link and display the employee populations in t…Prabhu Krishnamoorthy 29 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to calculate time from different eventsSummary Calculate time difference between different phases (events) in a recruitment processContent Hi, I´m trying to create a report where I can report on the different…Even Kjorsvik-Oracle 40 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusSummary Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusContent Hi, Our scheduled BIP reports are stuck on "Waiting" or "Running" status, even the one…
-
Report on Transactions that failed in BPMSummary Report on Transactions that failed in BPMContent Hi Has anyone worked on creating reports based on BPM tables. I have requirement to fetch the failed termination…User_2025-01-30-21-52-52-008 130 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…Nidhi Chhajed 110 views 9 comments 1 point Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 51 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac…
-
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a…Mike Householder 30 views 2 comments 1 point Most recent by Mike Householder Reporting and Analytics for HCM -
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio…
-
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti…