OTBI
Discussion List
-
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by rowDebbie Herbert 65 views 2 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP -
Password protection for OTBI Agent Analysis outputsSummary Excel output sent by emailContent Hi Team, We have some OTBI Agents that run analysis and send Excel output as attachments via email to users. We have a complian…Alvaro Couto 64 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Scheduling or Sharing a DashboardSummary Would like to schedule a dashboard and/or shareContent I have a dashboard with many tabs, would LOVE to schedule so I don't have to teach navigation, however, th…Deb Luisi 178 views 7 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
Changes to Payroll Run Results Real Time?Summary No longer pulling in payments on terminated employeesContent Hi all, We have used the Payroll Run Results Real Time subject area to pull element-level transactio…User_2025-01-31-00-36-50-198 59 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Parameterised Dates in OTBISummary Need to get Tax year start and end dates relative to current dateContent I need to get the UK tax year start date (April 6th) applicable to current date, the rep…User_2025-02-04-16-50-19-277 80 views 5 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…User_KNIL2 67 views 2 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Line Mgrs Unable to View Term DataSummary Has anyone created a report or dashabord with term data and the line mgr can see this data?Content I've created a dashboard that will allow managers to view Head…User_2025-01-25-00-37-41-739 118 views 26 comments 0 points Most recent by Orange Reporting and Analytics for HCM
-
Workforce Trend Real Time Subject area not WorkingSummary Incorrect numbers in data and don't know how to correctContent Hi, I am using the subject area Workforce Management - Workforce Real Time as I want to produce a …User_2025-01-29-21-02-12-466 122 views 11 comments 0 points Most recent by Orange Reporting and Analytics for HCM
-
R13 HCM OTBI subject area description documentationSummary This spreadsheet provides R13 HCM OTBI subject area description documentationContent This documentation is published by Oracle OTBI development. This document pr…Raghavendra Raghunath-Oracle 1.5K views 19 comments 22 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
How to get R13: Oracle HCM Cloud - Subject Area DocumentationContent Hi, Got the Oracle HCM Cloud - Subject Area Documentation from the link 'https://www.oracle.com/technetwork/documentation/otbi-hcm-2225528.html' and these for Re…Janardhana Kondaveeti 75 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…User_2025-02-01-06-21-55-603 44 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142 Reporting and Analytics for ERP
-
Using Contains in a Custom ColumnContent Hello, Does anyone have any experience using a contains function in a custom column? I'm working on a Benefits report that returns both Employer and Employee cos…User_2025-01-31-00-25-12-234 28 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Analysis & Query - for PRs history or apprvoal levelSummary Need to develop analysis to see the approval status and history of certiain PRContent Hi, I am trying to get the catalog or query to develop the analysis and rep…Farooq Syed, CPA, PMP, CISA 66 views 3 comments 2 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for SCM -
Debtors / Supplier's view at consolidated level (Across Ledgers)Summary Debtors / Supplier's view at consolidated level (Across Ledgers)Content Hi, If I have a "supplier" with whom my organization is trading across BU and across Ledg…User_2025-02-04-13-13-10-537 21 views 2 comments 0 points Most recent by User_2025-02-04-13-13-10-537 Reporting and Analytics for ERP
-
Issue seeing requisitioner details in procurement subject areaSummary Financial users are unable to see requisitioner names for purchase ordersContent I am hoping someone can please advise in regards to this issue, we have a report…User_2025-01-25-03-43-51-028 48 views 3 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…Manish Gianani 63 views 1 comment 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
OTBI MobileSummary Documentation for best practice OTBI moblieContent Is there documentation for best practices for OTBI mobile? Should I use Oracle Business Intelligence Mobile or…Paul Milsom-Oracle 80 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Filtering Issue on Data ModelSummary The results of the data model are not being filteredContent we are trying to create a simple data model with a variable. But the data is not being filtered as pe…User_2025-01-28-23-51-09-951 79 views 12 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
OTBI Report: Issue Aging AnalysisSummary PMOs, Project managers and stakeholders want to view their issues and due dates in a summary compressed view initially and then have the ability to drill down to…John Sims 266 views 1 comment 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Role Customization to view Procurement and Finance AnalysisSummary Role Customization to view Procurement and Finance AnalysisContent Hi All, We have a requirement where Procurement Team will be accessing (only view) customized …Vikram Agarwal-43618 105 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs…Aaron Leggett 71 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
eText Header RecordSummary I need to create a header record in an fixed position eText Template.Content I need to create a header record in an fixed position eText Template. Which contains…User_2025-01-28-20-26-08-493 49 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
OTBI on delegated authoritySummary I require an OTBI report to display the users who have set up a delegated approval (for OTL, Requisitions etc), when they created and who they delegated their ap…Lukas Oleksiak 76 views 1 comment 3 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP