Reporting and Analytics
Discussion List
-
Reporting on chats without incidentsSummary How to create a report showing chats added to incidents after creation.Content Hi. We have a report today that shows all chats that does not have a a link to an …Hugo Angelow 22 views 4 comments 0 points Most recent by Hugo Angelow Reporting & Analytics for B2C Service -
Need a query to get Remit to supplier name for a given supplier.Content Hello all, I want to know where I could get the Remit-to-supplier name mentioned in the supplier management page in Oracle Fusion. I have got to tables joined, p…Sushan Peiris 1.1K views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Combine reporting on Incentive Compensation attainment, participant details, and plan assignmentsSummary Looking for help with ideal subject areas and tips/tricks to report on three areas simultaneously: achievement, participant details, and plan assignments.Content…User_2025-02-01-07-27-35-188 20 views 2 comments 0 points Most recent by User_2025-02-01-07-27-35-188 Reporting & Analytics for Sales -
Which table captures CC contacts while sending agent responsesContent Hi All, Which table captures CC email addresses of each agent response. kindly advise.Ajay Yadav-140866 40 views 3 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Hide Ribbon Options on ReportsContent Is it possible to hide one of the options, like Forward from the Ribbon of a report? For example, I have a report open, called My Inbox, which displays a list of…JLFolkman 51 views 3 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Is There A Way To Un-Retire A Lead?Content Hi, What are the ways we can un-retire a lead? Thanks, Ed Version 20D -
How can I add the Report ID to the report?Content Hello everyone! I need a way to add the report's ID # to the report. I am dealing with hundreds of reports and in the process of cleaning them up. However, havin…User_2025-02-01-08-18-48-897 70 views 7 comments 1 point Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
Trim leading training spaces in reportSummary How to trim leading and trailing spaces in a report fieldContent Hi all, I am trying to trim a report field's leading and trailing spaces. I am dong ltrim(rtrim(… -
Error in Initialization Code Undefined index: HTTP_HOSTSummary Custom Script Error in Initialization TabContent Hi, I tried calling custom script file from custom report using Custom Scripts Under Level Tab. I used the follo…Baljeet Singh-231094 37 views 0 comments 0 points Most recent by Baljeet Singh-231094 Reporting & Analytics for B2C Service -
Opportunity Assessments - AnalisysSummary Opportunity Assessment template - AnalisysContent Hi all, I need to create an analysis in OTBI where it shows by Opportunity the values entered in the assessment…
-
Brokerage Security within ICMSummary Brokerage Security within ICMContent How can you apply security within ICM? We have a requirement for only certain people to see certain brokers, can you do that…Andrew_Schmitz 13 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Between 2 Figures in an ExpressionContent I have this expression as well as another one where it has > 48. How I do one for between 24 and 48? sum(if(date_diff(sysdate(),incidents.created)/3600User_2025-02-05-10-15-05-593 25 views 3 comments 0 points Most recent by User_2025-02-05-10-15-05-593 Reporting & Analytics for B2C Service -
Initial Resolution Time calculation Excluding 'Waiting' status timeContent Hi Experts, We have one requirement where we need to calculate Resolution time i.e., total Initial resolution time for an incident. i.e. from the Incident Creati…User_2025-09-05-00-11-37-622 51 views 1 comment 2 points Most recent by User_2025-02-10-10-44-44-497 Reporting & Analytics for B2C Service -
How we can display the forecast vs quota by the quantity not by the amountContent Need to display the graph by quantity -
Send report to FTP serverContent Can we automate BI report to be sent to FTP server? Using Oracle Sales cloud version 21A Use case: We need few reports created using analysis or BI publisher to …User_2025-02-04-10-48-17-393 61 views 2 comments 0 points Most recent by Very Nice Name Reporting & Analytics for Sales -
Custom HRHD Fields in OTBIContent Hello, We have some custom fields we created for HRHD most of which show in OTBI. We have two fields for Primary contact BU and Person Number which are groovy fo…User_2025-01-31-00-25-12-234 43 views 4 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Fusion Service -
ReportsContent Hi All, Can we implement the below reports in Service Cloud? * Report to see how many incidents have been closed and then re-opened? * Report to see how many tim…User_2025-02-10-15-50-53-070 27 views 2 comments 0 points Most recent by User_2025-02-10-15-50-53-070 Reporting & Analytics for B2C Service -
Skipping a row to be displayed when having no value (report custom script)Summary I want to prevent showing records having no products and categories assigned in answer reportContent Hi there, I have question about a report in which I want to … -
Single-line summary of mailings by contact?Content I've combed the Analytics thread and Outreach reports, but can't seem to find what I imagine ought to be a pretty basic report we are very interested in. The clo…Christos S. 8 views 0 comments 0 points Most recent by Christos S. Reporting & Analytics for B2C Service -
Time in status - only for incidents with a particular statusSummary Only report on incidents that include a particular status (not status type)Content Hi all. I am using the Time in status report (found here: https://cloudcustome…User_2025-02-01-08-17-38-818 73 views 0 comments 0 points Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service -
Set Default Selection of Owner Prompt to Currently Logged-in UserSummary Set Default Selection of Owner Prompt to Currently Logged-in UserContent Hi, I want the currently logged-in user to be the default selection of Owner prompt I cr…User_2025-07-18-06-07-44-367 53 views 3 comments 0 points Most recent by User_2025-07-18-06-07-44-367 Reporting & Analytics for Sales -
Dashboard Filters Not Updating As ExpectedSummary I am trying to make updates to some dashboard report filters and they are not being saved and/or are somehow holding on to previous settings.Content I am trying … -
Is there any rest api to run the report and download outputSummary Rest api for BI analysisContent Hi, Is there any rest api availbe to run and BI analysis and download the output. eg: Lead analyis Regards, Sudheer. -
View analytics around sent emailsSummary How do I know that emails were sent?Content Hi, Let's say I use ConnectPHP to send 1000 emails in batches of 200. Currently, a lot of people from each batch are …King Jack 34 views 1 comment 1 point Most recent by Gursimran Singh Saini Reporting & Analytics for B2C Service -
How to capture existing Report name and Data model details in BIP ReportSummary How to capture existing Report name and Data model details in BIP ReportContent Hi All, We are having a requirement to develop the BIP publisher report which wil…Rohit Soni-259808 100 views 2 comments 4 points Most recent by Rohit Soni-259808 Reporting and Analytics for SCM -
Is there a way to hide / remove the limit and order options for a report?Summary Need to be able to limit the number of records that an agent can see with a blank search using a custom contacts quick searchContent The quick search is useful t…Adam Neale 30 views 4 comments 1 point Most recent by Adam Neale Reporting & Analytics for B2C Service -
Get Time difference from same report columnSummary Get time difference for same incident ID but in same columnContent Hi I have incident ID and Adjusted time column in same report. Same incident ID has two time r…Baljeet Singh-231094 30 views 5 comments 0 points Most recent by Sarah Oracle-Oracle Reporting & Analytics for B2C Service -
Fetch only new or updated data from Last runContent Hi All, I am very new to Reporting hence need help to devlop report to fetch only incremental data. Report Logic: 1) Report will be called by Webservice by passi…Mayank Pande 114 views 1 comment 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM