OTBI
Discussion List
-
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 45 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
-
Error while creating Prompt using free SQLSummary I am trying to create prompt for Learning Item name using "Workforce Learning - Learning Management Real Time" subject area. I want to filter active courses andC…
-
TODATE Function not working in 'Budgetary Control - Balances Real Time')Summary TODATE Function not working as expected in mentioned SAContent When using the TODATE() Function in Subject Area 'Budgetary Control - Balances Real Time' an error…Walter de Wit 58 views 3 comments 1 point Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
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 -
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 46 views 1 comment 2 points Most recent by User_2025-02-04-07-16-12-621 Reporting and Analytics for SCM
-
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 -
Oracle BI NotificationSummary How can the long string email address be changed?Content Hello Are Oracle seeking client input into improving the standard notifaction and alert template email t…User_2025-02-04-12-09-19-581 60 views 9 comments 0 points Most recent by User_2025-02-04-12-09-19-581 Learning
-
OTBI GL Balances with DFFSummary DFF shows in Subject Area but when selected, Balances will not displayContent We have a DFF on the Cost Center Segment. When that DFF is added from the Cost Cent…PLW 74 views 3 comments 0 points Most recent by User_2025-02-04-20-58-40-814 Reporting and Analytics for ERP
-
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 82 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 167 views 3 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA, TOGAF 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 101 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 133 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 47 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