OTBI
Discussion List
-
Spend in functional currency and what is "Invoice measures OBSOLETE"?Summary How to get spend in functional currencyContent I have created a spend analysis based on "Spend Real Time" subject area. Problem is, some of our suppliers invoice…Minna Muikku 46 views 2 comments 0 points Most recent by Minna Muikku Reporting and Analytics for ERP -
Custom Subject Areas for Cloud ERPSummary Custom subject areas can be created under application composer for CRM, but is this available for ERP?Content Hi, I have been using the Fusion Rel 13 partner env…Daniel Willmott 82 views 1 comment 3 points Most recent by Tiger Liu-55147 Reporting and Analytics for ERP -
Hide Operator (is LIKE (pattern match)) from dashboard promptSummary How to hide operator (is LIKE (pattern match)) appearing on Dashboard PromptContent Hi Experts, I have a requirement in my report to just show the heading and hi…
-
Predefined Filters in OTBI Subject AreasSummary Predefined Filters in OTBI Subject AreasContent I have the spreadsheets that document R13 Fusion Financials OTBI subject areas, the corresponding View Objects an…
-
OTBI report needed for real-time Assets source linesSummary Has anyone created an OTBI report that provides current asset source lines?Content I work with Fusion Assets and am wondering if there is a standard report or if…User_II3DX 65 views 1 comment 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Summary Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Content Hello All Is there any Task to search (or) Report in oracle fusion …
-
Tables or views to pick values from manage data access for users functionContent Hello, Is there anyone know any table or view to get values from manage data access for users function? Purpose is to create a custom report and we need to find …Ayesha Thilakarathna-51043 84 views 8 comments 1 point Most recent by Bala Ch Reporting and Analytics for ERP -
DFF columns in OTBISummary How do we pull DFF (attribute) fields when creating report using OTBIMamatha Havildar-83061 232 views 4 comments 1 point Most recent by UjasB Reporting and Analytics for ERP
-
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 503 views 4 comments 8 points Most recent by Chris Lloyd-75810 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…
-
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…
-
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 Chandra Yerra 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…Murali Gangidi 38 views 3 comments 0 points Most recent by Murali Gangidi 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 …Murali Gangidi 54 views 6 comments 1 point Most recent by Murali Gangidi 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 76 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…Mark Fieldhouse 51 views 0 comments 0 points Most recent by Mark Fieldhouse 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 204 views 1 comment 1 point Most recent by Evan Danek-66892 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…Ayesha Thilakarathna-51043 57 views 2 comments 0 points Most recent by Chandra Yerra 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?Sachin Mistry, CFA, PMP 249 views 1 comment 1 point Most recent by Manjunath Rallabandi 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 …Ayesha Thilakarathna-51043 80 views 5 comments 0 points Most recent by Ayesha Thilakarathna-51043 Reporting and Analytics for ERP