OTBI
Discussion List
-
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 557 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 99 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 72 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 123 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 32 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Risk Management Intra-Role Violations by Control ReportSummary List of roles that contain violations within itself for a specified control.Content * Download the zip file attached to this post * Unzip and you'll find 2 catal…Stephanie Golly-Oracle 70 views 1 comment 1 point Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Risk Management Access Violations within a Single Role (Intra-Role) ReportSummary List of roles, users and conflicting access points with conflicts by control. Only roles that contain violations within itself are listed.Content * Download the …Stephanie Golly-Oracle 122 views 1 comment 2 points Most recent by Feras Ahmad 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 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
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…User_2025-02-10-05-51-05-868 77 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Basic General Ledger Transaction Report - Filtered By AccountSummary Does anyone have a robust Basic General Ledger Transaction Report - Filtered By Account that they could shareContent We are due to go live with Oracle Fusion (SA…User_2025-02-11-02-45-23-645 61 views 5 comments 0 points Most recent by User_2025-02-07-23-45-47-870 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…Nageshwaran1 114 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
OTBI Analysis filter by max date valuesSummary I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent How to do below in OTBI Analysis, Data Set…Fahad Cader 636 views 9 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based… -
How to add OR condition in the input of the OTBI analysisSummary How to add OR condition in the input of the OTBI analysisContent There are suppliers whom we create only invoices and there are suppliers whom we create only PO …Manish Kumar Sinha 29 views 7 comments 2 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
SQL Cash Advance Report from ExpensesSummary SQL Cash Advance Report from ExpensesContent Hello I was wondering if you can share with me any SQL regarding open Cash Advances from Expenses. Thanks for your h…gabriel kinovisques-163562 51 views 2 comments 1 point Most recent by Balachander G-Oracle Reporting and Analytics for ERP
-
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 46 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle 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… -
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…Gene Garcia 489 views 2 comments 0 points Most recent by Kent Sarmiento Reporting and Analytics for ERP
-
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…User_2025-02-10-05-51-05-868 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP
-
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…User_2025-01-28-05-32-59-092 56 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP
-
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 fieldNageshwaran1 55 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 …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 Reporting and Analytics for ERP
-
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 55 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
Set background color on subtotal lines in OTBIContent Hi, I would like to set background color on subtotal lines in OTBI Analytics. Does anyone know how to configure about this? regards, Version BIP 11.1.9 bundled w…shun nakamura 42 views 5 comments 2 points Most recent by shun nakamura Reporting and Analytics for ERP
-
COA value missing in the LOV in Payables invoices - Transactions real time subject areaSummary COA value missing in the LOV in AP invoices real time subject areaContent Hi Gurus, We defined a cost center long ago and had AP transactions created against it.…