OTBI
Discussion List
-
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 59 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 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 166 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 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 597 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM