Custom Report
Discussion List
-
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 11 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 21 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 1 view 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 41 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 11 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 61 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 11 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 21 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 11 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. 11 views 1 comment 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service
-
How to show matching incident rows from two different join tables?We're working on a project where we want to add contacts to an incident, but we can't use secondary contacts because we don't want to automatically send emails to them. …Eric Gottesman 21 views 6 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Administrator Assigned Agent as Docked Filter for existing report: What table and how to?Summary:I added to a column after I have join the tables in a report and in a type column I added as filter: first(accounts.display_name, transactions.created). I also a…
-
Report showing all workspaces on each workflowSummary: I have tried to create or locate a report that will show me all the workspaces (IDs included) that are assigned or listed on each workflow. I have tried to crea…David_S 11 views 4 comments 1 point Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
Vertical line for sysdate in a Gantt chartSummary: Content (required): I'm using a Gantt chart to show the time between the start date and due date for various tasks, with the Date being the horizontal axis and …Robin Long 1 view 2 comments 0 points Most recent by Robin Long Reporting & Analytics for B2C Service
-
Table/Subject Area name which stores data for RoutinesSummary: Table name which stores data for Routines Content (required): Hi All, I need to know the base table/subject area(OTBI) which stores the information related to R…BhavikBhatti 31 views 1 comment 0 points Most recent by Premkumar Sabarinathan-Oracle Fusion Service -
Can you add a filter to the Customer Portal Search Report?Summary: Can you add a filter to the Customer Portal Search Report? Content (required): I'm looking to add a filter the search within our Customer Portal. Is there a way…kerry walker 11 views 4 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service
-
Is there a report which can tell agent used Fill my inbox to pull incidents?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Megha Nagpal 21 views 2 comments 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service
-
Draft versions of the answers were not retrived on the reportSummary: am trying to do the versioning of the answers and i followed the steps on this article Answer Versioning | Oracle B2C Service (rightnow.com) but when i try to m…Zahraa 11 views 4 comments 0 points Most recent by Premkumar Sabarinathan-Oracle Reporting & Analytics for B2C Service -
How to access Incident Id from within Search Report Custom script?Summary: Content (required): Hi, We have Organization Search Report placed on an Incident Workspace. During the creation of New Incident, we want to restrict some accoun…Chethana KM-139188 1 view 2 comments 0 points Most recent by Rakesh Das-Oracle Reporting & Analytics for B2C Service
-
Show report that sent by AdminSummary: Hi Guys, I know that we can schedule and send out a report. But is there any report or way to check a list of reports sent out under a specific Admin account or…Vincent Lin 11 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Error in POST data: Cannot run AnalyticsReport: XXXXX(ID=XXXXX): REPORT_ERROR_EXCEEDS_TIME_THRESHOLDHi All, We have a requirement to run the report under incidents object to fetch all the incoming email created incidents and list the queue that got assigned to it. This…Padma Varadarajan 421 views 3 comments 0 points Most recent by Padma Varadarajan Reporting & Analytics for B2C Service
-
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 2 views 3 comments 0 points Most recent by Vincent Lin Reporting & Analytics for B2C Service
-
The users completed surveies.Summary: A report shows all the surveys the user completes in a period of time. Content (required): Hi Here, I am trying to create a report that shows user completed sur…Vincent Lin 11 views 7 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
how to calculate time between interactions created date and response date?Summary: I want to know how many incidents are yet to be responded. for e.g we have SLA of 24 hours to respond. So how can i fetch a report which states that these incid…Megha Nagpal 11 views 2 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service