Category 192-2
Discussion List
-
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 51 views 6 comments 0 points Most recent by Vikrant Tripathi Reporting & Analytics for Sales -
Budgetary Control Infolets not displaying data even after creating budget account groupsHello everyone, We have already completed the Budgetary Control setup and created the required budget account groups, also we have already consumed funds, but the Budget… -
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 13 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 1 view 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Fusion Service -
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 32 views 3 comments 0 points Most recent by HD - Oracle Fusion ERP-Oracle Reporting & Analytics for Sales -
How to retrieve full update history for a specific Opportunity via OTBIThe business requirement is to retrieve all records/updates (audit history) related to a specific Opportunity in Oracle Sales Cloud, using OTBI. Required fields to be re…Paraskevi Thanasi 71 views 6 comments 0 points Most recent by Paraskevi Thanasi Reporting & Analytics for Sales -
[EPBCS][Metadata]-Identify Parent become Lev0 member post hierarchy changesSummary: “Is there a way to identify metadata, such as a project’s parent member, where a stored property became a Level 0 member after all its children were moved to an…Muni Kumar Vellure-Oracle 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-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 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… -
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 -
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 21 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 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 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