OTBI
Discussion List
-
Workforce Performance - Performance Rating Real Time is not fetching ex-employeesSummary: "Workforce Performance - Performance Rating Real Time" subject area is not showing any ex-employees when i try to see their performance document info. When i ch… -
otbi calculation only displaying whole numberSummary: Calculation is not showing the correct actual number (incl. decimals) Content (please ensure you mask any confidential information): Hi All Unless I'm doing som… -
Oracle FDI: Predictive Analytics for attritionsSummary: In FAW/FDI , any examples for predictive analytics for exit risk using HR Core subject areas? We see diversity analysis in demos but there is no catalog exists … -
Need help finding OTBI Reports in Oracle Financials. List of report names provided in Summary.Trend indicator DSO(day’s outstanding) o Average days outstanding by month Average Invoice Day’s Current Average Invoice Days Overdue Average Invoice Dollars Current Ave… -
AbsenceTimeEntryPVO - AncAbsenceType missing some valuesSummary: AbsenceTimeEntryPVO - AncAbsenceType missing some values that exists in base table HWM_TM_REP_M_ANC_ATRBS_V Content (please ensure you mask any confidential inf…Prakash Maram 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Does the oracle supports the Asset depreciation calculation based on Original cost as well?Hi Team, Business has a requirement to have the Depreciation calculated based on Current Cost as well as Original Cost so as to show them as comparison in their Annual R… -
Shipment Details To Costing JoinsHello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find a -
Query to get Requisition and Standard PO details for the respective BPASummary: Query to get Requisition and Standard PO details for the respective BPA Content (please ensure you mask any confidential information): We are developing report.… -
Is there any table which stores last email notification sent date for Requisition approvalwe need to display Last email notification date in our report so we wanted to check is there any workflow table which stores the details. we trayed to query this below t…Basavaraj Navalagi 41 views 3 comments 0 points Most recent by Basavaraj Navalagi Self Service Procurement -
Few Absence records missing for an Employee in OTBISummary: Some of the scheduled absences are not showing up in the report. We cannot find June absence record but can see August absence record for the same person. Ran t… -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 226 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sivaram Injeti 31 views 3 comments 0 points Most recent by Sivaram Injeti Reporting and Analytics for HCM -
How to Report on the Learning Initiative Start Date and Initiative Stop Date in OTBI analysisSummary: Report on Learning Initiative details , How to get fields Initiate Number/Name, Initiative Start Date and Initiative Stop on OTBI analysis using Learning Record… -
Receivables - Customer Real Time OTBI is not showing any report dataSummary: We have an OTBI report where we are using Receivables - Customer Real Time subject Area. When I run the report, its not showing any data. I have BI admin, Accou… -
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …Ruzwan Akram 487 views 10 comments 0 points Most recent by John Guner Reporting and Analytics for HCM -
Adding prompt with manager for get the entire hierarchyContent Hi, any suggestion on how to insert a prompt in a OTBI to filter the result on manager and display the direct and indirect reports. Thanks NicolaNicola Petri 74 views 12 comments 2 points Most recent by Kylie Hauenstein Reporting and Analytics for HCM -
Default values from Fusion Cloud is not showing in OTBISummary: We are using Oracle Transactional Business Intelligence (OTBI) to generate reports from Fusion PLM. However, when we attempt to generate reports for attributes … -
Default values from Fusion Cloud is not showing in OTBISummary: We are using Oracle Transactional Business Intelligence (OTBI) to generate reports from Fusion PLM. However, when we attempt to generate reports for attributes … -
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…Anton Rzhanov 41 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Differences in Assigned Learning Item Title / Duplicate Lines - Learning Records Subject AreaSummary: I've started to re-build our learning reports in the Learning Records subject area, but I'm having problems with the way the data displays. Content (required): … -
Learning Records Subject AreaSummary: This document provides an overview of Learning Records Subject Area. This document contains details of all folders and dimensions exposed in the learning record… -
Learning subject area Workforce Learning - Learning Management Real Time scheduled removalSummary: Hello, Back in 21B, Learning subject area Workforce Learning - Learning Management Real Time was scheduled for removal. Has there been any update as to when thi… -
Learning Records Real Time - Reporting on RecommendationsSummary: Trying to report on recommendations using the Learning Records Real Time subject area. It appears that a recommendation is an event which doesn't appear in the …Rob F 1 view 3 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
Can we create a custom dashboard for Managers to check all subordinates RFQ /Order detailsSummary: Can we create a custom dashboard for Managers to check all subordinates RFQ /Order details Content (please ensure you mask any confidential information): Need t… -
PPM - REST API to Extract Fusion Project data for EPBCS Integration?Summary: Dear Community, We are currently working on integrating Fusion Project Portfolio Management (PPM) data with EPM Cloud Planning (EPBCS). Please note that due to … -
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…User_2025-02-04-05-26-22-197 124 views 8 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
Maintenance Work Order Cost OTBI Subject AreaWhere can i find Subject Area for Maintenance Work Order Cost, I am using Costing Subject area but it only shows Manufacturing Work orders. Please help