OTBI
Discussion List
-
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 166 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 62 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 63 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 219 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 45 views 0 comments 0 points Started 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 75 views 5 comments 0 points Most recent by Ayesha Thilakarathna-51043 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 460 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 122 views 2 comments 0 points Most recent by Nikhil Nelluri-71478 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 62 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 187 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 46 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… -
Add OTBI reports to Scheduled ProcessesSummary How to add OTBI reports to Scheduled ProcessesContent Hi, Can we add OTBI reports to Scheduled Processes rather than access them in Reports and Analytics?Lakmal 133 views 7 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for ERP
-
Custom Data Model - Remittance Advice - Change From Check to Wire Payments?Summary Custom report using SQL data model - How to change from check payments to wire payments?Content We have a custom report for AMEX remittance advice which gives us… -
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…Doron de Jong-57089 61 views 1 comment 1 point Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
Check Overflow check number in Fusion PayablesSummary Check Overflow check number in Fusion PayablesContent Hello All, Did any one build a report to get the list of Overflow Check number and Void Check numbers? if s…
-
Custom Enterprise Scheduler Job not showing to intended usersSummary Custom Enterprise Scheduler Job not showing to intended users while showing to othersContent Hi All, I have created a custom scheduler job using "Manage Custom E…
-
OTBI Custom Report SecuritySummary OTBI Custom Report SecurityContent Hi, We have problem with OTBI Custom Report Security , i create several otbi analysis and dashboard and prompt and put them al…Abdalaziz Barham 85 views 1 comment 1 point Most recent by Shakher Sharma Reporting and Analytics for ERP
-
After delete report folder Path not foundSummary After delete report Path not foundContent Hi, We have problem with OTBI Custom Report Security , i create several otbi analysis and dashboard and prompt and put …Abdalaziz Barham 22 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
Preparing a custom fixed asset reportSummary Custom report designContent Hi, I would like to create a custom fixed asset report.What data model should I select or create or how can I do that ?(BI Publisher,…Armagan Sahin-57534 152 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL Reporting and Analytics for ERP
-
Suppliers on Purchasing Hold by Supplier Type ReportSummary Dashboard Displaying Active Suppliers On Purchasing Hold By Supplier TypeContent This dashboard will allow you to retrieve a list of your active suppliers that h…Aishwarya Pawar-Oracle 126 views 2 comments 4 points Most recent by Aishwarya Pawar-Oracle Reporting and Analytics for ERP
-
How can we find roles/access needed for a subject areaSummary How can we find roles/access needed for a subject areaContent Hi All, We are on R12. Our OTBI subject areas (for FIN and PRC) are working only for some users and…
-
FA Retirement & Reinstatement SummarySummary How to Print Retirements and Reinstatements in the same OTBI reportContent Hi, We are trying to print FA Retirement details (Asset Cost, NBV, Gain Loss) and FA R…Sridevi Srikanth 35 views 0 comments 0 points Started by Sridevi Srikanth Reporting and Analytics for ERP