OTBI
Discussion List
-
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Development.…Noelle Bartlam-Oracle 3.5K views 15 comments 11 points Most recent by Sachin Bhadange Reporting & Analytics for Sales -
How do I remove the measure labels from my bar chart so it doesn't show in the legend?I have a horizontal bar chart and have noticed that the "measure labels" is in the Vary Color By section of my chart. I can move it to Group By, Sections, and Graph Prom…Tonya H 53 views 6 comments 0 points Most recent by Vikrant Tripathi Reporting & Analytics for Sales
-
Seeking Solution: Account Hierarchy Roll-up Report for Leads, Opportunities, and Service RequestsSummary: Hello Community, We have a business requirement to build a comprehensive dashboard or report in Oracle Sales Cloud that provides a consolidated view of Accounts…Sudheer V-Oracle 14 views 3 comments 0 points Most recent by Sudheer V-Oracle Reporting & Analytics for Sales
-
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…Martina Di Battista 2 views 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Fusion Service
-
User Adoption Insights - Preconfigured Sample Reports in OTBISummary Sample reports for user adoption insights in OTBI are available with attached .catalog fileContent Oracle CX Sales has received requests to provide pre-configure…Greg Rice-Oracle 664 views 13 comments 9 points Most recent by Navin Jose-Oracle Reporting & Analytics for Sales -
Tracking User Role Assignments in Oracle Fusion: Standard Reports and Audit Log CapabilitiesSummary: In Oracle Fusion Applications (not limited to Sales Cloud), is there a standard way or report available to retrieve a list of all users along with their assigne…Abhijit N 63 views 3 comments 0 points Most recent by HD - Oracle Fusion ERP-Oracle Reporting & Analytics for Sales -
How to build a report to show as when a specific report has been run and at which time?**This post was created as part of a How-To Service Request (SR) Summary: I need to report to show as when a specific report has been run and at which time. Version (inc…Priscila Terazawa - Support-Oracle 54 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Retrieve ParentAccountPartyId from Oracle CX tablesHi, I need a query that extracts data from hz_organization_profiles, and among the fields I need is ParentAccountPartyId. This field is available in the endpoint: /crmRe…
-
OTBI report with export where it shows only 2 Lakh 50 thousand records in export at maximumCX Sales: In OTBI Analytics, there is currently a record extraction limit of 250,000 records. This restriction is not meeting our reporting requirements in certain cases…Rohan Bhadani 14 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Marketing - CRM B2B Customers Subject AreaSummary: Marketing - CRM B2B Customers Subject Area Content (please ensure you mask any confidential information): Hi Team, I am looking for details on "Marketing - CRM …Nidhi Chhajed 12 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
I have created an OTBI report in which customer name is promptSummary: I have created an OTBI report in which customer name is prompt but the LOV contains all the parties instead of customer only How to restrict that LOV? Content (…Muhammad_Saad 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Searching on HZ_ORGANIZATION_PROFILES_Hi all we need to create a report, to run weekly, that searches for Accounts/Organizations on which a specific field changed in the last week. Any idea how to avoid a FU…Luca Angheben 22 views 3 comments 0 points Most recent by HD - Oracle Fusion ERP-Oracle Reporting & Analytics for Sales
-
Customer wants to have email and in-app notifications for Sales reports to be sent to team membersCustomer wants to have email and in-app notifications for Sales reports to be sent to team members. How can this be achieved?
-
How to optimize SQL query on MOO_OPTYSummary: A BI Report must extract daily a specific set of specific opportunities Content (please ensure you mask any confidential information): We want to query on MOO_O…Luca Angheben 33 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
BI Report: multiple filters return no results but when filters used individually returns recordsSummary: I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportuniti…Tonya H 41 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t… -
Subject Area to Database Lineage MappingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sheela Pai-Oracle 11 views 0 comments 0 points Started by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Can I use responsive design when displaying BI?Can I use responsive design when displaying BI? -
Query to get ResourceOrganizationName of the userHi All, I am trying to extract resources/users with specific ResourceOrganizationName. I want to extract the ResourcePartyNumber and ResourceOrganizationName. Can you pl…Anj M. 11 views 1 comment 0 points Most recent by Topher Heath-Support-Oracle Reporting & Analytics for Sales
-
XMLPSERVERIn the XMLPServer section, can OTBI reports be seen, or are only BI reports visible?Emanuele De Marchi 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
SCM report in Saleshi all We have a Fusion application with Sales module sending Sales Orders (via CPQ) to SCM module. Customer would like to have an icon, in Sales home page, to allow use…Luca Angheben 13 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
OTBI Analysis reports giving different set of data in fusionSummary: Hi Team, The OTBI report giving different set of data in fusion for different users, we checked the roles both users have the same roles but still difference in…
-
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 33 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales
-
How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI ReportHi All, How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI Report like below image?. Please share us your Ideas or Implementati…Sukumaran Ayyaswamy 33 views 3 comments 0 points Most recent by Manasi.Singh Reporting & Analytics for Sales
-
Can we add Deep Link to lead a Contract and populate statusSummary: They want a link on the Contract OTBI/Infolets that, if clicked in contract status "active / pending approval status", will lead them to a Contract Record and p…
-
How to add lead notes to a reportSummary: We need to add in a report through of subject areas the notes that are recorded on the leads Content (required): How can we add the notes that are related to th…SERGIO BARRETO 53 views 4 comments 2 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
How to create a custom Smart List Analysis/visualization to use in Redwood DashboardSummary: Hi, we need to create a custom Smart List analysis/visualization to use in the Redwood Dashboard. Content (please ensure you mask any confidential information):…Max Prestes 31 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject…SERGIO BARRETO 646 views 9 comments 0 points Most recent by MFlannery Reporting & Analytics for Sales
-
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co…Cesar Tepetla Corte 12 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales