OTBI
Discussion List
-
19B Release causing report issuesSummary OTBI Report with Location GL field is breakingContent 19B released over the weekend. Noticed that reports that have Location GL field are causing ODBC error now.…User_2025-01-28-20-43-56-568 56 views 5 comments 1 point Most recent by Linda Dunn Reporting and Analytics for HCM -
Learning Analysis Need Column for Last Job ChangeSummary Find the date the colleagues Job Title ChangedContent How do I add a field to an analysis for Learning Module that will show the correct date the colleague's Job…Dena Swanson 38 views 2 comments 0 points Most recent by Dena Swanson Reporting and Analytics for HCM -
Direct Report - OTBI Report CatalogContent Hello from Columbus, Ohio! Does anyone have a nice Direct Report with Managers and Direct Reports listed? I'm looking for an .xml catalog file that I can share i…User_2025-02-04-11-13-27-138 92 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 114 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
OTBI cross SA or SA is independentContent Hi , Can I create report in OTBI a cross SA or each SA is independent. Thanks, Rafik Beshara -
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher?Raja Mohan Ivaturi 60 views 5 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM -
OTBI Competences Gap AnalysisContent Hello everyone, I need to realize an analysis that shows the gap between workers' skills and their target value, has someone already done something similar? Or c… -
OTBI reports for Individual CompensationSummary Are we planning to launch any OTBI reports for Individual Compensation? If yes, do we have an ETA?Content We have quite a subject area for Workforce Compensation…Aparna Damle 114 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 86 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM -
Assigment History - Old Value and New ValueSummary How can we get old value and new value for Assignment History?Content Hi All, Is there any way to get old value and new value for worker's assignment changes? We…User_2025-02-04-18-26-11-309 242 views 3 comments 2 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM -
Remove formatting characters from text in Data Model reportSummary Reporting on a free-text field in a Data Model results in formatting charactersContent We have a report set up to capture employees "career statement" from Caree…User_2025-02-03-23-33-26-899 26 views 5 comments 0 points Most recent by User_2025-02-03-23-33-26-899 Reporting and Analytics for HCM -
Need subject area for cost center and companySummary Need subject area for cost center and companyContent Hi, I assign cost center and company values at department level . Now I want subject area for extract detail… -
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around…Mansur Khalil 60 views 2 comments 0 points Most recent by User_2025-02-04-06-31-44-785 Reporting and Analytics for HCM -
Couldn't Integrate a OTBI report including Project details and Project Contract DetailsSummary Can i Create an OTBI Report combining Project Details and Project Contract DetailsContent When i create new OTBI report add in it Projects details from subject a…Mohamed Attia-Allah 49 views 2 comments 0 points Most recent by Mohamed AttiaAllah-Oracle Reporting and Analytics for ERP -
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…User_2025-02-05-04-43-06-903 92 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP -
Arrange Order and Delete Fields in Data ModelContent I'm dragging and dropping to change the field order in the data model but when I go to run the export, the fields are in the exact same order. I have saved it an…Bhuangtran 33 views 3 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM -
Position hierarchy based on logged in person position in OTBISummary Position hierarchy based on logged in person position in OTBIContent Hi All, We are trying to get position hierarchy based on logged in person position. Suppose …Harish Kumar Kovi 73 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo… -
Page Composer Changes and OTBI Subject Area ImpactContent Will a change done by Page Composer, like Field Label change, get reflected on OTBI Subject Areas? For example if I change Person number to Employee ID on a page…Vibha Pandey - Oracle 40 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Exclude logged in user from indirect reportsSummary Exclude logged in user from indirect reportsContent Hi, I have a Direct and Indirect selector prompts for managers to use which displays direct and indirect empl…User_2025-01-30-03-54-32-528 47 views 9 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM -
OTBI RequirementSummary Setting a Flag By Updating Attribute Column in Invoice Header TableContent Hi, We designed a report which send notification for cancelled invoices to vendors sho…AnsumanM 40 views 5 comments 2 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Deep Link to open Payment info in view mode?Summary Deep Link to open Payment info in view mode?Content Hi, The deep links page in Fusion cloud show the following for the link to the payment https://.oraclecloud.c…Michelle Haynes 669 views 2 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Unable to report on Element Entry HistorySummary 1=2 in SQL query?Content Hello Everyone, I'm trying to use Payroll - Element Entries History Real Time and have created a simple analysis (XML attached) to see e… -
Performance Tile IsseContent I'm trying to make a performance tile with number of Assignment events using the attached XML. I've done the same with Salary events, but for some reason its not…User_2025-01-31-00-25-12-234 51 views 9 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
How to enable Notification on Learning CloudSummary How to enable Notification on Learning CloudContent 1) In OTBI under learning > Notifications, I am trying to enable deep link but it is not working. 2) How noti… -
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 242 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
Managers' DashboardsContent Hi, Where I can find existing dashboards for managers? Best Regards -
OTBI Reports - Access to ResultsSummary OTBI Reports - Access to ResultsContent Hi we have created a HR Admin where they should be able to see all employee results. But this user only has access to his…Mansur Khalil 57 views 2 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Goal Weight for Mass Assigned Goal - OTBI ReportingContent We've developed a performance goal tracking report with basic information regarding an associate's goals. When pulling in the weight of the performance goal, we …User_2025-01-23-23-27-03-729 46 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM