Reporting and Analytics
Discussion List
-
Filter a Report by Roll UpsSummary How can I only show roll-ups with 2 or more itemsContent I have a report that shows contact details and the incidents associated with them. I only want to see re…user3511667 29 views 3 comments 0 points Most recent by Sasi G Reporting & Analytics for B2C Service -
Cross Tab Sort by Month Name and Year?Summary Is it possible to sort Cross Tab Columns correctly by Month Name and Year?Content I run into this problem all the time where I am not allowed to sort Month/Year …NDKoze 33 views 1 comment 1 point Most recent by Lakshay Bhalla Reporting & Analytics for B2C Service -
SOLVED Report with incidents with/without dispositionContent Hi everyone, I'm quite new to making reports so this may be a stupid question. I will ask anyway.. We have just taken disposition into use in our system. In one …Anna__B 38 views 4 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
How to create a label called "ALL" when selecting all from a parameter in BI reports.Content Hello all, I want to know if there is any way that I could display a word called "ALL" when I select all from a LOV of a parameter in the BI report in ORACLE FUS…Sushan Peiris 807 views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Count if on countSummary i want to calculate count only if its count is more than oneContent i want to have a count only if the incident status was closed more than once.Megha Nagpal 48 views 7 comments 0 points Most recent by Megha Nagpal Reporting & Analytics for B2C Service
-
How to embed hyperlink from OTBI report - data column field into Apps Composer CRM custom formSummary I need the ability to drill into some Custom App Composer CRM data from a Dashboard Report on that data set. Non Standard Oracle Cloud App FormsContent I need th…User_2025-01-30-01-01-15-242 33 views 2 comments 0 points Most recent by User_2025-01-30-01-01-15-242 Reporting & Analytics for Sales -
Rules in a reportSummary Adding conditional rules to search reportContent For our contact search I would like to add a rule so we can control search results based on login ..... for exam…JaneSolihull 42 views 4 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
Is it possible to send two attachments in single bursting?Summary Is it possible to send two attachments in single bursting?Content We had a requirement to send same output with two different formats (Ex: Excel and PDF). we nee…Koteswararao Yenikepalli 69 views 4 comments 0 points Most recent by User_KM4LK Reporting and Analytics for SCM -
Query to find Product Family of ItemSummary Query to find Product Family of ItemContent Hi All I wanted to find the table or query which hold the Product_family details of an items: Below is the screenshot…User_2025-02-11-07-07-59-045 941 views 1 comment 0 points Most recent by User_2025-02-11-07-07-59-045 Reporting and Analytics for SCM
-
Group id for created bySummary where can i get the group ID for created byContent i want to build a report which tells me the group ID of created by . i can see the group ID for assigned to ac…Megha Nagpal 11 views 3 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service
-
See what status type an incident had at a particular time?Content Hi, Currently using this formula but it's using the status and not status type (Solved, Unresolved, Waiting etc) last(if(transactions.trans_type='Created', 'New'…King Jack 15 views 3 comments 0 points Most recent by Rasheed Ahamed Reporting & Analytics for B2C Service
-
The filter contains a reference to a pseudo field so no index information is available.Summary Trying to understand what this meansContent We are in a place now where we have 7mm plus incidents, so our reporting cannot be simple any longer. On a report try…Jeff Scrobel 30 views 1 comment 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Attachment Update issue in OECSummary Attachment Update issue in OECContent Hi, In Engagement Cloud Post creation creation of Work Order. Activity gets created in Field service against which, the att…User_2025-01-31-00-30-32-814 62 views 0 comments 0 points Most recent by User_2025-01-31-00-30-32-814 Fusion Service
-
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 21 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 71 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 62 views 2 comments 0 points Most recent by Very Nice Name Reporting & Analytics for Sales