Custom Report
Discussion List
-
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 3 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 2 comments 0 points Most recent by Santosh kumar purusottam 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 11 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 21 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 11 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 41 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 41 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 Selvam-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 41 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…
-
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 …
-
Remove Closed Incidents from Report ViewSummary: I have added report, where representative closes the incident, but the incidents stays in the report and is visible. Is it possible to remove the incident from …
-
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 …
-
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…
-
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 41 views 4 comments 0 points Most recent by Jepee Celorico Reporting & Analytics for B2C Service
-
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…
-
Variable based on Employee logged inSummary: We believe we need to use a variable based on who is logged in to the system so we can detemine the type of work Content (required): A team wants to use Tasks a…Jeff Scrobel 21 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service -
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 61 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
My Queued ReportsSummary: I have a report that are stuck in Processing state, so I beleive this is stopping me from running this report again. Content (required): How can I delete the re…Jeff Scrobel 41 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Help with report - answers last accessed by users in specific profileSummary: Help with report - answers last accessed by users in specific profile Content (required): Hello. I am trying to write a report that shows the last time an answe…kerry walker 71 views 5 comments 0 points Most recent by kerry walker 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 41 views 1 comment 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service
-
How to pull in a column full name of ctype_id=10 the main name not the representative the name =10?Summary: I have build a report and trying to pull with if(contact.ctype_id=10). I tried substring but it doesn't work, I guess I didn't make the correct combination of c…TinaB 31 views 6 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
How to report on a Text Formula Field in OTBISummary: A new Text Formula field will not show up in Reports and analytics, oracle manual says this is not possible but I'm curious if anyone has found a way around it.…Pete.Sterchak 31 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Incident performance data Filter Through AnaylticsResults APISummary: By Pass 10,000 records AnaylticsResults API limit Content (required): Hi Guys, The AnaylticsResults API has a limit of 10,000 records per run. We have an integr…Sylvia S. 31 views 1 comment 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service