OTBI
Discussion List
-
How to add "Year" ,"Start Date" and "End Date" as prompt parameter in BI analysisSummary How to add "Year" ,"Start Date" and "End Date" as prompt parameterContent Hi. I am having one requirement in absence management where need to fetch the absence t…Rahul Mishra-19235 131 views 4 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
How to get the Person Number for WHO Columns Like Salary Last Updated BySummary How to get the Person Number for WHO Columns Like Salary Last Updated ByContent Hello Everyone, I am looking to get the person number for the WHO columns like Sa…Harish Kumar Kovi 48 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Person Profile Report - Reduce Number of RowsSummary How can we combine the row data per employee?Content We have a requirement for a report which HR can use to view employee's person profile data: certifications, …Gabrielle Ungaro 66 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Currently I am using SQL Results option to populate value of a dashboard prompt called "Global Job Band".I am using below SQL code for this : Select SUBSTR ("Gra…User_2025-02-04-22-00-05-391 46 views 2 comments 1 point Most recent by User_2025-02-04-22-00-05-391 Reporting and Analytics for HCM -
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 60 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 596 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 63 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 -
Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataSummary Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataContent Expenses - Expense Transactions Real Time Subject Area di…User_2025-02-03-21-08-45-135 138 views 2 comments 0 points Most recent by Ramesh Nayak Reporting and Analytics for ERP
-
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 282 views 1 comment 10 points Most recent by Bejoylin Reporting and Analytics for HCM -
Restricting access to Factory Content Folders within Shared Folder for Employee roleContent Hi All, We need to restrict view of seeded folders within Shared Folders but it is giving error as 'The seeded content are locked as part of the factory content …User_2025-02-03-22-11-47-765 47 views 0 comments 0 points Most recent by User_2025-02-03-22-11-47-765 Taleo Learn
-
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
-
OTBI report to fetchSummary Report to extract Content I am trying to pull a report for e employees where the net payment is -
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 103 views 6 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM