Reporting and Analytics
Discussion List
-
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 62 views 3 comments 0 points Most recent by PavithraKS-Oracle Reporting & Analytics for Sales
-
All Incidents column showing with Multiple Duplicates inc_performance inner join incidents tablesSummary: I have two level report with a variable date_format(incidents.closed,$date_format) that groups by incident.closed. I have two reports build the same way and the… -
B2B Service Infolet - "Team Wait Time" doesn't show dataSummary B2B Service Infolet - "Team Wait Time" doesn't show dataContent Hi, I have a problem in service analytics. For a Customer Service Manager login, Team Wait Time i… -
Ability to view "View Selector" option in excel attachment for reportsSummary: We are scheduling an analysis, In the analysis we have view selector(attached the screenshot) where the default one is Graph view and the other one is Table. Wh…Racharla Arun Kumar 31 views 2 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Sales -
Is there a report that can count no. of E-mail interactions in the communications thread?Summary: Hi Experts, Is there a report or is it possible to count the number of e-mail interactions or e-mail exchanges from the customer to the Agents? I just need the …Jepee Celorico 42 views 4 comments 0 points Most recent by Jepee Celorico Reporting & Analytics for B2C Service -
Web services to invoke custom ess jobs and download the output.Summary: Hello, Team. Greetings for the day We need to share the bip report output with a third party system. Instead of sharing the file via SFTP, we are considering cr…User_2025-10-24-00-15-43-324 51 views 2 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Service -
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
-
All Incidents column showing with Multiple Duplicates inc_performance inner join incidents tablesSummary: The report consists of two levels the top level has All Incidents column: "count(incidents.closed)" that is counting incidents outside of the timeframe while th… -
What is the equivalent field in base table for "PrimaryContactFlag" attribute of Activity Contact?Summary: I want to convert Rest Websevice extract for Activity Contact with specific fields only into BI report. When I tried to construct the SQL Script using "ZMM_ACTY… -
How to count different option from 3 different custom columns in CHATS ReportsSummary: Report table incidents inner join with contacts. I already added filters to show all by contact. I tried adding additional filter/s but is not letting me and th… -
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 52 views 3 comments 0 points Most recent by Deborah Bourgeois-Support-Oracle Reporting & Analytics for Sales -
OTBIレポート作成のガイドお客様が自分でレポートを作りたいときに参考にできる日本語のガイドをご案内します。 簡単ガイド ERP/SCM/EPM Cloud日本語フォーラムに【簡単7ステップ】セルフBIレポートの作り方…Yumiko Uotsu-Oracle 492 views 1 comment 0 points Most recent by Yumiko Uotsu-Oracle 日本語Cloud HCMフォーラム -
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 264 views 2 comments 0 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales
-
Google reported that we have several url without good experienceSummary: We received a list of urls where google informs that they do not have a good experience Content (required): The urls are disapproved due to failure in the LCP, … -
Reporting on Answers where agents have NOT createdSummary: Ability to search for Agents that have NOT created an answer. I have a report that looks at the Answers table and it has the Creator field and Year Month with a…SDP 61 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
How to remove appointments which are completed or cancelled from the 'My Appointments'Summary: Greetings! Can anyone assist me on how to remove appointments/tasks that are 'completed 'or 'cancelled' from the 'My Appointments' present under Sales Infolets … -
outer join with WHERE NOT EXISTS statementContent Hi, I'm looking for a way to configure a report with an outer join and the WHERE NOT EXISTS statement (known from native SQL). Sadly I do not find a solution. Th…User_2025-02-03-17-28-17-184 50 views 14 comments 1 point Most recent by SDP Reporting & Analytics for B2C Service -
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
My array for $exit_obj does not display all the dataSummary: I'm using custom script to export the data into an array, manipulate it and dump it back into the $exit_obj. However, when the data is displayed - it does not d…Jason Phillip 41 views 2 comments 0 points Most recent by Jason Phillip Reporting & Analytics for B2C Service -
Can the note filed from the threads table be processed as a string?Summary: I have some content in the threads field, and i want to split it apart in to separate strings for a report. However every function i use says its expects a stri…spence_abcd0109uk 31 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service -
Help with report - answers last accessed by users in specific profileSummary: Help with report - answers last accessed by users in specific profile Content (required): Hello. I am trying to write a report that shows the last time an answe…kerry walker 71 views 5 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User-Summary: Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User Content (required): Hi, We have a requirement for a report which…Aman Chaturvedi 42 views 1 comment 0 points Most recent by Rohan Kamat Reporting and Analytics for SCM -
Exporting incidents with attachmentsSummary: We have a requirement to export the old incidents with attachment for old customers Content (required): Can we export the incidents from old customers along wit…Jayashankar Lingaiah-Oracle 61 views 5 comments 0 points Most recent by Lisa Bright Reporting & Analytics for B2C Service -
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 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle 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 fet… -
How to create build an analysis report for Lead Source?**This post was created as part of a How to Service Request (SR) Release: 22D Summary of the question: How to create build an analysis report for Lead Source? Though the… -
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 101 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 71 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Reports in the oracle cx sales mobile app does not return any dataSummary: Reports in the oracle cx sales mobile app does not return any data; cannot see/access any reports. What could be the reason for this? and how to fix it? Thank y… -
Report Filters for null and not null queriesSummary: I need to be able to create a filter that if blank will return rows with that column blank, but if not blank then return rows that match the filter Content (req…Rob Shorney 101 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service