OTBI
Discussion List
-
Multiple Rows to Columns, from different FieldSummary Conver multiple rows into columns where the rows are generated by more than one fieldContent HI I want to convert multiple columns to rows, I'm trying to use piv…Rogelio H 62 views 2 comments 0 points Most recent by Gabrielle Ungaro Reporting and Analytics for HCM -
Extract all values from Person Profile Content Type in single cellSummary I want the entire contents of an employee's "Skills / Areas of Expertise" in one cellContent Hello I'm looking for a way to combine everything an employee entere…User_2025-01-28-08-47-04-905 90 views 1 comment 0 points Most recent by Gabrielle Ungaro Reporting and Analytics for HCM -
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 587 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need OTBI RpdSummary Need OTBI RpdContent Hi , I believe if we install BI Apps (OBIA) we can get RPD which has OTBI subject areas. Can some share OBIA/OTBI Rpd. I am mainly looking f…User_2025-01-29-21-55-25-526 38 views 5 comments 1 point Most recent by User_2025-01-29-21-55-25-526 Reporting and Analytics for HCM
-
Case expressionSummary Case expression not returning right resultsContent Hi, when I put the following Case statement, I do not get the right number in the "ELSE" statement. It is far …Mike Borghoff 85 views 14 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaSummary Documentation / Details about "Workforce Management - Absence Calendar Real Time" Subject AreaContent Hi Experts, Wondering if there is some documentation around…AshishERPCloud 55 views 8 comments 1 point Most recent by Ashly Lee Gonzalez Gonzalez Reporting and Analytics for HCM -
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a…User_2025-01-29-01-35-20-045 61 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI - Historical Point in Time Assignment and ManagerSummary Report when using Assignment Event Details can't export resultsContent We originally created a historical report using the assignment details effective start and…User_2025-01-30-03-28-08-030 69 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle Report Jam at Collaborate 2019Summary Here to Build Your Reporting ConfidenceContent April 8-10 2019, San Antonio TXCome and meet reporting experts from across Oracle HCM product development who can …Julian Challenger-Oracle 29 views 0 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Filtered by Team OTBI analyticSummary Looking to report on columns of data from the Direct Reports line in Manage BudgetContent We are using top down budgeting method for one of our plans. Using the …User_2025-01-22-18-30-18-571 36 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Duplicate Rows in a ReportContent Hi All, Hoping someone can assist me - I'm getting duplicate rows in a report and it seems to be tied to FLSA status as I have one row with a value and one row w…
-
Need a report on Bell Curve & PMS distribution manager wise, department wise and Compensation Plan wSummary Need a report on Bell Curve & PMS distribution manager wise, department wise and Compensation Plan wiseContent Dear All, Need a report on Bell Curve & PMS distri…Bejoylin 53 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting on Accrual BalanceSummary This document provides a brief overview of the employee accrual balance metric and the corresponding analyses.Content Customers often ask if the projected accrua…Raghavendra Raghunath-Oracle 271 views 1 comment 10 points Most recent by Bejoylin Reporting and Analytics for HCM -
Pass Parameters from OTBI to BI DatamodelSummary Pass Parameters/Prompts from OTBI to BI DatamodelContent I have created a OTBI Report with a presentation variable. I would need a pipe delimiter file. So I adde…User_2025-01-22-19-45-49-284 76 views 3 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Sales Incentive FlagSummary BIP and OTBI reportContent Hi Everyone, Does anyone know which Table/Subject Area is stored the Sales Incentive Flag available in Assignment Details / Job Detail…Alvaro Couto 23 views 5 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
“Top Manager” prompt removing data from outputSummary “Top Manager” prompt removing data from outputContent We have a Goal Alignment report using the "Workforce Goals - Goal Status Overview Real Time and "Workforce …User_2025-01-23-21-24-21-434 44 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Logical SQLSummary Reports created using Logical SQL are running inconsistently and have poor performanceContent Hello All, We have a report requirement where we need to display OL…Vibha Pandey - Oracle 172 views 8 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Layout in OTBIContent I have a requirement to build a report on Absence in OTBI based on the absence types. Just wanted to check if the following layout is possible. Can anyone please…Amrit 67 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Seeded Dashboard Active Processes Dashboard fetching no resultsContent The seeded dashboard: Active Processes dashboard is fetching no results. It is using the subject area: Payroll-Payroll Flows Real Time subject area. Can anyone t…Amrit 45 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Managers can see ALL employees on Goals dashboard reportsSummary Managers can see ALL employees on Goals dashboard reportsContent Help!! Managers can see ALL employees on Goals dashboard report. This is not the case on all oth…User_2025-01-28-20-43-56-568 88 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
In person HCM Cloud OTBI Workshop at Oracle Reston VAContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t…Julian Challenger-Oracle 35 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Goals of Employees as of Review PeriodSummary Performance Goals of Employees as of Review PeriodContent Hi All, We have requirement to create a OTBI Report, to get performance goals status of employees as of…Parthiban Vaithiyanathan 102 views 6 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM
-
Looking for sample Learn Dashboard and/or Infolet Reports used on the Administrator pageSummary Looking for ideas for Learn Dashboard and Infolets reportsContent What types of Learn reports do others provide on the Learning Administrator page? Thanks, KellyUser_2025-01-28-20-43-56-568 126 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Work Relationship Start Date zero'sSummary Report returning a value of 0-00-00 for Work Relationship Start DateContent Hi - We have a report where we are trying to capture all our transfers in a defined p…User_2025-02-03-23-33-26-899 34 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Report - Performance Management, Task Name for Employee/Manager RoleSummary BI Report - Performance Management, Task Name for Employee/Manager RoleContent Hi, I'm currently developing BI Report using SQL query in HCM Cloud. User requeste…Suyoung 140 views 6 comments 1 point Most recent by User_2025-01-30-23-22-56-745 Reporting and Analytics for HCM
-
Regarding Supervisor Field along with Line Manager in OTBI analysisSummary Fetching Supervisor Field from Matrix Manager Folder and Line Manager from Worker Folder in OTBI analysisContent In the current Oracle release of 19A , we observ…User_2025-02-04-18-19-50-225 53 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Trend with Colleague Real TimeSummary Calculate turnover based on Passport Type that sits within Colleague Real TimeContent Hello, I have been able to calculate turnover based on colleague gender, et…User_2025-01-28-05-32-59-092 27 views 2 comments 1 point Most recent by User_2025-01-28-05-32-59-092 Reporting and Analytics for HCM
-
Report to Extract Leave Deductions from Plan BucketsSummary BIP or OTBI Report to extract the leave deductions from Plan BucketsContent We need to extract leave deductions from the Plan buckets in the system. Suppose, an …Aahiri_Sarma 36 views 1 comment 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
How to add a sum by column value in OTBI ReportsContent Hello, We need to bring the sum by column value in OTBI Reports. Please assist.Janardhana Kondaveeti 946 views 4 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Feedback Notes Marked Manager onlyContent All, my company just implemented a process that requires a manager to input feedback notes every month. The problem is that HR cannot track it if manager marks t…Charles Egegbara 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM