OTBI
Discussion List
-
Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Summary Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Content p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helveti…User_2025-02-04-20-58-40-814 45 views 1 comment 0 points Most recent by User_2025-01-28-06-00-33-387 Reporting and Analytics for ERP -
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 45 views 3 comments 1 point Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP -
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
-
Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataSummary Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataContent Expenses - Expense Transactions Real Time Subject Area di…User_2025-02-03-21-08-45-135 131 views 2 comments 0 points Most recent by Ramesh Nayak Reporting and Analytics for ERP
-
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 100 views 4 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP
-
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 …
-
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 66 views 4 comments 0 points Most recent by User_2025-02-04-13-13-10-537 Reporting and Analytics for ERP
-
OTBI - To Display Sum of a column based on other column in New ColumnSummary OTBI - To Display Sum of a column based on other column in New ColumnContent Hi, I want to Display Sum of a column based on other column in New Column in OTBI An…User_2025-02-03-21-08-45-135 1K views 8 comments 1 point Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…User720640-Oracle 134 views 6 comments 3 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
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
-
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 34 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142 Reporting and Analytics for ERP
-
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 -
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 22 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 39 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 53 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 69 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 258 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 106 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 60 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 66 views 1 comment 3 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
How to hide the reports icon from the vertical bar on the performance documentContent Hi, We have created a couple of dashboards using performance real time subject areas. Have personalized the home page to provide the link for these dashboards. T…User_2025-01-25-04-45-27-732 49 views 3 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Project Portfolio Management Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Rohan Lobo-Oracle 137 views 3 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Project Portfolio Management Cloud OTBI Release 11: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Rohan Lobo-Oracle 54 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
Supply Chain Management Reporting and Analytics Subject AreasSummary Overview of key business questions addressed in SCM Subject AreasTu Lam 59 views 1 comment 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
OTBI - Combining gl segments values with Suject areasSummary Problems whenusing the Real Time Subject Areas combining with the tree hierarchy for GL ValuesContent My customer is trying to build an OTBI report using the Rea…User_2025-01-28-07-58-18-982 98 views 7 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
OTBI Report for Change Order Status and StageSummary This report highlights the complete/inprogress/termination statuses of the Change Orders in Project Execution.Content Summary: This report shows the Change Order…Ruth Beberman Frost 191 views 1 comment 4 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
OTBI Reporting for Project Portfolio Management (PPM) Cloud - Tips and TechniquesSummary The white paper addresses frequently asked questions in OTBI reporting for Project Portfolio Management (PPM) Cloud. It also includes tips to enhance report perf…Rohan Lobo-Oracle 146 views 2 comments 5 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
ERP - LAG / AGING reportSummary I need to create a LAG / Aging report and was hoping there's a report I could use as a starter.Content Not sure how the forums work as it's my first time here. A…User_5F4G3 51 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP