Reporting and Analytics
Discussion List
-
Organization Hierarchy ReportingSummary How to Correctly Report the Levels of an Organization's Hiearchy?Content I am trying to create an Organizational Hierarchy report that shows the number of Contac…NDKoze 78 views 4 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Is it possible to customize the service infolets in Analytics section?Summary: Hello, we would like to know if it is possible to customize the service infolets in Analytics section. Also, we would like to check if the data displayed in tho…Eric Serra I Paradis 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Can we trace categories changes in Audit LogSummary: Tracing categories changes in the Audit Log Content (required): As we all know, we can trace the incident transactions through the Audit log. But one of my clie…Vikash Patel 21 views 2 comments 0 points Most recent by Sasi Gudimetta-281012 Reporting & Analytics for B2C Service -
Help reporting on a button clickSummary: Need help reporting on a button click Content (required): I'm attaching my simple report definition (zipped xml) for when an agent clicks a button in their work…kerry walker 21 views 6 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Schedule a Dashboard to be emailedContent Hi All, It doesn't seem that we have the ability to schedule a dashboard to be sent to a group of email recipients, so I'm wondering what solutions you all use t…Mia B 29 views 9 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
How to migrate custom data stores in BICC from Dev instance to test instanceSummary: Hello All, We have created few custom data stores in BICC and we used existing VO by deselecting few fields, now we need to migrate these to higher environments… -
Which table should I use to calculate agent login time?Summary: Do I need to develop a report that calculates the login / logout time and which table is the most correct to use? accountsessionhistory or user_trans.type = 1? …Leonardo Santos 31 views 5 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Is it possible to find all the reports with their filter details ?Summary: We need to fetch all the reports in the system that do not have a Date filter in them as we need to then edit those reports . Content (required): Version (inclu…User_2025-02-03-22-07-33-802 31 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
contacts.any_phone_raw is not returning data when searching for Contact Phone Alt 3Content We have a search report set up that utilizes contacts.any_phone_raw which based on the Data Dictionary should search within any phone number field on the contact…User_2025-07-18-04-45-06-758 15 views 2 comments 1 point Most recent by Lakshay Bhalla Reporting & Analytics for B2C Service -
how to export all custom lookups defined in application using export managementSummary how to export all custom lookups defined in applicationContent Hi All, Is there any way to export all custom lookups defined in application through export manage… -
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct… -
Why my Logon Reports show duplicate rows?I did a new Logon Report to show start/end by day. But it is running with duplicate rows for each Agent, I would like show one row only. I'm using account_session_histor…Leonardo Santos 41 views 5 comments 0 points Most recent by Kurt Helfrich Reporting & Analytics for B2C Service -
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 41 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
"Records" is greyed out on the report, cannot edit even if I have permissionSummary: "Records" option on report design Content (required): Hi friends, I have an old report that I need to edit. I want to edit the records that can be opened from t… -
Duplicate contact email addressesSummary: Looking for downsides to allowing duplicate email addresses Content (required): We've recently come across a few reasons to allow duplicate email addresses for …kerry walker 11 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetSummary R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsh… -
Search in Answer Source (Using Custom Script) - Analytics Cookbook RecipeContent Search in Answer Source Using a custom script Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Advanced) Target per…User_2025-02-03-19-30-01-975 151 views 7 comments 10 points Most recent by Ssimpson-Oracle Reporting & Analytics for B2C Service -
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to deeply understand your Oracle Cloud Applica…This discussion has been merged.Bethany Hubbell 1 view 0 comments 0 points Started by Bethany Hubbell Reporting & Analytics for B2C Service -
How much data is too much dataSummary: We struggle with reports not running due to too much data. We average about 45,000 open incidents a day. Our oldest ticket is year and a half old. We are lookin…Jeff Scrobel 21 views 0 comments 0 points Started by Jeff Scrobel Reporting & Analytics for B2C Service -
We need a report on Anchors.Summary: Anchors arent represented well in answers and their solutions. How can we search for them? Content (required): I made a report to search an answer solution for … -
What is the Proper Syntax for an Exception Report Using the IF ArgumentSummary: Looking to change the color of the text when a result is outside of a SLA Using an Exception Report With a Logical Test Content (required): The report I've writ…Chuck Udzinski 21 views 2 comments 0 points Most recent by Chuck Udzinski Reporting & Analytics for B2C Service -
BI Publisher Report Parameters Performance IssuesContent Hi, We have created a report with 15 LOV parameters such as Business Unit, Supplier, Location based parameters, GL Tree based parameters, Buyer, Currency and GL …user10645928 5 views 1 comment 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
Enhanced Business Rule 2.0 LogSummary How to access EBR logContent Hi Can we access Enhanced Business Rule 2.0 log in BUI or in Agent Console. I know we can access legacy business rule from left navi…Baljeet Singh-231094 35 views 2 comments 0 points Most recent by Baljeet Singh-231094 Reporting & Analytics for B2C Service -
List of answers sent by agents on chat interactionsSummary It is possible to access chat_events.data_str in reports?Content Customer requested a report to list answers sent by agents over chat interactions. Reviewing cha…User_2025-02-03-17-16-55-538 31 views 3 comments 0 points Most recent by User_2025-02-03-17-16-55-538 Reporting & Analytics for B2C Service -
What are the different ways we can show an OTBI dashboard/report in the Oracle Sales Cloud Homepage?Summary What are the different ways we can show an OTBI dashboard/report in the Oracle Sales Cloud Homepage?Content Hi, Right now, the way we do this is by linking the r…User_2025-07-18-06-07-44-367 32 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Sales -
Option to reset search filters in contact search reportSummary How can we enable agents to reset the search fields to serve the next customer?Content Hi there, We have an issue with search reports when agents use them; when … -
How to relate contacts and campaigns through reportsContent Hi All, Do we have an option for relating the contacts and campaigns through reports ? I want to create a report that shows the campaigns associated to a particu…User_2025-02-03-19-33-54-197 26 views 1 comment 0 points Most recent by Robert Conrad-148226 Reporting & Analytics for B2C Service -
Need to add exceptions to dashboard reportsContent Need to add exceptions to dashboard reports to give a visual indication as to where a request is in relation to its estimated resolution time (SLA) The requireme…User_2025-02-03-21-38-11-067 32 views 3 comments 1 point Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service