OTBI
Discussion List
-
Need a report to get all the fast formulas in the system along with formulaSummary Need a report to get all the fast formulas in the system along with formulaContent Need a report to get all the fast formulas in the system along with formulaVer…Koteswararao Yenikepalli 46 views 8 comments 1 point Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM -
OTBI Report MigrationSummary How to migrate OTBI Reports from one company's environment to anotherContent Currently company "ABC" is using OTBI tool for analytics purpose over HCM cloud data…User_2025-02-04-22-00-05-391 46 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149 Reporting and Analytics for HCM -
Check for duplicate Position Codes using COUNTSummary Show count of position code to identify duplicatesContent Hi, I am using the Position Real Time subject area and I'm trying to determine which position codes are… -
Headcount vs. Head Count DefintionsSummary There are at least 14 different headcount presentation columns in OTBI - when do you use whichContent I am new to OTBI and trying to understand when one would us…User_2025-02-04-10-47-55-876 134 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…Yaniv 67 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Custom Subject Area Content in Analysis / DashboardsSummary Receives errors when sharing an analysisContent So I built some analysis by using some custom subject content areas, i.e. Regions built from multiple locations. …Deb Luisi 55 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Payroll balance values through OTBIContent Hi All, We created custom balances in the application. We have a requirement to display custom balances and standard balances like (Gross Pay..etc) values throug…User_6I33I 181 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
OTBI Report for employeeSummary Unable to see employee's location in OTBI reportContent Hi We have created an OTBI analysis report containing empoyee's legal employer & work location (XML Attac…Mohit Gupta-45440 76 views 2 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
OTBI custom datesSummary Custom Dates in OTBI reportingContent Hi All, I want to display custom date ranges in OTBI and the corresponding headcounts for the dates. As of now, I am able t…SuryaMuralidharan 58 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Oracle Report Jam at Collaborate 2019: Here to Build Your Reporting ConfidenceSummary April 8-10 2019, San Antonio TXContent Come and meet reporting experts from across Oracle HCM product development who can build a report with you, answer your re…Gail Langendorf-Oracle 30 views 1 comment 0 points Most recent by User_V2LE8 Reporting and Analytics for HCM -
Line Manager : Unable to see Termed Managers : Role FilterSummary Line Manager is unable to see termed workersContent Hi Team, We are trying to use the seeded Line Manager Dashboards. Unfortunately our line managers are unable …G Suman 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fusion - Goals reportingSummary Goals Approval StatusContent Hello I have found an issue where within the goals section of fusion the approval status is showing as pending approval, but when I …Andrew Braid 182 views 9 comments 0 points Most recent by User_2025-01-30-21-43-17-989 Reporting and Analytics for HCM -
How to hide Oracle HCM Seeded Report FoldersSummary Hide Oracle HCM Seeded Report FoldersContent Hello Everyone, Does anyone know how to hide Oracle HCM Seeded Report Folders? Attached is the screen-print for refe…
-
Oracle Gateway Error in OTBISummary Oracle Gateway Error in OTBIContent Hi Team, In our OTBI reports, we are getting the below gateway error Error View Display Error Odbc driver returned an error (…Harish Kumar Kovi 46 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Cant see reports saved in My FoldersSummary Cant see reports saved in My FoldersContent User has same roles and OBI privileges as me. When i save any personal analysis reports to My Folders i can see them …Junade Shujaat-143572 46 views 3 comments 0 points Most recent by Junade Shujaat-143572 Reporting and Analytics for HCM
-
HR Specialists building reports with OTBI ? Looking for an HCM cloud customer referenceSummary Looking for HCM cloud customers who would have opened the possibility to build reports outside of a dedicated HRIS / reporting teamContent Hello, We at SGS have …User_2025-01-24-00-45-17-758 89 views 3 comments 0 points Most recent by Paola Rodrigo Reporting and Analytics for HCM
-
Goal Setting StatusContent We need to create an analysis to capture the employee/ manager task status for the set goals. I have created one with the basis of Performance Task Real Time sub…Ayesha Thilakarathna 30 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Error when consulting a report with parameters of start date and end dateSummary Error when consulting a report with parameters of start date and end dateContent Hi everyone, I have created a report that must show information according to two…Cesar Tepetla Corte 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Finding the Right User for AgentContent Hi all - I am creating an agent to send a report to a user. When I go into the Select User screen and search users, there are times where more than one option co…Prudence K 34 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Individual record for Absence Data for EmployeesSummary Using OTBI subject Areas to fetch absence detailsContent Hello All, I need to create an analysis where I am reporting on Direct Reports who have absences. What d…Vibha Pandey - Oracle 81 views 8 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
CEO - Historic DataSummary CEO - Historic Reporting IssueContent Hello We have setup infolets in our environment for 5 Year Historic Trends (IE Turnover/Gender Distribution/Etc.). When our…
-
Row numberContent Hi How to display row number in BI Answers , I am using Rank function but if any duplicate values comes then it does not gives me correct values. Thanks RajeshUser_7836 55 views 3 comments 1 point Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM
-
How to embed a OTBI Report in the landing pageSummary How to embed a OTBI Report in the landing pageContent How to embed a OTBI Report in the landing page - Need to access the OTBI Report from Landing page directly …C.R.Balaji 165 views 3 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM -
Going to Collaborate 19 conference? Want reporting help?Summary April 8-10 2019, San Antonio TXContent Come to the Report Jam room (305) and meet Oracle HCM Product Development who can help you with your reporting needs. Cont…Julian Challenger-Oracle 22 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Seated Line Manager Dashboard : Unable to see Termination (Hierarchy)Summary Line Manager is unable to see his/her TermsContent Hi There, We are working on using the Seated Line Manager Dashboard (Shared Folder --> Human Capital Managemen…G Suman 100 views 16 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Manager HierarchyContent Hi , Iam trying to create a employee hierarchy report (display complete employee hierarchy in a single row) using "Parent Manager" . Iam getting a lot of blank e…User_2025-01-25-02-10-14-549 123 views 17 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 123 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 67 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