Reporting and Analytics
Discussion List
-
After 23B release upgrade, why BIP report is not throwing any error for Mandatory Parameter?Summary: After 23B release upgrade, why BIP report is not throwing any error for Mandatory Parameter- with "can select All" option? Oracle Fusion Application- BI Publish…UM~ 472 views 5 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
How to apply data security for sql Queries in Data sets to be like custom subject areas?Summary: I need to apply security part for the SQL Queries Content (required): We have reports for custom objects, these reports Data models created by SQL Queries, We a…Mohamed Shaaban-Oracle 32 views 4 comments 0 points Most recent by Mohamed Shaaban-Oracle Reporting & Analytics for Sales
-
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Balaji Midhun Kumar Sanagapalli-146903 123 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Its important to know How to solve invalid path when unarchiving reportSummary: We need to move report from one instance to another but the system showing invalid path Content (required): Version (include the version you are using, if appli…K.Sh 43 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Restricted Access to Reports and AnalyticsSummary: Hello All, I have a requirement where users should be able to access all reports and analytics in OTBI but should not be able to access any objects in Fusion Ho…Manju_Bujendra 111 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
List of Duty and Data Roles for Fusion CXSummary: Hi All, need to raise an access request to Fusion CX, so we have unrestricted data access. Can anyone please share the complete list of Data and Duty roles for …Amrita Gupta-Oracle 53 views 3 comments 0 points Most recent by PavithraSaravanan-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 52 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to build an Analysis using Subject Area with Subscription Product Associated Asset fields?Hello! I was not able to find a Subject Area that brought Associated Assets fields. I also tried to create a custom Subject Area to have those fields, but the only child…Bruno Matheus 61 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Subscription Management
-
How do we obtain a report of the notes associated with a lead?Summary: We need to obtain a report to obtain the relationship of leads with the notes that have been created. Content (required): We tried to build this report across s…SERGIO BARRETO 61 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to remove or hide print option in reports and dashboards for certain users?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: Certain users should not have permission to print reports and dash…Deborah Bourgeois-Support-Oracle 42 views 3 comments 0 points Most recent by Deborah Bourgeois-Support-Oracle Reporting & Analytics for Sales
-
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 42 views 2 comments 2 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales
-
Subject Area - How to add the attachments field in a reportSummary: How to add the attchament field in a report made through the subject area "Sales - CRM pipeline" Content (required): We want to add the attachment field in a re…SERGIO BARRETO 167 views 2 comments 0 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales
-
How to fetch a list of users linked to Account/Account sitesSummary: How to fetch a list of users linked to Account/Account sites. Content (required): How to fetch a list of users linked to Account/Account sites. The ask is to fe…Neelesh Varma 43 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to send HTML content email using OTBI agentSummary: Not able to send an email which include html tags and image contents to be scheduled and sent over agents in OTBI Content (required): Version (include the versi…Kostare 82 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Using deep link with Workspace and being able to open a record from the tabI am doing a POC for a customer for the following requirement: I have a report showing Customer Name and Activities for that customer. I want to click on the account nam…Andres Munoz 61 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Why is my new custom field not showing in BI?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: I have created a new field 'NewField_c' in the 'Object_c' custom o…Ionel Spaloghe-Support-Oracle 71 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales -
Create Custom Subject AreaHi, Please help with the steps how to create custom subject area from the custom data model ? ThanksMohammed Rafi 72 views 3 comments 3 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to create a report to show opportunities for the logged in user territory hierarchy?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: How to create a report to show opportunities for the logged in use…Deborah Bourgeois-Support-Oracle 61 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to insert page breaks for report PDF print out?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: How To: 1. Insert page break in the narrative between accounts 2. …Deborah Bourgeois-Support-Oracle 116 views 4 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to give user friendly names to Custom Subject Areas when using queries on Data Model?**This post was created as part of a How to Service Request (SR) Release: 22D Summary of the question: How to give user friendly names to Custom Subject Areas (CSA) to m…Deborah Bourgeois-Support-Oracle 73 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 31 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Trendline Function exampleWhat does the trendline function shows? Do you have an example of how it works? We have this formula: TRENDLINE("Pipeline Facts"."Opportunity Revenue", ("Time - Addition…Syed Misbauddin-Support-Oracle 14 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
ESS Job linked with Report giving errorSummary: ESS Job linked with Report giving error: "Report definition not found:My Folders/Drafts/TestRenewalReport.xdo" Content (required): ESS Job linked with Report gi…Neelesh Varma 33 views 2 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Sales
-
Fetch Subscription Contact Mail ID using reportSummary: Fetch Subscription Contact Mail ID using report Content (required): Need to figure out the set of queries required to fetch the email id of the contact which is…Neelesh Varma 71 views 2 comments 0 points Most recent by Alexandra Rabaea-Support-Oracle Subscription Management
-
How to combine two rows of text data into a single column in OTBI?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: How to combine two rows of text data into a single colum…Priscila Terazawa - Support-Oracle 494 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
subject area for householdSummary subject area for householdContent Quick question - Is there any OOTB subject area for Household? Thanks, Adam -
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated valuesContent Hello, I have a need to see only the null values and future dates. I'm …Stephanie Gott 44 views 2 comments 1 point Most recent by Jahnavi-Oracle Reporting & Analytics for Sales -
Is there a way to capture the details when the user views the data in sales objects?**This post was created as part of a How to Service Request (SR) Release: 22C Summary: If the user login to the system and accessed the sales object and does not perform…Dragos Deak-Support-Oracle 33 views 1 comment 0 points Most recent by Dragos Deak-Support-Oracle Reporting & Analytics for Sales
-
How to Send an Email with report attachment?Question : How can an email notification be sent to the opportunity owner with all the opportunity details at the same time? **This post was created as part of a How to …Iulian Hanza-Support-Oracle 11 views 1 comment 0 points Most recent by Iulian Hanza-Support-Oracle Reporting & Analytics for Sales
-
Subtab Analytics for BI report Parameter passed not generating correct report**This post was created as part of a How to Service Request (SR) Summary: Request is to have on custom entity Project show Account, Opportunity and Opportunity Team for …Dragos Deak-Support-Oracle 21 views 2 comments 0 points Most recent by Dragos Deak-Support-Oracle Reporting & Analytics for Sales