Reporting and Analytics
Discussion List
-
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 36 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 67 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 937 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 12 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 17 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 33 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 24 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 22 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 42 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 54 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 72 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 39 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 14 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 26 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 54 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 44 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 28 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. 9 views 0 comments 0 points Most recent by Christos S. Reporting & Analytics for B2C Service