Functions
Discussion List
-
i need to show only the incident' which having incidents.closed==transactions.createdSummary: What is the condition for show only the incident' which having incidents.closed==transactions.created. Content (please ensure you mask any confidential informat…Meera Saseendran T 31 views 3 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service -
How to export a Multi Grid FRS report into an Excel where each of the grid is in different sheet?Summary: Had a requirement of having to export a multi grid FRS report into different sheets of the same excel workbook in the same order that the grids are placed in th…Amithhari 51 views 4 comments 0 points Most recent by Baidehi Nanda–Support-Oracle Reporting & Analytics for B2C Service
-
export knowledge advance schema dataSummary: Hey Guys, I wonder if there is any way we can export the schema value of the knowledge advance content type? We can add a new schema into the content type in or…Vincent Lin 51 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for B2C Service -
Prod incident created after reply an email to test site CRM incidentSummary: Hi everyone, I met a bug in test site CRM, when I reply an email as customer to the test incident, no message thread create in the incident, and I received an e…
-
using inc_performance type=7 gives duplicate rowsSummary: When adding the first closed date from the inc_perf table to my report, I get two rows for every solved incident, one with a closed date and one with no closed …
-
Local Account Password RequirementsSummary: how to: 1. List all non-SSO accounts in Fusion and their last password change date 2. force password change after every 90 days 3. force a complex password (min…
-
how to create multi edit reportSummary: I need to create report for editing a contact of a incident. For that I need to enable that report with multi edit. How to do that? Regards, MeeraMeera Saseendran T 11 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
A report which shows incidents with latest updatedSummary: I need to create a report with incident details. The user needs to see the latest queue change happened. I can see multiple records with one incident as queue i…Meera Saseendran T 21 views 2 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
I need to extract profiles using a particular addin using reportSummary: I need to create a report for extract profiles which are using a particular addin Content (please ensure you mask any confidential information): Version (includ…Meera Saseendran T 1 view 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
how to extract a report for sso and non sso profilesSummary: I need a report for finding sso profiles and non sso profiles. How to create that? Also which is the field for finding last login date for a staff account? Cont…Meera Saseendran T 31 views 2 comments 0 points Most recent by Levi Dyckman-Support-Oracle Reporting & Analytics for B2C Service
-
I am getting an error on creating child case like "Unable to load search results"Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Meera Saseendran T 11 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Is there any way that i can copy a asset within Incident workflow?Summary: Hey Guys, Currently, I am developing a workflow process to copy and assign an incident to a contact that I select. What I found is that if there is an asset whi…Vincent Lin 31 views 1 comment 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for B2C Service
-
I have requirement to have a pop up box/window should come after a button click.Summary: In a workspace, there is button to send reply to user(using integration). So when button clicks, pop up a dialogue box/window. In that we need to show a standar…Meera Saseendran T 21 views 5 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
Can agent reply to specific message like facebook message in Oracle b2c live chat?Summary: Hi Guys, Do you think Oracle b2c agent live chat has a feature that supports agents to reply to a specific message? Like Facebook messager, when there are multi…Vincent Lin 21 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle 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 …
-
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 31 views 4 comments 0 points Most recent by Lucas Zuzarte 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 32 views 3 comments 0 points Most recent by Rasheed Ahamed 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…
-
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…
-
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…
-
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…
-
how can i have todays date in Oracle broadcast emailSummary: 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 31 views 2 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 21 views 2 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service