OTBI
Discussion List
-
R13 Financials OTBI subject area description documentationSummary R13 Financials OTBI subject area description documentationContent This documentation is published by Oracle OTBI development. This document provides users a func…User720640-Oracle 508 views 4 comments 8 points Most recent by User_2025-01-30-04-35-21-746 Reporting and Analytics for ERP -
Need Outstanding Purchase Order Details Report in oracle fusion R13Summary Need Outstanding Purchase Order Details Report in oracle fusion R13Content Hello All Is there any report in oracle fusion r13 to display outstanding purchase ord…User_2025-02-03-21-33-20-159 707 views 2 comments 1 point Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP -
PO Encumbrance Journal DetailsSummary PO Encumbrance Journal DetailsContent Hello All I need script to extract PO encumbrance and related journal line details in oracle fusion. Required Columns in qu…User_2025-02-03-21-33-20-159 45 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP -
Group AssetSummary Report Is nullSummary Group Assets Summary Report is not workContent Dear's i run Group Assets Summary Reports ,no result and i check data model i found attached error messageMahgoub S.Mohamed 10 views 1 comment 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP
-
Seeking Assistance Querying for Basic Transactional MetricsSummary How to get counts of journal lines, invoices, and payments per month?Content I'm hoping someone can give me a head start on how to query for the following transa… -
OTBI Security for Project Manager job roleSummary OTBI Security for Project Manager job roleContent Hi, When a person is declared Project Manager on a project, the job Role Project Manager is assigned to him/her…Xavier Cuinier 50 views 1 comment 0 points Most recent by Xavier Cuinier Reporting and Analytics for ERP -
Required User Input OTBI Prompt - Not throwing error if input value is not selectedSummary Required User Input OTBI Prompt - Not throwing error if input value is not selectedContent Required User Input OTBI Prompt - Not throwing error if input value is…User_2025-02-03-21-08-45-135 39 views 3 comments 0 points Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP -
Output to show the Prompts that the OTBI Results was run for/with Parameters.Summary Output to show the Prompts that the OTBI Results was run for/with Parameters.Content Hi All, Is there any way that we can display the Parameters that we ran for …User_2025-02-03-21-08-45-135 53 views 6 comments 1 point Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 75 views 0 comments 6 points Most recent by User720640-Oracle Reporting and Analytics for ERP -
Data for disabled segment values no longer included on reportsSummary OTBI and SmartView are not reporting historic balances for end-dated cost centresContent Hi all, We have a situation where we have end-dated a couple of cost cen… -
Custom Infolet Drill to Detail in Context of the record selectedSummary How to link a detailed report to return data in the context of the record clicked in the infoletContent I have created an analytic Supplier Holds and render as a…User_2025-01-28-03-03-10-649 51 views 0 comments 0 points Most recent by User_2025-01-28-03-03-10-649 Reporting and Analytics for ERP -
Restrict Data in OTBI Based on Specific RoleSummary Is it possible to create role based restrictions on data within OTBI?Content In Cloud ERP, I can create data access sets and value set security rules and assign …Daniel Willmott 231 views 1 comment 1 point Most recent by User_2025-01-29-23-00-32-611 Reporting and Analytics for ERP -
Transaction time in the report and in Payables Application are differentSummary Transaction time in the report and in Payables Application are differentContent Hi all, Developed a report using Payables -transactions real time subject area.In…Dev Thota 56 views 4 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Applying data restrictions for custom reportsContent Hello, We need to create some custom reports applying data restrictions. We got know that secured list views are not available for the ERP reports. Is there a wa…User_2025-01-28-21-18-43-496 57 views 2 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP -
user role security context security context value reportSummary user role security context security context value reportContent Is there a report where we can retrieve all values as shown in screen shot below?User_2025-01-28-19-49-26-512 250 views 1 comment 1 point Most recent by User_2025-01-30-20-43-00-868 Reporting and Analytics for ERP -
Column aggregates without showing measure columnsSummary Column aggregates without showing measure columnsContent Hi All, I have built a report with multiple measures. Is it possible to show only the column level aggre…Ishan B-112616 43 views 0 comments 0 points Most recent by Ishan B-112616 Reporting and Analytics for ERP -
Report Job History is blank for BI ReportSummary Report Job History is blank for BI ReportContent Hi All, We have created a simple BI Report with one data model. When users are running this report, the activity… -
Sending Email notification to users when no data is returned from BI ReportSummary Sending Email notification to users when no data is returned from BI ReportContent We have implemented OCR(Invoice scanning) functionality in R13 Fusion cloud an… -
Issue with month format to create Trend Analysis Report for Data ProgressionSummary Issue with month format to create Trend Analysis Report for Data ProgressionContent Hi All, We would like to create a dashboard to show data volume progression b… -
Select_physical * fromVO_nameSummary Select_physical only works on some VO'sContent Hi, Looking to expand the capability to search VO's using "Select_physical" on all VO's. "Select_physical * from V… -
How to filter between Accounting Period Name in GL dashboard promptSummary How to filter between "Accounting Period Name" in GL dashboard promptContent Hi, I need to use "Accounting Period Name" in "General Ledger - Journals Real Time" … -
How to set Default Rows Displayed In Download in OTBI reportContent I need to set DefaultRowsDisplayedInDownload as " 65000" for my OTBI report. Is there a way to do it ? Already referred some oracle docs but I could not able to …User_2025-01-28-21-18-43-496 82 views 5 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for ERP -
Requester field blank on OTBI report from Procure to Pay Subject AreaSummary Requester field blank on OTBI report from Procure to Pay Subject AreaContent Hi All, In R13, we built a OTBI report based on "Procure to Pay" subject area. But R… -
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 483 views 14 comments 9 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP -
Reporting on descriptive flexfields - BI Enabled checkbox not showingSummary Unable to use descriptive flexfield in OTBI - missing BI Enabled checkboxContent I need to create a new report using the Receivables - Customer Real Time subject…elenorh 183 views 2 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for ERP -
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v…Achala Munasinghe 61 views 3 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Default "Account Period Name" value in OTBI Prompt while scheduling AgentsSummary Is there a way to default Period name on the OTBI Prompt while scheduling the Analysis from Agents?Content We have an OTBIE analysis "AP Transaction Report" that…GopiKAutomus 398 views 5 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
How to update the New Analysis querySummary How to update the New Analysis queryContent How to update the New Analysis query from advanced tab with other operator functions/Group by functionUser_AEMC1 54 views 3 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for ERP -
Report that shows Payables Invoice Approver name, Initiated by , Validated by valuesSummary We are trying to build a report in Payables that shows Invoice details along with Approver name, Initiated by, Validated by ValuesContent We are trying to build … -
OTBI Reporting QuestionSummary Adding field, removes othersContent Hi, I am brand new to OTBI and am having issues adding a field to my Received Not Invoiced report I am attempting to build wi…