Reporting and Analytics
Discussion List
-
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 551 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Adding or substracting currency values in report (console)Summary How to add currencies or substract them for display in report (console)Content Hi there, Need to make a report that adds currency values per month so I get a cum… -
Multiple if conditions in filterContent I'm trying to build a filter that will result in different queues being selected based on the Group of the individual running the report. It would be something l… -
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 28 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 …User_DI4E2 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 799 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 40 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 66 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 935 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 10 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 61 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 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