Custom Report
Discussion List
-
Report Incident Grouping by Servicing TimeHi all. I have a report that groups incident by servicing time (using the inc_performance table and appropriate interval type filter). Using the formula if(inc_performan…Lucas Zuzarte 18 views 4 comments 0 points Most recent by Lucas Zuzarte Reporting & Analytics for B2C Service -
Is there a way to undo changes within reports?Summary: Is there a way to undo changes within reports? Content (please ensure you mask any confidential information): I'm wondering if there is a way to undo the most r…kerry walker 16 views 0 comments 0 points Started by kerry walker Reporting & Analytics for B2C Service -
Help with report chartsSummary: Looking for help utilizing charts in a report Content (please ensure you mask any confidential information): I'm wondering if anyone can point me to a video tut…kerry walker 14 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Record of who exported which reports?Hello, How can I tell which internal users exported which reports from OSC? Thanks, Patrickptolbert 12 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle General Technical Discussions
-
Data Model stuck and need to rerunSummary: We have a report that generated only the deleted record but for the new and changed record it was not included in the file. However when I rerun the data model …Cristelle Rose Sampang 2 views 2 comments 0 points Most recent by Cristelle Rose Sampang Reporting & Analytics for B2C Service
-
Are there any report to extract knowledge advance article ?Hi There, I am wondering if there are any reports that I can use to extract knowledge advanced articles created by all authors. I try to look through all the tables in t…Vincent Lin 52 views 5 comments 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
Is it possible to print one record per page in BUI?Summary: I have a report with a number of columns that we display in "record" format rather than "tabular" format as the required layout for the end users. In Agent Desk…Craig Hevey 2 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Report to show queues with no agents assigned?Summary: We have a BOATLOAD of queues to manage. Looking for a report to flag any queues that have no agents assigned to them. This would exclude agents disabled in the …Joe P. 12 views 1 comment 0 points Most recent by Makarand Malandkar Reporting & Analytics for B2C Service -
Can we change report standard date format using date_formatSummary: Hi We are trying to change the standard way of displaying date i.e. 09/26/2023 10:27 AM EDT in the report analytics the same way we have in CP or in Connect Obj…Baljeet Singh-231094 22 views 3 comments 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service -
CSAT score report - giving score, comments and agentSummary:I need very quickly to provide a CSAT survey report that can show the surveys answered within a certain timeframe Content (please ensure you mask any confidentia…Howard Williams 14 views 2 comments 0 points Most recent by Howard Williams Reporting & Analytics for B2C Service
-
Add values from two aggregate columsSummary: In a report where two columns are [Total B] = sum_distinct(B.score, by A.ID) and [Total C] = sum_distinct(C.score, A.ID), how do I create a third column that ho…Scott Heidenreich 12 views 2 comments 0 points Most recent by Scott Heidenreich Reporting & Analytics for B2C Service -
Analysis with link to attachmentsSummary: Download attachments from an analysis Content (required): Hello, the customer required to have the possibility in a pre existent analysis regarding SRs to downl…carolagalloni 11 views 4 comments 0 points Most recent by carolagalloni Reporting & Analytics for B2C Service -
Moving ReportsSummary: Are there any negative affects to reorganizing the folders in reports explorer? Content (required): Are there any negative affects to reorganizing the folders i…kerry walker 12 views 2 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
count multiple customer replies in a rowSummary: I am trying to make a report column that displays the LATEST count of customer replies. Content (required): The aim of the report column is to see if incidents …SDP 12 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Report RequirmentHi Experts, We just had a report requirement to pull Employees latest salary as well as previous salary. Does anybody have the logic or the sample report to achieve the …Sreeram V 2 views 1 comment 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service
-
how to add incident reference number into proposed answerwe have a requirement when an incident is proposed as an answer is there any way we can add it into notes of answer automatically (or)we can add new tab into workspace a…Santosh kumar purusottam 21 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Agent Desktop
-
Hi is there any report for ODA in Oracle Service cloud(.Net Console)Summary: Is there any report I can download or use in the Oracle Service cloud to report on ODA? Content (required): Hi All, We recently launched ODA for Chat in the Ora…Vincent Lin 12 views 4 comments 0 points Most recent by Jess Campbell Reporting & Analytics for B2C Service
-
How to remove link from two level report?Summary: Two reports with slightly different definition: the first is one level 'Report Definition One Level' and the second report has two levels 'Report Definition v3'…TinaB 1 view 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Multiple Duplicated for each column in report including Incidents and Threads tablesSummary: I build report with innerjoin b/w the tables incidents and threads. The report even with filters when pulled it shows multiple duplicates for each existing colu…
-
Customer Log in Stats on CP pagesSummary: My customer uses multiple CP launch points but one of which involves the customer to log in to access the functionality provided by the custom objects. We have …Colin Campbell-118909 22 views 2 comments 1 point Most recent by Colin Campbell-118909 Reporting & Analytics for B2C Service -
Can the service usage metrics reports be run via API and automated?Summary: Ive got anywhere from 20-30 active distinct instances and having to log into each and every one monthly to run the same report is a giant waste of time. Content…Justin_D 22 views 1 comment 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service -
Show incident and tasks in record viewSummary: I want to display a single incident in Record view and below it al its tasks. Content (required): I want to display an incident, say reference number, status, s… -
Report of incident after a ticket is closedSummary: To track the incidents post closure activity like reopening/ updated... Content (required): Suppose a ticket is been closed and later it got reopened. I have to…Boby B Jacob 21 views 2 comments 0 points Most recent by Boby B Jacob Reporting & Analytics for B2C Service -
How to track number of users visiting on any learning item (any offering) ?Summary: Hi experts, is there any way in HCM SAAS product -> Learning module , where for any offering item (any course/activity) , we can track the users who are just vi…
-
what are tables in fusion to identify the Supplier B2B detailsSummary: what are tables in fusion to identify the Supplier B2B details Content (required): what are tables in fusion to identify the Supplier B2B details Version (inclu…Smandanak 42 views 2 comments 0 points Most recent by Smandanak Reporting & Analytics for B2C Service
-
How can I remove the text "Contains any" from the filter?Summary: I want to remove the "Contains any" text from the filter. as shown in the screenshot: thanks.Alfredo 42 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Distinct Records in Consolidated DashboardHi, I have 2 reports with same columns & filters from different tables. I want to combine into one report. I am using Consolidated Dashboard option with distinct values …Mohana Gopal S-Oracle 31 views 1 comment 0 points Most recent by Junie Rose Bodoso-Support-Oracle Reporting & Analytics for B2C Service
-
Turn Around Time calculation with 60/60/10.5 Extending Response TimeSummary: I'm trying to extend the response times to incidents. Not able to find anything in any forum that can assist. As example what I'm trying to accomplish here is w…
-
Get a list of documents information from report.Content (required): Hey Guys, I am in the process of cleaning up Oracle's document which lives in Document Explorer. And since we have a lot of document, I wonder if the…Vincent Lin 42 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Mailing Name and Document Links with Attachment Report not showing in the BUI?Summary: I build new Outreach Report for Representatives to view in a workspace in the BUI. I'm using the mailings table with the rest. For some reason the inner join pu…