Reporting and Analytics
Discussion List
-
Link Checker/Broken URIs is not updatingSummary: Broken links fixed - report still shows old URIs Content (required): I fixed over 1500 broken links in our knowledge base yesterday. I ran the Common/Site Admin…User_2025-10-31-01-08-51-703 31 views 1 comment 0 points Most recent by User_2025-10-31-01-08-51-703 Reporting & Analytics for B2C Service -
Sales stage history report - count if revert to a single sales stage twiceSummary: Sales stage history report - count if revert to a single sales stage twice. Content (required): I am trying to create a report showing the number of opportuniti…Arsalan 31 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
How can you join 2 tables without an intermediate table?Summary: I need assistance with how to join 2 tables in a report without the intermediate table it is telling me I have to use. I have data in an Answers table and a cus…User_2025-02-12-02-07-32-442 31 views 3 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service -
How to create a number only field on Oracle B2C RightNow?Summary: Content (required): Hello, I'm using Oracle B2C RightNow. I wish that the field bellow allowed only numbers input (no letters or symbols). Is it possible? I don…User_2025-02-12-03-33-58-985 11 views 3 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
Frequent ReportsSummary: Custom Report Useage Content (required): Is there a report that shows all the reports that are being used frequently by the users Version (include the version y…Boby B Jacob 31 views 2 comments 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Actual SLT time worked by AgentSummary: we have a requirement to calculate the actual time worked by an agent on any incident taking SLA time and holidays into consideration Content (required): For B2…Jayashankar Lingaiah-Oracle 51 views 2 comments 1 point Most recent by Justin_D Reporting & Analytics for B2C Service -
RemovedSummary: Content (required): Version (include the version you are using, if applicable): 21C Code Snippet (add any code snippets that support your topic, if applicable):Manoj Maruvada 21 views 0 comments 0 points Started by Manoj Maruvada Reporting & Analytics for B2C Service -
How to filter Resource Column in a report based on Logged in User.Summary: Trying to put a filter of logged in User on Resource name in reports. But filter is not working. Using below filter in Resource name Content (required): VALUEOF… -
Chat queue availability reportSummary: Historical report on how much time there was no agent available for a specific queue. Content (required): I'm looking for a historical report on how much time t… -
How to filter on the startdate of first event if a person may have multiple events attended?Summary: Report on only the first event Content (required): I need to have a report which only displays the first event to which a person has been. So I have the contact… -
Is There a More Detailed Database Dictionary?Summary: Is there a more detailed database dictionary for Oracle Service Cloud? Content (required): For example, I am finding that some of the information in the Databas…NDKoze 41 views 1 comment 1 point Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
Find e-mail address in incident threadSummary: How can I make a report with an e-mail address in one column that is used to search in the initial customer thread in another column. With a third column showin… -
Available Today: Out of the Box Reports for Service Agents and ManagersSummary: Out of the Box Reports for Service Agents and Managers - available today in Oracle Sales. Content (required): Out of the Box Reports for Service Agents and Mana… -
Available Today: Out of the Box Reports for PRM and Channel SalesSummary: Out of the Box Reports for PRM and Channel Sales - available today in Oracle Sales. Content (required): Out of the Box Reports for PRM and Channel Sales - avail… -
Available Today: Out of the Box Reports for the Sales ExecutiveSummary: Out of the Box Reports for the Sales Executive - available today - in Oracle Sales. Content (required): Out of the Box Reports for the Sales Executive - availab… -
Available Today: Out of the Box Reports for the Sales ManagerSummary: Out of the Box Reports for the Sales Manager - available today - in Oracle Sales. Content (required): Out of the Box Reports for the Sales Manager - available t… -
Available Today: Out of the Box Reports for the Sales RepSummary: Out of the Box Reports for the Sales Rep available today in Oracle Sales. Content (required): Out of the Box Reports for the Sales Rep available today in Oracle… -
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 77 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