OTBI
Discussion List
-
Calling UDT in OTBISummary We need to get UDT values on OTBI AnalysesContent Hi All, I am working on an OTBI analyses where we need to derive values from UDT. I am not able to see these UD…Vibha Pandey - Oracle 631 views 19 comments 0 points Most recent by User_F1ZIP Reporting and Analytics for HCM -
How to calculate the correct number of employeeContent Hi Guys, I need to calculate the correct number of the employee active in the company. I used the Headcount field with the filter Assignment status == Active, Ac…Giuseppe Iacono 47 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Look Up Value as Of DateContent Hello, Is it possible to create a field in OTBI to look up a value as of date. The requirement I have is to pull an employees current job and salary and their jo…User_2025-01-31-00-25-12-234 52 views 16 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Problem in a Presentation VariableContent Hi Guys, I have a problem in a report that I created to filter the entry elements for effective start date. I don't able to change the effective start date field…Giuseppe Iacono 39 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report viewing problemContent Hi Guys, I have a big problem with the report viewing. I created a HR Dashboard, every employees can see the Dashboard, but who have the procurement role don't h…Giuseppe Iacono 33 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Can we get 'Time in Position' through OTBI?Summary Can we get 'Time in Position' through OTBI?Content Hi Team, Is it possible to get 'Time in Position' column through OTBI. Means how long the assignment exists in…Harish Kumar Kovi 56 views 5 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Audit for multiple open assignment-related transactions on same associateSummary Audit for multiple open assignment-related transactions on same associateContent Good afternoon. Wondering if anyone has built an audit (in either OTBI or BIP) t… -
Payroll User-Defined Tables Real TimeSummary OTBI joining subject areasContent Hello. I am trying to link the "Payroll User-Defined Tables Real Time" subject area to the "Person Real Time" / "Workforce Mana…User_F1ZIP 80 views 1 comment 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Date prompt is getting passed in invalid format to BI report used in Dashboard.Summary Date prompt is getting passed in invalid format to BI report used in Dashboard.Content Hello, We are facing an issue in while using dashboard as BIP as content. …~ GK ~ 334 views 4 comments 1 point Most recent by Vinod Andhavarapu Reporting and Analytics for HCM -
How to show Zero or another message in Infolet if Analysis does not return dataSummary How to show a message or 0 if analysis does not return any row, When there is a count it shows the count.Content How to show a simple message or just Zero (0) as…Prateek Parasar - GTUK, ACE Pro 38 views 11 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Limit what data users can see in OTBISummary We want to limit certain data that the users can see in OTBIContent We have a requirement to limit data on the UI and in OTBI that the user can see. For example,…User_2025-02-04-19-36-53-958 51 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report for Absences are going into auto denial statusSummary Report for Absences are going into auto denial statusContent Report for Absences are going into auto denial status We have Absence going into Denial status, not …Mansur Khalil 63 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Plans to move from OBIEE 11.1.1.9 to 12.xSummary When does Oracle plan to move the OTBI/BIP cloud platform from version 11.1.1.9 to 12.xContent Is there a Statement of Direction or a blog post that states if an…User_2025-01-30-04-37-05-780 44 views 10 comments 3 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Workforce Trend Real Time - Calculate Weekly TurnoverSummary Trying to use Workforce Trend Real Time and Worker Assignment Event Real Time to calculate weekly turnover ratesContent Hi! I'm trying to create a report showing…User_2025-01-28-04-09-16-818 166 views 4 comments 1 point Most recent by Lauren Owen Reporting and Analytics for HCM
-
Analytics for Absence BalanceSummary Is it possible to make an analytics to get absence balance for a given dateContent Is it possible to make analytics to get the absence plan balances for a given …Prasan Edirisinghe 92 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Distinct row in a employees reportContent Hi Guys, I need to realize a report with the following field: National Identifier National ID National Identifier Person type Name Last Name Name First Name Legi…Giuseppe Iacono 61 views 2 comments 0 points Most recent by Srini Devara Reporting and Analytics for HCM
-
Performance Rating Level Name for Section and ItemsSummary Show Rating Level Name for both section and item when they use the same rating modelContent Hi, I kindly need to know if there is a way to display section rating… -
Audit Log on reportsContent Hi Experts, We are having multiple BI publisher and OBIEE reports set up in UAT and production environments. What is the most efficient way to run audit on the r…User_2025-01-30-00-14-06-021 136 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
Fiscal Year ReportingSummary Reporting from 1st date of fiscal year up until today, and from tomorrow up until last date of fiscal yearContent Hi, I am still very new to OTBI and SQL. What I…User_2025-02-05-10-44-58-756 55 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Benefits Service DateSummary Where do we find the field for benefits service date in OTBI. We are needing to pull that field into many reports but only find other seniority dates.Sarita Schumacher 57 views 6 comments 0 points Most recent by Maria VanderMolen Reporting and Analytics for HCM
-
IDP PDF ReportSummary IDP PDF Report doesn´t work properly for some employeesContent - Some Employees´ goal information are not showing up in the custom BI Publisher report . - We hav…Adriana Meraz 23 views 9 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM -
Oracle Learning Cloud (OLC) OTBI Reports not pulling employee dataSummary Using OLC Subject AreaContent Hi all, I'm trying to create a report in the OLC Subject area. I've been able to pull in the Learning information, but I can't pull…User_2025-01-31-00-25-12-234 37 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extracting a field effective to specific dateContent Hi all. i'm creating an internal mobility and promotions OTBI report based on Assignment Event subject area. i'm filtering all "internal mobility" and "promotion…User_2025-01-30-20-17-38-289 53 views 5 comments 0 points Most recent by User_2025-01-30-20-17-38-289 Reporting and Analytics for HCM
-
Learning subject area is not giving dataSummary Learning subject area is not giving dataContent Hi All, 'Workforce Learning - Learning Management Real Time' subject area is not giving data, if a learner not en…Harish Kumar Kovi 62 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
All employees who had an active assignment in a time periodSummary Active Assignment within a PeriodContent I need to list all employees who had an active assignment within the last year regardless of there assignment status now…User_2025-01-28-09-44-42-254 40 views 15 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Link Report PagesContent Hi Guys, Is it possible to have the link report pages of a dashboard only in the drill down reports and not in all element of the dashboard? I hope in your answe…Giuseppe Iacono 32 views 4 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
OTBI Report formattingSummary Trying to move data around to get everything in one row.Content I am trying to make each of the phone types its own column so that everything will appear in one …Brittany Lewis 248 views 29 comments 2 points Most recent by Renuka Nuguru-Oracle Reporting and Analytics for HCM
-
OTBI reporting on expired approvals/transactions not workingSummary The delivered subject areas do not allow for 'expired' status to be reported upon.Content We have recently configured our approvals to expire after 21 days if th…Denise Rae 54 views 7 comments 0 points Most recent by Manivannan Ramar Reporting and Analytics for HCM
-
FMLA Absense Report issueSummary FMLA Absense Report issueContent We have build a report in OTBI that would total all of the FMLA Time Off Codes (US FMLA, US FMLA No Pay, US FMLA PTO, US FMLA ST…Shabber Shaik 74 views 16 comments 1 point Most recent by Shabber Shaik Reporting and Analytics for HCM -
Goal Status Report - Capture Associates With and Without Goals CreatedContent We are attempting to create a performance goal tracking report that captures associates who have created goals as well as associates who have not created a goal …User_2025-01-23-23-27-03-729 133 views 6 comments 1 point Most recent by User_2025-01-28-05-32-59-092 Reporting and Analytics for HCM