OTBI
Discussion List
-
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 42 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 95 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 555 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 53 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 498 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 495 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 32 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 73 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 24 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 53 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 -
% of Employees on Talent Review meeting w.r.t Succession PlanSummary: I am looking to calculate the % of employees on a Talent Review box those who are on Succession Plan. SO for example on the 9-Box matrix box- Future Star we hav…
-
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 45 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 64 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.4K 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 -
Concat string values in OTBI/BI AnswersSummary: Concat string values in OTBI/BI Answers Content (required): Is there a possibility to have a function like listagg for strings in OTBI/BI Answers?Yves Chassein 432 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Learning Records Real Time Report cannot add Hire Date field without rendering an errorSummary: Content (required): Since the Learning Management - Learning Real Time Assignment Subject area has been deprecated, we've been directed to use 'Learning Records…Ivy__Valverde 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OTBI and pulling yesterdaySummary: Hi All, I must admit I am pretty bad with dates in OTBI. I am attempting to build a report that will pull something entered the day before. Content (required): …User_2025-02-10-15-06-52-222 106 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM