Custom Report
Discussion List
-
Show current system Date and time if value is nullHi, I’m working on an Oracle Service Cloud (OSvC) report and need to create an SQL expression which should show SystemDate or better Current Date and time I tried the fo…Monfernos 11 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
how to add a column for who closed incident in a reportHi, I need to add a column in a report. How to get incident closed by details in a report? Regards, MeeraMeera Saseendran T 14 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
How to add total in custom reportHi, Like above report, I need to show total in a report. How to do that? Regards, MeeraMeera Saseendran T 13 views 1 comment 0 points Most recent by Anuj Behl 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 12 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting & Analytics for B2C Service -
Report to get the contact details from the system using mail domain as filterSummary: Hi , I have a report requirement in the Oracle B2C console where I will be feeding the customer email domains. It may be 1 or many, depending on the requirement…Boby B Jacob 12 views 2 comments 0 points Most recent by Boby B Jacob Reporting & Analytics for B2C Service -
SQL query for Time Entries with Payroll result for the selected periodHi All, I have a requirement to fetch the columns as attached in the excel screenshot. The challenge i'm facing is i'm not aware how to join the Time Entries with Payrol…Dilip.Murugan-Oracle 23 views 0 comments 0 points Started by Dilip.Murugan-Oracle Reporting and Analytics for HCM
-
Is there an automated way we can view the updated date of standard texts?Summary: I am trying to get a list of all of our Standard Texts along with the date each was last updated. If I go into the Standard Text editor in the .NET console, I c…Andrew! 13 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
Error on workpsace after adding a reportHi, Iam getting this error after adding report in workspace tab The report contains the following errors: -found flat branch for grouped parent You will need to edit the…Meera Saseendran T 12 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
how to add actions in reportHi, How we can add actions like open and delete ina report ? like below: Regards, MeeraMeera Saseendran T 24 views 2 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Capacity chartHi, I need to create a capacity chart. •For incidents without a task, use the Due date to allocate the effort into the weekly intervalFor incidents with tasks, use the t…Meera Saseendran T 13 views 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
how to fetch 3rd level of categoryHi, I need to add 3rd level category to a script for showing it in incident workspace. WHich field to choose for this? Regards, MeeraMeera Saseendran T 2 views 1 comment 0 points Most recent by James Branston Reporting & Analytics for B2C Service
-
Report showing 2 separate rowsSummary: Created a report including incident and Incident Performance tables to display; First Assigned User Account First Assigned User Group First Customer Response Us…Ashutosh_86 32 views 3 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service -
Hi all, in bursting can I put the dynamic file name? example concatenate it to today's launch date!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…Emanuele De Marchi 3 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for B2C Service
-
we have requirement to pull the data from Fusion Custom Apps Lookup. Is that same Fnd_lookup_valuesSummary: we have requirement to pull the data from Fusion Custom Apps Lookup. Is that same Fnd_lookup_values or do we need to pull differently? Content (please ensure yo…ITOffshoreDeveloper 12 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
how to calculate incident edit time for each transactionsSummary: Hi, I need to create a report for getting incident edit time of an incident. edit time for each agent in same incident is needed. Regards, Meera Content (please…Meera Saseendran T 13 views 2 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
How to get the assignment number from the time card entry page ?I have a requirement to get Assignment_Number from time card entry page and not on person level. please find screenshot for reference.AbhinavA 13 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
where Knowledge advanced is in active use - understand the actual usage volumeHi, I need to create a report to review the current use cases where Knowledge advanced is in active use - understand the actual usage volume Regards, Meera
-
I need a custom script to capture a assigned time of a ticketHi, For a Response SLA report, we are capturing stop time as min(transactions.created). But there is a problem where incident reaches to wrong queue first and assigned t…Meera Saseendran T 34 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
How to create a report for find for each sla what all holidays are selectedHow to create a report for find for each sla what all holidays are selectedMeera Saseendran T 11 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service
-
Default report in navigation setHi, I need to findout which is the default report in a navigation set. Is there any way to find out using a report? Regards, MeeraMeera Saseendran T 21 views 1 comment 0 points Most recent by Gabriela Musat-Support-Oracle Reporting & Analytics for B2C Service
-
customscript in reportsSummary:Hi, How to know which all reports are using custom script?any way to find via report? Thanks Content (please ensure you mask any confidential information): Versi…Meera Saseendran T 21 views 1 comment 0 points Most recent by Tushar G Reporting & Analytics for B2C Service
-
How to find a contact if logged in through sso or email?Hi, I need to know a contact is logged in using sso or email id. How to find that? Regards, MeeraMeera Saseendran T 31 views 3 comments 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
Is it possible to report on the value in the Staff Account Profile Session Timeout field?Summary: Is it possible to report on the value in the Staff Account Profile Session Timeout field? Content (please ensure you mask any confidential information): I need … -
summing up all the columns in a cross tab reportSummary: I want to add the result of all the columns in the pivoted table to a new one, say Total. How do I do that? Content (please ensure you mask any confidential inf…Boby B Jacob 41 views 5 comments 0 points Most recent by James Branston Reporting & Analytics for B2C Service
-
what is this 3 lines symbol in report buiSummary: Hi, I could see a 3 lines symbol in the report header for a column, which I didnt see before. Please help me to understand what is this used for? Content (pleas…Meera Saseendran T 31 views 3 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
How to filter category dynamically in search filter when a product filter value changesSummary: Product and Category filter in analytics to behave exactly as they behave in workspace Content (please ensure you mask any confidential information): Hello All,…Rakesh Das 51 views 2 comments 0 points Most recent by Rakesh Das Reporting & Analytics for B2C Service
-
Searching Thread for KeywordsSummary: Hello, I have a report that searches the thread of each incident (using incidents.search_thread with the "LIKE" operator) to search for specific keywords. This …Lee Tympanick 31 views 2 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service
-
how to fetch latest response from threadHi, I need to create a report with latest response send to customer. There are private notes and repsonses. But I need only latest response in report. How to fetch that?…Meera Saseendran T 41 views 4 comments 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service
-
Oracle BIP Report Email Delivery to Outlook Distribution ListSummary: We are attempting to use Outlook Distribution listings in report delivery associated with BIP report schedules, but they will not deliver. The jobs complete suc…Jared Custer 62 views 2 comments 0 points Most recent by Jared Custer Reporting & Analytics for Fusion Service -
REPORT_ERROR_VIEWS_ENGINE errorHello All, I am trying to POST the report results through analyticsReportResults REST APIi. But unfortunately i am facing the "REPORT_ERROR_VIEWS_ENGINE " error .But whe…Kiranprasanna Dhanasekaran 61 views 4 comments 0 points Most recent by Tushar G Reporting & Analytics for B2C Service