OTBI
Discussion List
-
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…Walid Hamdy 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Analysis Female Successors for Critical RolesSummary: I am trying to work out #critical roles: used distinct (Plan Business Unit)- Correctly getting the count #atleast 1 female successor on these critical roles # c…
-
Identifying/Removing Duplicate rowsSummary: I am creating a report that is trying to highlight any blanks or erroneous data in our active workforce. It requires combining the following subject areas: Work…
-
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following… -
Number of Candidate Pool Members metric doesn't match with the value showed in UISummary: Content (required): Hello, We would create a simple analysis that extract the Number of Candidate Pool Members inside the different pools. We create the analysi…Giuseppe Iacono 41 views 8 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
How Time Dimension works?Summary Report with snapshots by end of monthsContent Hi Everyone, I am struggling to build an OTBI analysis that creates a monthly Head Count report. I am using "Workfo…Alvaro Couto 104 views 12 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Total on the Top of Stacked Vertical BarSummary: Total on the Top of Stacked Vertical Bar Content (required): How to add Totals on top of Stacked Vertical Bar in OTBI, Please see below image, If its possile pl… -
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…Nicolas Vahman 571 views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ORC: Tracking all the End Dates for a RequisitionSummary: Hi, Can we track & report all the end dates for a requisition if Hiring Manger changes the End Date of the Requisition? Any help with details like Tables, Repor…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Requisitions per Department ReportSummary: Content (required): Hello Guys, We would create a report that show the number of requisitions for Departments and that it also have the functionality to explain…Giuseppe Iacono 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Sox User Report - Security Roles & Privileges SA - Errors when trying to add in Department CodeSummary Sox User Report - Errors when trying to add in Department CodeContent I was asked to create a simple user report for our IT department that could be used for sox…User_2025-02-07-16-42-37-187 51 views 2 comments 0 points Most recent by Shant Sarkissian_NES Reporting and Analytics for HCM -
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 531 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM -
Waived Benefits fields in OTBISummary: I have a report that HR has requested to add if the have waived their benefits elections. Is their a field/ subject area that will store this information? I'm c…RJ Blankenship 21 views 3 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
OTBI-Report-Workforce Management - Person Real Time-Roles RequieredSummary: OTBI-Report-Workforce Management - Person Real Time-Roles Requiered to get employee information Content (required): Hello I need to get some employee and manage…Cesar Saveedra 1 view 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Viewlet: Cross Subject Area JoinSummary Steps to Create Cross Subject Area QueriesContent The below viewliet provides the details on how to create cross subject area joins using two subject areas :Eakta Aggarwal-Oracle 514 views 4 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unarchive ErrorSummary: I am unable to unarchive the BIP report to BIP and getting the below error. Tried in different browsers by clearing the cache, but still the same issue. Content…Satyanarayana M-Oracle 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Manager Filter and Direct Reports To FilterSummary Manager Filter to display the dashboard with direct and indirect reporting associates, and "Direct Reports to" filter Drive from Manager filterContent We have re…Prabhu Krishnamoorthy 71 views 8 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when …
-
'Payroll - Element Entries Real Time' subject area does not display any data for Line ManagersSummary: I have built a OTBI Report using ‘Payroll - Element Entries Real Time’ subject area for line Managers to see who has Skills Allowance. I have deployed this repo…Vijay Gorania 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way in OTBI and/or BIP to automatically push a scheduled report to SharePoint?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Nigel Wiltshire-Oracle 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Workforce Succession Management - Talent Pools Real Time Subject AreaSummary Reporting on Talent Pools through OTBIContent Has anyone had any luck reporting on Talent Pools through this subject area? I have been unable to get any results.…User_2025-01-28-08-47-04-905 34 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Need help on Logical SQL with Inner JoinSummary Need help on Logical SQL with Inner JoinContent Hi Experts, Does any one has a sample logical sql where inner join has been used.Sreedharan-Oracle 42 views 6 comments 0 points Most recent by User_2025-02-12-14-08-01-540 Reporting and Analytics for HCM -
Filters on multiple SA are not workingSummary: We are trying to create a new OTBI analysis, where we have a requirement to pull both the Worker assignment details and the person VISA details. So we used Work…
-
previous Phase/State - recruitmentSummary: Is there a way of creating a OTBI analysis to show current Phase/State and previous Phase/State Content (required): We would like to create a report which shows…Mitch_123456 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…Geraud Andreux 62 views 4 comments 0 points Most recent by Geraud Andreux Reporting and Analytics for HCM
-
General Questions on Reports Data SecuritySummary: Content (required): Also, I need to know if a user has 2 Roles: 1. HR Specialist Custom Job Role assigned to 'View all people' data security profile 2. HR Analy…Walid Hamdy 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report used in another ReportContent I have built a report that pulls a list of employee numbers based on a specific set of filters. I then have another report that pulls data based on the employees… -
Absence Attachment in Report OutputSummary Absence Attachment in Report OutputContent Hi All, I have a requirement in which i have to display absence attachment content in report output for each employee.…nitin Sharma 65 views 5 comments 2 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM
-
From where to get (table name) the value of Candidate Type When Applying field.Summary: From where to get the value of Candidate Type When Applying field.Content (required): Version (include the version you are using, if applicable): Code Snippet (…Awadhendra Tripathi 1.5K views 2 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
How to Add Sort Order to Table or GraphContent This document explains how to •Add a ‘sort order’ column to an OTBI report•Add the ‘sort order’ column to Table or Graph view•Hide the ‘sort order’ column on a P…User720640-Oracle 113 views 5 comments 10 points Most recent by Tsubasa Kokubu-Oracle Reporting and Analytics for HCM