OTBI
Discussion List
-
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 45 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 45 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…
-
How is Gross Earnings Calculated on Payslip?Content Howdy, How is gross earnings calculated on payslips? I would like to use the data for a custom report but cannot locate the table or data model it comes from. Th…David Rabalais 56 views 2 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
Report of Colleagues Personal Email AddressesContent Hello, Please could someone help. I am trying to build a report to return all employees and their personal email addresses - for those that dont have personal em…User_2025-02-05-06-26-19-951 137 views 2 comments 1 point Most recent by User_2025-02-05-06-26-19-951 Reporting and Analytics for HCM -
Error when Filtering Logical SQL Report off OTBI ReportSummary Obdc Driver Error when filtering based off OTBI ReportContent Hello, I'm currently trying to filter a logical SQL changes report based off an OTBI Analysis that …User_2025-01-31-00-25-12-234 48 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Creating Report for Performance AppraisalSummary Our HR department requests a report to reflect performance appraisal for employeesContent Is it possible to get the following information below on a report. I wa…Dave Sherrard 55 views 5 comments 0 points Most recent by Dave Sherrard Reporting and Analytics for HCM -
Information on New BI Reporting Roles to Restrict BI Catalog Folder AccessSummary 19D introduced new BI reporting roles to restrict user access to the predefined BI catalog. This document is an addendum to OTBI product guide.User720640-Oracle 100 views 1 comment 6 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Security Roles Required to Create InfoletsContent Hi all, I'm trying to create infolets, but when I create a sandbox I'm not seeing the create infolet option. Does anyone know what roles are required to create t…User_2025-01-31-00-25-12-234 93 views 8 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
How to give access to OTBI report without giving job role pertaining to subject areaContent Hi, We have requirement wherein, we created custom role of HR Specialist for third party with limited access on the menu's. In the OTBI report we have two subjec…Archana Prasad 95 views 6 comments 2 points Most recent by Archana Prasad Reporting and Analytics for HCM -
Spend DataSummary Most accurate way to pull spend dataContent What is the best and most accurate way to pull a spend data from Oracle Fusion; we want to pull the overall spend usi…User_2025-02-05-20-21-38-017 49 views 1 comment 0 points Most recent by Manavalan Ethirajan Purchasing -
Leave accruals and usage by absence typeContent In our legacy system we had a report that listed, by employee, all leaves that were accrued and all absences taken, by leave type, sorted by date. Is there a rep…Annette M 64 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Add filter to analysisContent I created an analysis that prompts for a date paid. I would like to further filter the analysis using the prompted date paid and check that it is > then a start …Annette M 67 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Relative Date Filter for AgentSummary How do you put a relative date filter on an agent for an analysis?Content When creating agents for analyses, we would like to have agents that run with prompted …User_2025-02-04-06-02-17-038 56 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to Set a defoutl value in a Report with As-Of Date PromptContent Hi Guys, I have realize a Dashboard with a report with As-Of Date Prompt by adding: "SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}';" in Prefix. When I open It,…Giuseppe Iacono 46 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM