OTBI
Discussion List
-
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat… -
Organization HeadcountSummary Provides the headcount of the organization hierarchy based on input organization nameContent This analyses displays a total of 5 levels of organization hierarchy…Raghavendra Raghunath-Oracle 115 views 2 comments 3 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Creating DashboardsSummary Looking for training materials for creating dashboardsContent Hi, I found the below image on the Getting Started with HCM Cloud Usability learning module and my …User_2025-02-06-13-59-03-061 80 views 4 comments 0 points Most recent by User_2025-02-06-13-59-03-061 Reporting and Analytics for HCM -
Error while restricting employee role to access OTBI foldersSummary Employee is seeing all folders and subject areasContent Issue: Employee's data access is in place to view own record. However, when employee navigates to My dash…Anuradha T 119 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom columns in Workforce CompensationSummary Custom columns in Workforce CompensationContent I am trying to build a report from subject area Compensation - Workforce Compensation Real Time to report on one …Emily Robinson 67 views 3 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM -
OTBI Outer Join giving errorContent Hi I am getting an error when running the following SQl for an outer join. I need to pull all active employees and their rating. I need to show all actives so I …Mike Borghoff 62 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Participant feedback questionnaire reportContent Hi, I am not able to pull a report for participant feedback questionnaire. Can someone help? Regards, Nivya Version 19CNivya Mathire 93 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Audit - Eliminated in 20ASummary Could we possibly get some help with creating the new version of the reportContent Hi all As many will know there was some Oracle communication surrounding the e…Tony Roff 71 views 4 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Data from analysis to be returned as CSV when issuing a SOAP requestContent Hi, I have a SOAP request in PHP as follows: /shared/Custom/Digital/MyResources/HCM_DATA… -
SOAP Request for AnalysisContent Hi, So we have a working SOAP request for a XDO -
Roles for Workforce Management - Worker Assignment Real Time Subject AreaContent Hi, We have a test and production environment where a user resides. I have an analysis that looks at the subject area: "Workforce Management - Worker Assignment … -
Stacked bar chart also with separate barsSummary Stacked bar chart also with separate barsContent I created a bar chart that displays election counts for each year by the day I would like to include Enrollment …User_2025-01-23-21-24-21-434 48 views 1 comment 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
"Errors" tab is getting generated automatically in excel sheetSummary "Errors" tab is getting generated automatically in excel sheetContent Hello Team, We developed an OTBI report, when we tried to export the report into excel shee…Harish Kumar Kovi 24 views 2 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM -
Social wall ContentSummary Report on Social conversationContent Hi, I can see we have social wall which can be enabled to be used in difference places in the system. The user can have conv…Prateek Parasar - GTUK, ACE Pro 25 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Filter out multiple resultsSummary Nationality field - can I rank it?Content Hi, I have a report that I am using for Brexit. I'm now under pressure to try and make it slicker. I'm wondering if any…User_2025-02-05-15-09-04-091 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Download Report FormulasContent Hi all - we have a requirement to do a lot of calculations within a compensation/reward report. One of the fields is the bonus estimate EX: Salary column X Incen… -
OTBI Analysis - Early Leavers (Issue with Arithmetic functions on flex field)Summary Facing issue while applying Functions on Custom field in OTBIContent Hello, We have 1 requirement for an analysis that will give separation count of associates w…User_2025-02-05-07-43-29-505 29 views 8 comments 0 points Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
Seeded 'Line Manager Dashboard' - Deprecated since 19b onwards?Content Hello, I just heard from Oracle through one of the issue SR that the seeded 'Line Manager Dashboard' has been deprecated since 19b onwards. Is that true? Any alt…SantoshKumarBhairi 42 views 4 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Standard KPIs - Languages IssuesSummary Standard KPIs - Languages IssuesContent Hello, Can anyone please help me? One of the KPI (built using Performance Tile) renders the results when the language is …SantoshKumarBhairi 23 views 11 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI - Manager History ReportSummary Present and Past report(s) for a particular managerContent Hello All, I am looking for a Manager History report. Requirement is : If we give manager name as prom…User_2025-02-05-07-43-29-505 61 views 11 comments 0 points Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
Expenses Overview Real Time subject areaSummary A summarization program needs to be run to gather information before data is available in this area.Content We are creating some test reports from the Expenses O… -
Edit Seeded Payroll Extract ReportSummary We want to edit the standard HCM Payroll Extract report to add fields to show who updated the dataContent Hi We want to edit the standard HCM Payroll Extract rep…User_2025-02-04-18-05-12-528 44 views 3 comments 0 points Most recent by Michael Cook Reporting and Analytics for HCM -
Recreate BI Answers Direct Database Query reports using the OTBI subject areasSummary What is Direct Database Query Reports? Is this Datamodel OTBI? or what exactly?Content I received this email from Oracle and I want to know what's Direct Databas…User_2025-02-05-15-05-03-822 82 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Reports based on SaaS extensions built in PaaSSummary How to created reports consolidating data from JCS-SX and ERP CloudContent Does any one have a documentation or experience on what's is the best way to achive th…