Category 192-2
Discussion List
-
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… -
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 51 views 2 comments 0 points Most recent by Ricardo_AZ 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…
-
Revenue Items Statuses not updating as expectedDescription: We noticed that in the Revenue Items entity the fields 'Revenue Status' and 'Revenue Status Category' are not always updated (with the expected values) when…Paraskevi Thanasi 1 view 1 comment 0 points Most recent by Kyler Thomas-Support-Oracle Reporting & Analytics for Sales
-
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 11 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 12 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 11 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Show Activity Summary Generative AI action does not give any outputSummary: As part of AI features enabled the Show Activity Summary action but it is not giving any outputs even though there activities associated to the Opportunity/ Acc…
-
Unable to Use Dynamic URL with EL Bindings in Action and Links (Application Composer)We are trying to implement a dynamic BI Publisher report URL in a Sales Opportunity page. The goal is to pass parameters dynamically using EL expressions (e.g., #{bindin…KirolosMagdy 22 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Update the Generate Win story Layout with custom layoutSummary: When we generate a win story it gets saved in comments fields and length of comments field is 2000 characters. As per the doc "https://docs.oracle.com/en/cloud/…
-
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 21 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?
-
Does Fusion have pre-define infolet of Expense module？Summary: Customers want to analysis reimbursementsituation of Expense monthly. I remember EBS have Expense command centerinfolet. Does Fusion also have expense infolet? …
-
What is the Subject Area to retrieve Invoice DetailsSummary: We are currently retrieving invoice details using a DM (Data Model) report with the SQL query provided below. Now, we want to create an Analytics Report using a…Anusha716 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
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 31 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 42 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… -
How can I duplicate a standard panelSummary: In the account object, I need to duplicate with the same structure and appearance the Opportunity Panel. How can I make a copy or how can I build a structure an…Jorge Ricardo C. 21 views 1 comment 1 point Most recent by Angel Tripp - Support-Oracle Reporting & Analytics for Sales
-
What would be the reason of showing the Enterprise Quarter as null in Analytics- Sales CRM PipelineSummary: Eventhough the Accounting calendar is setup with proper periods & quarters; Calendar profile option also set to the configured. The opportunity records are show…Cyriac Mathew-Oracle 21 views 2 comments 0 points Most recent by Cyriac Mathew-Oracle Reporting & Analytics for Sales -
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
-
In partners, need the corresponding backend table and column name for Partner's Geographies Served.In partners, there is a column titled 'Partner's Geographies Served.' We need the corresponding backend table and column name. In BIA, we are currently able to retrieve …Vennela Valluri 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-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 11 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 31 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 34 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…