OTBI
Discussion List
-
How do we design action links to navigate to a web page related to that record in HCM?Summary: I would like to be be able to create Action Links in Oracle BI Analysis reports that allow the user to click and then be taken to the record that is being repor…Len M. 25 views 4 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
21B - DFFs not populating in OTBIContent We recently added some DFF's to our health and safety module and I'm able to find them in the correct subject area but when I look at the results there's no data… -
Dashboard in Default collapsed modeContent Have any one tried using Dashboard for hosting the links of reports? Is there a setting available to open the dashboard with collapsed sections? We can see the s… -
Subject Areas for Work SchedulesSummary Our clients requirement is to create on the ratio of Planned/Scheduled Hours vs Actual Hours.Content Dear Experts, Our clients requirement is to create on the ra… -
Combining two analysisHi Team, Can we combine two or more analysis (columns are same for all analysis) results in a single report? Thanks.
-
Position FTE Over Under - hr_all_positions_f_VL linked to position_fte_sum via position_idSummary: Content (required): We have a data model that was created by a third party and they are linking to HR_ALL_POSITIONS_F to get details on overunder FTE counts. It…Annette M 41 views 13 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Amalgamated Absence DaysSummary: My report is totalling the absence days for all absences of the same reason name and displaying that total on each line of absence in the report. I need it to d…Dawn Cawston - CPS 11 views 6 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Pictorial Representation of Organization TreeSummary: Pictorial Representation of Organization Hierarchy Content (required): HI Team, How we can create Pictorial Representation of Organization tree. Need to display…Reddykrishna Chidella-Oracle 71 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…User_VR8E0 57 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 104 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…Mike Borghoff 51 views 3 comments 1 point Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Drill down reportSummary: Drill down report Content (required): I have created analysis with two columns as department and head count, I have created action link on headcount column whic…Reddykrishna Chidella-Oracle 21 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
How to show all organization/department levels in hierarchical tableSummary: I'm trying to build an analysis showing all departments in each legal entity but only get departments that have employees connected to them. Content (required):…Matti Bugge 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Adding a column that calculates the % based on absolute numbersSummary: Content (required): Hi there I am sure this must be fairly simple but ... I have a report with pie chart for people completed, not started and in progress for L…Bobby Jourdan 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Seniority Date values are not available in OTBISummary Seniority Date values are not available in OTBIContent Hi Team, Seniority Date values are not available in OTBI, Workforce Management Assignment Real Time and Ev…User_2025-02-06-10-22-06-460 235 views 6 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 11 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Report on Employees on Leave during a certain time periodContent Hello - We are trying to find a way to report on employees who were/are on a leave of absence during any given time frame. The issue we are having is that there …Shanna Oppenheim 72 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filter out a double entry and leave only one entry in Person Profile Real Time subject areaSummary: Filter out a double entry and leave only one entry in Person Profile Real Time subject area Content (required): Hi there, We have a report that lists all the va…Bobby Jourdan 11 views 4 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
OTBI Column decodeHi In OTBI report , we need to decode the column value , like if column value is 'ABC' the we need to decode the it 'BCD', how can we do this please? Thanks
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 1 view 2 comments 1 point Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
Not able to view entire data in assignment and performance related subject areaSummary: I am using performance document status Real time/worker assignment real time subject areas but in the respective subject area I am able to see only my record. I…Kamini Kaushik-Oracle 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Not able to view entire employees details in Subject area only able to view own recordSummary: I am using Assignment and performance related subject area to fetch details of employee but when I am using my subject area it is only displaying only my data. …Kamini Kaushik-Oracle 107 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on Guided Learning UsageContent Hello, This might be a long shot, but our business is trying to report on how often employee's are using guided learning. Are there any tables that store the usa…User_2025-01-31-00-25-12-234 26 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 21 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Accessing OTBI analysis using a linkSummary: Just like we can access the BI report using the link to the report where we can use _xmode to hide all the BI page buttons. Can we also access OTBI analysis usi…Abhishek Nigam 51 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Applying filter for the analysis report with in the dashboard.Summary: Content (required): Currently we are building a dashboard with number of analysis/reports on Headcount using 'Workforce Management - Workforce Trend Real Time' …Su Ma 51 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Position/Incumbent Report - by FTEContent I am trying to create an analysis that lists the current active positions, by department, the position FTE and all employees assigned to the position and their F…Annette M 575 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extract the Report Name and Description (Audit Report)Summary: Extract the Report Name and Description (Audit Report) Content (required): Hi Team, We have requirement to export all the report name, report path and report de…[Deleted User] 11 views 4 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Recruiting - Need to show Offers made that were Declined and the reason givenSummary: Does anyone have a report or dashboard built that will return this? The business needs to review the reasons given for recruiting offers made to candidates that…Rich R 11 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM