OTBI
Discussion List
-
Document of Record ReportingSummary Document of Record ReportingContent As HR we are trying to report off the Workforce Management - Document of Record Real Time to look at employees and try and se…Matthew DeCilio 90 views 10 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Reg OTBI CountHi we are have OTBI report which gives the count of enrollment for each plan , for some of the plan no emp is enrolled ,in the report we are not getting this plan detail…User_7836 31 views 10 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 171 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 Reporting and Analytics for HCM -
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. 31 views 4 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Mass Add Additional Source InformationSummary Mass Add Additional Source InformationContent Hi All, we have recently migrated to Oracle Cloud and as part of the data conversion from our legacy system to Orac…
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …Remi Grégoire-Jacques 21 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
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…Mike_McGrath 47 views 6 comments 1 point Most recent by Mohan Murali Reporting and Analytics for HCM -
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.
-
Redirecting users to core module through OTBI dashboard clickSummary: Redirecting users to core module through OTBI dashboard click Content (required): In the core ERP system, we have these infolets with one functionality that wou…Leandro Vasconcelos 11 views 1 comment 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Order Management -
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 51 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 -
Default Revenue account for Credit Memo lines not defaulting correctlyContent Hi Would like to kindly seek help as when we are creating a credit memo, the default revenue account combination is not exactly defaulting as some of its segment…User_2025-02-11-12-30-38-982 41 views 2 comments 0 points Most recent by User_2025-02-05-00-10-05-674 Receivables & Collections
-
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 -
ERP - OTBI Advanced Features event on Sep 22th 9am Pacific TimeSummary: After the record interest from this community on the previous OTBI event 'ERP - OTBI Made Easy' in May, and several requests for an advanced session, we decided…Maria Centeno-Cloud ERP-Oracle 51 views 1 comment 0 points Most recent by Aaron Tanek Reporting and Analytics for ERP
-
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 103 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 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM