Reporting and Analytics
Discussion List
-
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 35 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) …Sangeetha Kumar 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Application Performance Monitoring for Commerce CloudOracle's Application Performance Monitoring tool is now configurable with Commerce Cloud via the Admin console! Attached is high level summary APM guide for commerce whi… -
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
-
Archived Incidents transaction reportingSummary: Reporting on Archived Incidents access usage stats using transactions table Content (required): Has anyone had success reporting on Archived Incidents access us…HelenH 61 views 3 comments 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
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 194 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Is there any way that we get Inventory transaction details with Serial numbers using Inventory SubjeSummary Is there any way that we get Inventory transaction details with Serial numbers using Inventory Subject AreaContent Is there any way that we get Inventory transac…User_2025-02-04-07-31-55-085 90 views 3 comments 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Help with If statementSummary: Help with If statement Content (required): Hello, I'm trying to update the column of a report with this logic - If the count of the answer views is great than 1…kerry walker 93 views 10 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Dashboard Report to pull today only closed incidentsSummary: Daily Closed with Drill Down Level Report. Trying to make it to pull only current date closed with relative since is Dashboard Report and no filter should show …
-
Data Security Policy Mapping for Leads in the UI and OTBISummary Using different security in OTBI to HCM Cloud Content Would it be possible for you to give me an example of this solution: https://community.oracle.com/customerc…
-
System Report OptimizationSummary: I have report that is prebuild (before my time). Is working in the console but not in the BUI and currently trying to find ways to rebuild or filter it to show …
-
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 63 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 36 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 45 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 55 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 64 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 56 views 3 comments 0 points Most recent by Deborah Bourgeois-Support-Oracle Reporting & Analytics for Sales
-
OTBIレポート作成のガイドお客様が自分でレポートを作りたいときに参考にできる日本語のガイドをご案内します。 簡単ガイド ERP/SCM/EPM Cloud日本語フォーラムに【簡単７ステップ】セルフBIレポートの作り方…Yumiko Uotsu-Oracle 511 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 62 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 51 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…