OTBI
Discussion List
-
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 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 33 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 148 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 52 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.JanardhanaKondaveeti 1K views 4 comments 0 points Most recent by JanardhanaKondaveeti 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 -
Top Down Manager FieldsSummary Using parent managers but want to report from CEO down to prompt report outputsContent When using the parent managers it's difficult to query and search since te…User_2025-01-30-03-28-08-030 51 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Assignment Names for Single Learning Record in OTBISummary Dual use of Assignment Name causing Access Groups to skew reportingContent Hello, We have noticed a change in the Learning Management Real Time Subject Area to t… -
Limits on Rows Retrieved/Exported to Excel for OTBI and BI Publisher?Summary Limits on Rows Retrieved/Exported to Excel for OTBI and BI Publisher?Content Are there limits inherent with OTBI and BI Publisher as to the number of rows report…User_2025-01-25-02-53-28-953 196 views 5 comments 0 points Most recent by kmanda Reporting and Analytics for HCM -
Manager hierarchy not updatingSummary Manager changes aren't updating in the flattened hierarchy table despite the scheduled process running successfullyContent Since upgrading to 19A a couple weeks …User_2025-01-25-02-35-56-629 217 views 7 comments 2 points Most recent by User_2025-01-25-02-35-56-629 Reporting and Analytics for HCM -
create Graphs from an "analysis from simple logical sql"Summary I have a report created using "analysis from simple logical sql", and I wnat to add some graphsContent Hi, I hope you are doing well. I have created a report usi…Rogelio H 51 views 4 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Ned inputs to display reports(BIP/OTBI) to specific users/based on the rolesContent Hi All, We developed custom BIP reports as per our requirements and all the reports we placed in custom-->Human Capital Management-->Reports.Now we have a requir… -
Time and Labor OTBI Report ErrorSummary Time and Labor OTBI Report ErrorContent Hi All, I am attempting to create my first Time and Labor report in OTBI. I am currently using the subject aread Human Re…Clara 156 views 7 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Copy Oracle Standard Report as Custom ReportSummary Copy Oracle Standard Report as Custom ReportContent I am new to OTBI in cloud version and have tried to create a very simple OTBI report. However, how to copy ex…User_2025-02-04-05-26-22-197 105 views 4 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP -
Legal Entity and Payroll Current and Previous ReportSummary Looking for a report with Current and Previous Legal Entity and Payroll CodeContent Hello, We had Oracle build us a custom report that shows Current and Previous…User_2025-01-29-23-59-58-976 61 views 12 comments 0 points Most recent by Ravi Singh Reporting and Analytics for HCM -
OTBI - COA HierarchysSummary Only child level of hierarchy's are visible in OTBI - General Ledger - Balances Real Time Subject AreaContent Hello, I want to use the General Ledger - Balances … -
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…Julian Challenger-Oracle 19 views 0 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Performance Tile and Change ViewSummary Performance Tile and Change ViewContent Is it possible to create a performance tile infolet - let's say for Employee Headcount and then include a Change View sel…User_2025-02-04-10-47-55-876 60 views 2 comments 2 points Most recent by User_2025-02-04-10-47-55-876 Reporting and Analytics for HCM -
Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Summary Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Content Hi, Is there any report in Oracle cloud ERP for Foreign currency transl…User_2025-02-04-13-13-10-537 76 views 4 comments 0 points Most recent by User_2025-02-04-13-13-10-537 Reporting and Analytics for ERP