Reporting and Analytics
Discussion List
-
Add the body of the ticket in a reportSummary I want to add the text-body of the ticket in a reportContent Hello All, I'm trying to create a report for all the tickets created in the last year that will have…Jenica Dracea 36 views 5 comments 0 points Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service -
Dashboard prompt shows Deleted records InformationSummary How to avoid deleted records information in dashboard promptContent Hi, I have created an OBIEE report where as deleted records available in dashboard prompt not… -
Phone search field with or without hyphensContent Many of our contact phone number have hyphens and more do not. I cannot find a solution for agent to search for a contact by phone number without them needing to…User_2025-02-03-19-05-39-651 50 views 4 comments 0 points Most recent by InSinkErator Reporting & Analytics for B2C Service -
Incidents report with Answers SummarySummary Creating a report joinning two tables with no common fieldsContent Hello! I can´t find a way to add the title of an answer (answers.summary) into the incident's …User_2025-02-06-21-26-19-557 32 views 6 comments 0 points Most recent by User_2025-02-06-21-26-19-557 Reporting & Analytics for B2C Service -
Masking functionality in ReportsContent Masking functionality in Reports Do we have any functions in OTBI/OBIEE or in BI Publisher/Templates/XSL functions to perform a masking functionality for some cu…Shivakumar Ayyanagowdar-Oracle 59 views 7 comments 1 point Most recent by Karina Ogata Reporting & Analytics for Sales -
column header is randomly ordered in the csv output for BIP reportSummary BIP reportContent Hi, I posted this a while ago. I wonder if there is a change on 20B. Here is the issue detail, I created a BIP data model with SQL (e.g. select… -
Create Infolet through BI analysis to get PO count created for the daySummary Need to create an analysis to get today's PO created count based on userContent I created a analysis to get the buyer wise PO count. But it gives the as at date … -
Returning More than 10k Records on Scheduled ReportContent All, We have a report that runs every night that displays new records created in one of our custom objects in the past 24hrs. This report emails itself to a hand… -
Difference between ProductGroupItemId ,ProductGroupId, ItemCatalogGroupid columnsSummary Difference between ProductGroupItemId ,ProductGroupId, ItemCatalogGroupid columnsContent Hi I have exported ProductGroupItem data and Product data from export ma… -
Emails Received - Exclude Client Response to Auto Reply and Thank You ResponsesSummary Exclude Client Responses to Auto Replies and "thank you" responses to solved incidentsContent I am trying to update the Emails Received report to count the numbe…User_2025-02-07-10-02-12-918 35 views 0 comments 0 points Most recent by User_2025-02-07-10-02-12-918 Reporting & Analytics for B2C Service -
Setting up multiple reporting schedules for different time periods within the same day.Summary Unable to change VRL_HARD limit, needing a workaround.Content Hi, I need to craft several reporting workarounds to report on previous days data via scheduled run…User_2025-02-05-08-03-16-850 22 views 6 comments 1 point Most recent by Tushar G Reporting & Analytics for B2C Service -
Events at same second sorting incorrectly. Any way to go smaller than seconds in date_format?Content Hi, I've found when reporting on the chat_events table & sorting output by chat_events.created that two posts with the same second can be shown out of order. The…User_2025-02-03-20-01-45-901 18 views 2 comments 0 points Most recent by User_2025-02-03-20-01-45-901 Reporting & Analytics for B2C Service -
Forward reports using non-default mailboxSummary Looking for a way to optionally forward analytics reports from a mailbox other than the default for that interfaceContent Being able to send specific types of re…Jared Terry 34 views 1 comment 1 point Most recent by User_2025-02-01-08-46-19-550 Reporting & Analytics for B2C Service -
Catch/close "redundant" incidents that solve themselves?Summary Any ideas to recognize Incidents after customer reports issue is resolved?Content Hi All - in ecommerce, a large source of customer incidents is "Where's my orde… -
Ship to Org LOV not returningSummary I am able to run a report from the Procure to Pay Real Time subject area and the column returns Organization Name, but the same column in the parameter does not …Ari 32 views 2 comments 0 points Most recent by Alexandra Andrei-73074 Reporting and Analytics for SCM -
Emailed Report ErrorSummary Scheduled report sending Excel opens with warningContent Hi all, We have a really simple report that is scheduled to run once daily. The report contains only 3 c… -
Send email reminders to inactive usersSummary We would like to send reminders by email to users if they do not login to Sales CloudContent Hi What would be the best way to automatically send an email to inac…Cyrille Saulnier-Oracle 50 views 5 comments 1 point Most recent by Ryan Peterson-126136 Reporting & Analytics for Sales -
Best Practice Guide - How to Improve Reporting Performance in Oracle Service CloudContent Attached to this post is a revised best practices document that specifically deals in optimizations and report performance within Oracle Service Cloud. Included …Kenny Tietz-23935 546 views 8 comments 29 points Most recent by Adam Liu Reporting & Analytics for B2C Service -
How can I check if an outbound email sent to a customer bouncedSummary How can I check if an outbound email sent to a customer bounced and what is the reasonContent I am looking for a way to check if the outbound emails sent by Enga… -
Dashboard/Reports/KPI would be used by the executive via Sales VPSummary Dashboard/Reports/KPI would be used by the executive via Sales VPContent HiWhat Dashboard/Reports/KPI would be used by the executive via Sales VP. Can someone sh…Varun-CC 41 views 2 comments 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
SCM Report queriesSummary I would like to know where i can find a repository of report queries for this subject area.Content I would like to know where i can find this information for Pro…User_2025-01-25-06-03-46-894 97 views 4 comments 3 points Most recent by User_2025-01-25-06-03-46-894 Reporting and Analytics for SCM -
Related objects in CSASummary Related objects in CSAContent Hi, As per the following document, I should be able to add fields from related object (CSA creation train stop step3) if I create M… -
Report Editor, Home > Records is not showing custom tableSummary Connected workspace opens for one report but not for anotherContent On a report A when you double click the record it opens a workspace for the connected custom … -
Report: Queue-Change - Exclude resolved IncidentsSummary Hey @ all. I'm still creating a report to get the correct count of incidents which leaves a queue unresolvedContent Hey @ all. i wanna show my Managers what happ…User_2025-02-07-09-56-35-224 32 views 4 comments 1 point Most recent by User_2025-02-07-09-56-35-224 Reporting & Analytics for B2C Service -
Trending # Opportunities and RevenueSummary Need to show trends over time what was open in terms of opportunities and RevenueContent Hello, I'm wondering if anyone has tried to do this yet with the Sales O…User_2025-01-22-20-09-02-352 40 views 5 comments 1 point Most recent by Karina Ogata Reporting & Analytics for Sales -
Combine Subject AreasSummary Trying to combine Snapshot SA with Pipeline SAContent Hello, I need to combine the Pipeline SA with the Snapshot SA. "Sales - CRM Pipeline" with "Sales - CRM Opp…User_2025-01-22-20-09-02-352 44 views 4 comments 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Show Percentages of crosstab column Total?Summary Need help creating a view that show trending over time (daily, weekly etc) in the % split of our Product IDs..Content I know this is possible but seem to be unab… -
"Sales - CRM Opportunity Sales Stage Snapshot"Summary Details of # of Opportunities Fact in the SAContent Hello, Can anyone tell me what the # of Opportunities Fact in the "Sales - CRM Opportunity Sales Stage Snapsh…User_2025-01-22-20-09-02-352 41 views 3 comments 1 point Most recent by User_2025-01-22-20-09-02-352 Reporting & Analytics for Sales -
Creating a custom report with a date range in the outputSummary 1-6 days passed SLA, 7-10 Days passed SLA, 11-14 Days and 15 or greaterContent Hi friends, I am trying to create a report with incident data where I am checking …NJ 43 views 3 comments 0 points Most recent by User_2025-02-03-17-31-49-785 Reporting & Analytics for B2C Service -
Schedule a half month reportSummary schedule a report that shows 16th to end of monthContent Hi, does anyone have an idea if it is possible to schedule a report based on hard-set half month? So the…User_2025-02-03-16-51-39-328 30 views 0 comments 0 points Most recent by User_2025-02-03-16-51-39-328 Reporting & Analytics for B2C Service