OTBI
Discussion List
-
R11 HCM OTBI Subject Area Mapping to Fusion HCM Database TablesSummary Release 11 HCM OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 476 views 8 comments 10 points Most recent by User720640-Oracle Reporting and Analytics for HCM -
Report Jam at OHUG OrlandoSummary June 6-8 Salon 18Content We will be running the Report Jam at OHUG (June 6-8 at Orlando) for the third year in a row. If you have a report you'd like us to build…Julian Challenger-Oracle 28 views 0 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Dasboard Prompt not workingSummary Dashboard prompt not working as required. The report does not get filtered based on prompt inputsContent Hi I have created a dashboard containing an analysis fro…Mohit Gupta-45440 140 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Management ReportSummary Performance Management Report for ManagerContent Hello, I want to create a report for Manager and insert it into my Organization tab of Performance Management. I…Giuseppe 1234 171 views 6 comments 0 points Most recent by Radhika Thiagarajan Reporting and Analytics for HCM -
Report on Development Plan from Performance FormsSummary I'm trying to report on the development plan section of the performance forms. Or removed extra rows from a report exported to excel.Content Has anyone attempted…User_2025-01-25-00-37-41-739 54 views 1 comment 0 points Most recent by Radhika Thiagarajan Reporting and Analytics for HCM -
Where can I find Hire Reason in HCM OTBI/BI Answers?Summary Looking for subject area and field name for Hire ReasonContent I am working on an HCM OTBI/BI Answers analysis and would like to report Hire Reason. Can you tell…User_2025-01-28-17-24-53-863 51 views 6 comments 1 point Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Need to get Manager Name dynamically in OTBI reportSummary Need to get Manager Name dynamically in OTBI reportContent HI All, We have a requirement need to develop a OTBI report based on the Manager i.e. if manager login…Visu 151 views 3 comments 0 points Most recent by User_2025-01-25-02-26-52-398 Reporting and Analytics for HCM
-
Issue with Equations using varying other Analysis Look-upsContent Hello, I am just wondering if anyone else has had this same issue when looking up results from any other analytics? so the query is such, I have a selection of 6…User_2025-01-28-07-12-45-467 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get rid of unwanted HTML tags from displaying in my analyses Export ?Summary How to get rid of unwanted HTML tags from displaying in my analyses Export ?Content Hi we have created a Dashboard using Goals Status real time Sbject area which…Arun Sharma 117 views 8 comments 2 points Most recent by User_2025-01-28-18-45-54-074 Reporting and Analytics for HCM
-
How to pull APR document through SQL?Summary How to pull APR document through SQL?Content We have a business requirement to pull Annual Performance Document of all employee. Oracle says there is an ER with …User_2025-01-27-23-54-00-342 37 views 3 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
Help needed - report on employees - start date when employment made permanentSummary How to create a report where I get data on dates when employees employment changed to permanentContent Hi, I need a report from employees whose employment change…User_2025-01-28-07-55-21-868 58 views 5 comments 1 point Most recent by User_2025-01-28-19-49-15-062 Reporting and Analytics for HCM
-
Oracle seeded Total Turnover Report available?Content We have delivered a custom report to show the Total Turnover for a business. This can be filtered by a number of options - ie. Date Range, Business Unit, Region,…Rebecca Smith-27468 186 views 4 comments 1 point Most recent by Rebecca Smith-27468 Reporting and Analytics for HCM
-
Filtering Between Two "TimeStampDiff" DatesContent Good Day, I was wondering if anyone has had a similar query and has also found a solution. The query is i want to search between Two Dates and for then for it to…User_2025-01-28-07-12-45-467 89 views 5 comments 0 points Most recent by User_2025-01-28-18-08-05-947 Reporting and Analytics for HCM
-
Detailed data with fields for Reports from BI apps and OTBI vs datasets obtained via catalog managerSummary Detailed reports data with fields from BI apps and OTBI similar to the one obtained via catalog manager in OBIEEContent I am looking for information on detailed …spattisa-Oracle 59 views 0 comments 3 points Most recent by spattisa-Oracle Reporting and Analytics for HCM
-
Goal DashboardSummary Goals - one Dashboard for different user/regional responsibilitiesContent Hey All, I'm wondering if you have faced the same issue like we do. Based on the "Goal …User_2025-01-23-22-38-50-675 105 views 12 comments 2 points Most recent by User_2025-01-23-22-38-50-675 Reporting and Analytics for HCM
-
Salary Change AuditSummary Is there a way to run a report to find out who entered a salary change in Manager Salary and when?Content Is there a way to run a report to find out who entered …Gala Meyerovich 228 views 4 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
Is Performance Goal Action Taken available for reporting in OTBI / BI Answers?Summary Need to report Goal Action Taken in BI AnswersContent In the subject area Workforce Goals - Goal Status Overview Real TIme, is Action Taken available for reporti…User_2025-01-28-17-24-53-863 43 views 2 comments 1 point Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Using interactions to Navigate into ModulesSummary Helping users navigate to relevant screens from analysisContent Hi, I'm trying to come up with creative ways to integrate the analysis into the Core HR modules. …Rob F 24 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Making a page to host a dashboardSummary I would like to be able to make a page that looks and feels just like the Manager DashboardContent Hello Everyone, I have a question in regards to setting up new…Nicolas Trojack-24006 124 views 4 comments 0 points Most recent by Nicolas Trojack-24006 Reporting and Analytics for HCM -
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…User_2025-01-25-04-51-10-553 44 views 4 comments 0 points Most recent by User_2025-01-25-04-51-10-553 Reporting and Analytics for HCM
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f…User_2025-01-28-07-12-45-467 132 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to pick latest salary details for a person using subject area "Compensation - Salary HistoryContent Hello All, I am having a trouble in pulling out the latest salary details for a person using "Compensation - Salary History Details Real Time" Subject area. I ca…User_2025-01-25-06-20-12-259 134 views 18 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling …Brad Hughes 105 views 4 comments 0 points Most recent by Brad Hughes Reporting and Analytics for HCM -
Manager Name using OTBI Report for a Termination Person using the Workforce Management Worker AssignContent Is is possible to get the manager name for the terminated person using the Workforce Management-Worker Assignment Event Real Time Subject Area. Currently the rep…User_2025-01-25-03-18-49-935 42 views 6 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Comments of manager for annual performance interview information in BI publisherSummary Where can I find the comments of the manager for the annual performance interview in PI publisher (fusion tables)Content Hello, Someone know where can I find in …User_I6AXL 77 views 3 comments 0 points Most recent by User_2025-01-28-09-43-13-552 Reporting and Analytics for HCM -
Performance Rating report of Overall Manager ScoreSummary Why do I need to say which section it is in to report it correctly?Content Below is my XML i had to specify the Overall Section otherwise I got completely differ…Nicolas Trojack-24006 84 views 3 comments 0 points Most recent by User_2025-01-28-09-43-13-552 Reporting and Analytics for HCM
-
Creating a simple Address report for a Business Unit/Legal EmployerSummary Trying to create an OTBI reportContent Hi, I am trying to create a simple address report i.e employee name, person number and address fields (including 'Address …Pnguyen-Oracle 104 views 3 comments 0 points Most recent by Pnguyen-Oracle Reporting and Analytics for HCM
-
Assistance - How to derive age using Date of BiirthSummary Please could someone help me....Content ...I'm tryign to build a report which shows hourly rates, split by age of employees (for national minimum wage tracking).…Kevin M Storrie 89 views 8 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Rehire Report with Termination DateSummary We need a report that includes rehires with their rehire date and termination date.Content We are trying to create a report that includes all employees who were …Karen B 291 views 2 comments 0 points Most recent by User_2025-01-28-04-09-16-818 Reporting and Analytics for HCM -
BI Security DocumentationSummary BI Security DocumentationContent Does anyone know where to find documentation regarding the security structure for BI Publisher? I would like to see the intended…User_2025-01-22-19-28-29-985 128 views 3 comments 1 point Most recent by User_2025-01-22-19-28-29-985 Reporting and Analytics for HCM