OBI Answers
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… -
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…Eren Göktepe-155015 17 views 1 comment 0 points Most recent by Eren Göktepe-155015 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 …Eren Göktepe-155015 14 views 0 comments 0 points Started by Eren Göktepe-155015 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…Noelle Bartlam-Oracle 301 views 8 comments 3 points Most recent by Feras Ahmad 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 34 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
How can i find BI Tables easily?Summary How can i find BI Tables easily?Content How can I find BI tables where specific data is stored, I spend so many times trying to map and also get a table I want f…Michael Nega Gebrehawariyat 56 views 2 comments 1 point Most recent by Nathan CCC 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 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
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 16 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 76 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 222 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_ tablesuser12240811 15 views 3 comments 1 point Most recent by user12240811 Reporting and Analytics for ERP -
Probation Questionnaire ReportSummary I wanted to develop a probation questionnaire report using BIContent I couldn't find the table in which probation evaluation is found while developing a probatio…Michael Nega Gebrehawariyat 19 views 0 comments 0 points Started by Michael Nega Gebrehawariyat Reporting and Analytics for ERP
-
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 17 views 1 comment 0 points Most recent by User_4A8FM Reporting and Analytics for ERP
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…RAJESH M-226898 48 views 2 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…user12240811 22 views 4 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Want to extract Data from Report & analytics by writing SQL QuerySummary Want to extract Data from Report & analytics by writing SQL QueryContent I Want to extract Data from Report & analytics by writing SQL Query. Previously i use ex… -
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…RAJESH M-226898 18 views 3 comments 1 point Most recent by Abhishek Gupta1 Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fielduser12240811 14 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP
-
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …Doron de Jong-57089 134 views 9 comments 1 point Most recent by Ed Higgins Reporting and Analytics for ERP
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 61 views 2 comments 0 points Most recent by Kunal Daya-175386 Reporting and Analytics for ERP
-
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableuser12240811 35 views 5 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g…Koteswararao Yenikepalli 33 views 3 comments 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
Comprehensive Reporting Role in Fusion CloudSummary Role that has Access to all the Subject Areas/Dashboards/Reports. (Object Level as well as Data Level)Content Do we have a role other than BI Administrator that …Senthilrajan V 40 views 9 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion clouduser12240811 11 views 1 comment 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Need Help with a Deep Link for RequisitionSummary Trying to Create Drill down from a Simple OTBI report to the Requisition ScreenContent Hello. Looking for some help on what we think is a simple deep link from a… -
Column returning no value when combining Payables Invoices and Payment History subject areasContent Hi all, I have created a summary analysis for AP with a pivot table view that users can drill through to a detailed analysis and then drill down into the manage … -
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…user12240811 49 views 4 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…