OTBI
Discussion List
-
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 607 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP -
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 19 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP
-
Person data reporting with Financial only implementationSummary We need to do Person data reporting can we use Workforce Management - Person Real Time OTBI subject area on a finance only implementationContent We are currently… -
What is best practice for Functional Designs for OTBI Reports for support purposesSummary What design documents if any are you creating for OTBI reports created by power users for support purposesContent We are in the middle of a cloud implementation …
-
OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…Swaroop Mitta 162 views 2 comments 1 point Most recent by Renuka Nuguru-Oracle Reporting and Analytics for ERP -
OTBI Reports MigrationSummary OTBI Reports Migration StrategyContent Hi, Do we have any DevOps approach in migrating OTBI Reports like catalog,datamodel and template from one environment to t…Sujan Gutha 90 views 17 comments 0 points Most recent by amy hardtke Reporting and Analytics for ERP -
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
How to fix table position at the bottom of my pageSummary Need to fix table position at the bottom of my last pageContent Hello, I have a requirement to fix a table at the bottom of my last page. I have managed to get t…Nalinee Uppiah 54 views 7 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP
-
Which roles to use to secure custom OTBI ObjectsSummary In Otbi I see job roles, Duty Roles and Privileges what should I use to secure custom content in OTBI catalogContent All, When setting up custom folders in OTBI …
-
OTBI Report Suppress option and excel filters issueSummary When the columns are merged in suppress mode, Filters don't work properly in excelContent Hi, We created an OTBI report with suppress checkbox enabled for all th…Vinod Kumar Mohanraj 34 views 1 comment 1 point Most recent by Ahmed Mousa Reporting and Analytics for ERP
-
Is there a way to see the date a Project Forecast was created?Summary Is there a way to see the date a Project Forecast was created?Content I'm trying to find project forecasts created between a specific date range regardless of th…
-
Project Number is still seeing wrongSummary I changed project number in the system. I am seeing old number for the project in analyticsContent Hi Dear All, We are using an Analytics using Procurement - Pur…User_2025-02-05-02-38-04-251 46 views 1 comment 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP
-
Different PR - PO Matched in AnalyticsSummary for one pr has multiple po one of them cancelled the other one closed but i saw cancelled one. I cannot reach the closed oneContent Hi Dear All, We had a PR and …User_2025-02-05-02-38-04-251 13 views 0 comments 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP
-
R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 694 views 8 comments 4 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Custom OTBI content that we did not createSummary Why is there report objects under custom folder after install of OTBI that we did not createContent After our new POD was brought up I went into OTBI and I'm fin…
-
Competency ReportSummary developing a competency report using otbiContent Dear All, Which work area is suitable to create a report to check the competency name, the target competency, th…Michael Nega Gebrehawariyat 41 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Enable prompt auto completion for OTBI Analysis and BI Publisher reportsContent Dashboard, analysis and BI Publisher prompts should have auto completion available and enable by default. This feature is not available at all at the moment. Thi…User_2025-03-07-20-48-43-319 23 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
Pivot self-assessed tax amount from a column to a row in an OTBI ReportSummary Pivot self-assessed tax amount from a column to a row in an OTBI ReportContent Currently, we have an OTBI report using the subject area “Payables Invoices – Tran…James Cusson 35 views 0 comments 0 points Most recent by James Cusson Reporting and Analytics for ERP
-
ce_available_transactions_vSummary Recreate ce_available_transactions_v in OACContent Hello all I'm trying to recreate 'ce_available_transactions_v ' in Oracle Analytics Cloud (either via replicat…Elisa Fernandez 52 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to get Projects Cross Subject Area Analysis to show projects both with and without Billed AccounSummary How to get Projects Cross Subject Area Analysis to show projects both with and without Billed Account NameContent I have created a simple analysis using Projects…
-
Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g…Jennifer Wolfe 35 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Query to retreive Custom BI Report details in CloudSummary Query to retreive Custom BI Report details in CloudContent Hi Team, Which table will give the information of the custom BI Reports created in Oracle ERP Cloud? T…Abhilash K - Deloitte USI 599 views 7 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for ERP -
generating more than 75k record in OTBISummary generating more than 75k record in OTBIContent Is it possible to exceed the limit of 75k records in OTBI by importing an OTBI report as a data model in BI? Versi…Michael Nega Gebrehawariyat 694 views 1 comment 1 point Most recent by User_U9AJD Reporting and Analytics for ERP
-
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Risk Management Result Summary ExtractSummary For a specified control, list common result attributes you would find in both Advanced Access Controls and Advanced Financial Controls.Content * Download the zip…Stephanie Golly-Oracle 97 views 2 comments 3 points Most recent by Feras Ahmad Reporting and Analytics for ERP -
Risk Management Access Point ReportSummary A list of control violations by access point.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example of the …Stephanie Golly-Oracle 71 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Global Conditions ReportSummary A listing of global conditions including the filter definitions.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and …Stephanie Golly-Oracle 58 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Users with Access Violations by Control ReportSummary Lists users that have violated a specified control.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example o…Stephanie Golly-Oracle 127 views 1 comment 2 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP