Get Started with Redwood: Oracle Cloud SCM and Purchasing
Reporting and Analytics
Discussion List
-
Looking to find a the table that hosts text result for graph reportsSummary in an Infolet report - Current Backlog, there is a column showing Open Incidents and Responded. I am looking for the associated table. msg_lookup is a command bu…Jeff Scrobel 65 views 5 comments 1 point Most recent by Jeff Scrobel Reporting & Analytics for B2C Service -
Agent Total Response Time field discrepancy: exact definition please?Summary Unclear on the discrepancy between this value, and the datediff from session creation to agent engagementContent In building some basic chat reporting, I want to…Loren K 34 views 3 comments 1 point Most recent by Ajay Yadav-140866 Reporting & Analytics for B2C Service -
Closed and Created incidents reportContent Hi Gurus, We want to show the report on last 3 months, how many is created on particular month and how many closed on particular month. I have used date_group(in…Mohana Gopal S-Oracle 46 views 5 comments 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Is there a way to list the reports not used ?Summary Can we list all the reports not used in Service Cloud ?Content Hi Team I am looking for a standard or custom one to list all the reports that are not used in the…abendaoudi-Oracle 48 views 5 comments 2 points Most recent by abendaoudi-Oracle Reporting & Analytics for B2C Service -
Backlog and Closed Cases ReportContent Has anyone created a report that includes both open and closed cases? I want to display a row for each case where it is still in an open status or if it was clos…JLFolkman 22 views 5 comments 1 point Most recent by User_2025-02-03-20-46-35-138 Reporting & Analytics for B2C Service -
Incident report - assigned to a second groupSummary Incident report that shows if an incident was transferred to a different groupContent Hello, I've been trying to figure out how to display the following scenario…User_2025-02-06-05-46-29-624 49 views 1 comment 1 point Most recent by User_2025-02-06-05-46-29-624 Reporting & Analytics for B2C Service -
what is exact columns names for Parent.ID and Parent.Name in category table?Summary what is exact columns names for Parent.ID and Parent.Name in category table?Content Building report for Categories table , looking two columns Parent.ID and Pare…User_DC3Y4 31 views 3 comments 1 point Most recent by User_DC3Y4 Reporting & Analytics for B2C Service
-
Chart display issues Desktop vs BUISummary Chart displaying differently in BUIContent Hi, I'm having a hard time getting a chart to display the same way on BUI as it is on the agent desktop. Any tips woul…Christian UoA 31 views 1 comment 1 point Most recent by Justin_D Reporting & Analytics for B2C Service -
Preview incident - without opening workspace?Content Hello! Could not locate any information in documentation or here at the community, so here goes: My agents wants a preview function of incident (customer thread)…User_2025-02-01-08-38-15-811 21 views 5 comments 1 point Most recent by User_2025-02-03-20-46-35-138 Reporting & Analytics for B2C Service
-
Add new note/thread from reportSummary Add new note/thread from reportContent Our finance team need to respond to queries in their queue from a report. They'd like a faster way to do this without havi…User_2025-02-01-07-03-13-295 43 views 3 comments 1 point Most recent by User_2025-02-03-20-46-35-138 Reporting & Analytics for B2C Service
-
Combining results from tables that are joined multiple timesContent Hi, When I join the same table twice using different conditions, both conditions give different results. The agents may satisfy any one or both the conditions. I…Geetha Amrutha 29 views 6 comments 1 point Most recent by User_2025-02-06-05-37-11-922 Reporting & Analytics for B2C Service -
Show custom menu as drop down menu in report filterSummary Show custom menu as drop down menu in report filterContent I have created custom menu "Employment details" with Primary,Additional & Both items. I have custom ob…User_2025-02-03-16-53-11-440 61 views 5 comments 1 point Most recent by User_2025-02-03-16-53-11-440 Reporting & Analytics for B2C Service
-
All Chat Sessions requested + email Incidents created in 1 view?Summary Need help to create a combined view of all Chat Sessions requested, plus all email Incidents created for any period -- is this possible??Content Hi - is there an…
-
Report dynamic filter(custom field) wise using Custom scriptSummary Organization/Contact/Asset Quick Search Report based logged Agent mapped Division/Business Unit wise dynamically filtered.Content Hello,I'm new to the custom scr…Bajeebi Shaik 32 views 8 comments 0 points Most recent by Bajeebi Shaik Reporting & Analytics for B2C Service
-
Mapping Incidents as a Child to custom objectSummary Trying to map an incident to a custom objectContent Hello All, We are trying to map an incident as a child of a custom object which we have created, then trying …User_2025-02-06-05-53-04-796 42 views 5 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
How to use date_add(date, units, interval, round)?Summary How to use date_add(date, units, interval, round)?Content In Incident table for column "incidents.updated" output is "2020-08-20T 08:33:23Z" but expected Output …User_DC3Y4 70 views 1 comment 0 points Most recent by Yashwanth Siddaraju Reporting & Analytics for B2C Service
-
Show null value as blank is not working for report columnSummary Show null value as blank is not working for report columnContent I have built the report for incident table and I need blank value for null column. Here null val…User_DC3Y4 38 views 2 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
Using Report Management Module (RMM) To Find Reports - Analytics Cookbook RecipeContent Using Report Management Module (RMM) To Find Reports: Finding reports in Oracle Service Cloud is possible in the Reports Explorer, but it can difficult if report…Kenny Tietz-23935 258 views 6 comments 13 points Most recent by User_2025-02-03-17-31-49-785 Reporting & Analytics for B2C Service -
Incident product number reportSummary We tried checking product/incident tables there it shows product_level as product description whereas we are expecting as product number. –Kindly let us know if …User_DC3Y4 39 views 7 comments 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service
-
Agent Overview InfoletsSummary Agent Overview Infolets - showing "1 Record"Content I am fairly certain I know this "1 Record" means the report is bulling back 1 record with the intended total …Jeff Scrobel 28 views 1 comment 1 point Most recent by User_2025-02-01-08-46-19-550 Reporting & Analytics for B2C Service
-
Join Incidents table with answer details tableSummary Join incident table with answer details tableContent We have saved docId in custom object and mapped it to incident. We want to build a report to join incident t…Utkarsh Dangayach-194615 48 views 2 comments 0 points Most recent by Utkarsh Dangayach-194615 Reporting & Analytics for B2C Service
-
Report To Display Parent Incident RecordsSummary Child Incident need to show all other incidents related to one parent incidentContent Hi, I have custom incident report which display all related incidents belon…Baljeet Singh-231094 50 views 3 comments 0 points Most recent by Jayant Singh-120650 Reporting & Analytics for B2C Service -
Aging Report frp the Service Request using OTBISummary I want to Create one Time Trend Analysis, which have weekly, Monthly , quarterly and annually based values of SR Created and Closed.Content I want to Create one …Preethi nair 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting & Analytics for B2C Service
-
Agent Workspace Report - display user running reportContent Hi all, I have a requirement to run a report based on the Contacts table, and at the end of the report I should output who ran the report. So it needs to look so…
-
Data Dictionary ReportContent Hi, is there any way to create a Data Dictionary report with detail and hierarchy to export?User_2025-02-03-18-56-40-556 55 views 3 comments 0 points Most recent by JBaxter Reporting & Analytics for B2C Service
-
Time with Customer vs. Time with AnalystSummary Time with Customer vs. Time with AnalystContent We would like to have two columns on a report to indicate how long a case was with a customer vs. time with an an…JLFolkman 37 views 3 comments 2 points Most recent by JLFolkman Reporting & Analytics for B2C Service
-
Report on Unresponded TicketsSummary Editing a ticket without responseContent There is a situation where the customer updates the ticket multiple times before getting a response. Can we develop a re…Boby B Jacob 25 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
Hide row if column contains a duplicate valueSummary Hide row if column contains a duplicate value in incident ref # columnContent Hi all. We have a report used by numerous agents. The report has a drill down based…User_2025-02-01-08-17-38-818 57 views 8 comments 1 point Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service
-
Want to include a Content Inventory Report in Incident Workspace with run-time selectable filter onSummary We want to include a Content details Report in Incident Workspace with run-time selectable filter on custom field from incident workspace (docId). We could not f…Utkarsh Dangayach-194615 27 views 2 comments 0 points Most recent by Utkarsh Dangayach-194615 Reporting & Analytics for B2C Service
-
In Console, Is it possible to select a record from report present in incident workspace and assign iSummary I have added a contacts report to the incident workspace tab. On doing search and selecting the contact, the contact should get inserted into the assigned field.…VISHNU KHATRI 32 views 0 comments 0 points Most recent by VISHNU KHATRI Reporting & Analytics for B2C Service