OTBI
Discussion List
-
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 13 views 3 comments 0 points Most recent by Priscila Terazawa - Support-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 11 views 1 comment 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 13 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 3 views 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 23 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 32 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 43 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 12 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. 12 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 13 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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 645 views 12 comments 9 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 12 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle 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…
-
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 34 views 1 comment 0 points Most recent by Piyush.Jain-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 32 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 52 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 42 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 581 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 15 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Query to get customer contacts by siteSummary: Query to get customer contacts by site Content (please ensure you mask any confidential information): Hi, I am trying to fetch AR Customer contact information w…Cesar Tepetla Corte 3.4K views 3 comments 0 points Most recent by Manoj Kumar-Support-Oracle Reporting & Analytics for Sales
-
How to limit prompt values to values displayed on analysis - OTBISummary: I'm building an analysis using the "Incentive Compensation - Attainments Real Time" subject area. One of the prompts in the dashboard that includes this analysi…Vitor Nakamura 79 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Error when trying to add an analysis inside a datamodelI am trying to add an analysis inside a datamodel created through subject area, but when I click on view to see the information the application takes a long time and at …SERGIO BARRETO 109 views 12 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Is there a way to push report out of OTBI into a database?Is there a way to push a report out of OTBI on a weekly or daily basis that generates an excel file into a OneDrive folder?mfribeiro 21 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Table for main contact in CRMDear all, Please help, I need to identify the table that brings me the main contact of the CRM module in Oracle Fusion Cloud. Thank you.Jhonattan Diaz 34 views 3 comments 0 points Most recent by Madhuri Cheruku-Support-Oracle Reporting & Analytics for Sales