Reporting and Analytics
Discussion List
-
First Time Chatter ReportSummary We are needing to keep track of "new" chattersContent I am trying to count the amount of new people chatting into the call center. We are trying to account per o… -
Field value is not displayed in report when record is created using REST APIContent Hello Members, We are creating few opportunities using REST api. We have a DCL field on opportunity which refers to promotions object. When we create a record us… -
Report to show who has assigned an incident on to another person or groupSummary Report to show who has assigned an incident on to another person or groupContent Hi i currently have a report which counts the number of incidents solved and uns…User_2025-02-03-18-05-12-461 61 views 5 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Incident Closedby ReportContent Hi Gurus, How to capture the closed by account in reports? I tried to get it from transaction table using Description equals 'Closed' filter. But no luck. Thanks…Mohana Gopal S-Oracle 33 views 3 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Report using Custom ScriptsContent Hi everyone, I have a requirement to create a report where we can display the number of incidents that has been routed to a different queue but only when the inc…Vaishali Rajput 39 views 2 comments 1 point Most recent by Rakesh Das-Oracle Reporting & Analytics for B2C Service -
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to get started with your Oracle Cloud Applicat…This discussion has been merged.Bethany Hubbell 5 views 0 comments 1 point Started by Bethany Hubbell Reporting & Analytics for B2C Service -
Display X number of recordsSummary Display X number of recordsContent We want to create a top 10 report and only display the top 10 in the report results. I thought I had a example script I used f…JLFolkman 20 views 7 comments 0 points Most recent by PavanSatishKumar Annavarapu-Oracle Reporting & Analytics for B2C Service -
Round date value to the last day of a monthSummary How to convert a given day to the last day of that month?Content Dear reader, Have looked in the report functions (Functions (custhelp.com)) and actually I'm loo… -
Embed BI Publisher Report on Account PageSummary We need to embed a custom BIP Report on Account Page which gives info to users on unpaid customer invoices. I have created a report based on AccountID as paramet…Umang Gupta 27 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales -
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 137 views 11 comments 15 points Most recent by Pavel Buynitsky-Oracle Reporting & Analytics for Sales -
Queue not identify accountsContent Hi, I'm experiencing a queuing problem on my team. Only one of them is accessing the service queue. How is this possible? How can I assign everyone to the same q…Leonardo Lazarini 13 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Employee Hierarchy - Fixed Hierarchy Level is always zeroContent We have loaded employees' and managers' data populated in the resource object and running the ESS job to populate the employee hierarchy. I see manager hierarchy…Srinivas Malyala-Oracle 38 views 2 comments 0 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales -
Is there a way to use API to schedule import/export of catalog data and to export reports?Summary Scheduling Import/Export of catalog data and exporting reports through APIContent Having known the methods to import/export catalog data and export reports in va… -
Feature Spotlight: Analytics for CX Sales MobileContent Analytics with modern visualizations and mobile friendly display is available starting 21C . With performance and key metrics available in the mobile app, sales … -
Agent login count is coming 0Content I'm creating a report that counts agent logins in RN, but in the column where it should count the number of logins, 0 is coming. What could be happening? Version…Leonardo Santos 28 views 1 comment 1 point Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Chat agent idle timeSummary I need to build a report to show the idle time of a chat agentContent Hi, I'm trying to build a report that shows the agent idle time. This is the time that the …Ammar Aldaffaie 36 views 0 comments 2 points Most recent by Ammar Aldaffaie Reporting & Analytics for B2C Service -
How to do the linking of Tax Reporting Type CodeSummary Linking of Tax Reporting Type Code during running the service for European Sales Listing ReportContent Tax Reporting Type Code option is not showing any value to…Mithilesh Kashyap 84 views 0 comments 0 points Most recent by Mithilesh Kashyap Reporting & Analytics for Sales -
Filter issue - affecting all Agents Dashboard "My Inbox"Summary Agents use search in the My Inbox and it saves for all usersContent User A runs a report, My Inbox, with a filter: Search_thread and inters in the customer PO. T…Jeff Scrobel 30 views 2 comments 0 points Most recent by Jeff Scrobel Reporting & Analytics for B2C Service -
How to display the value of a Dynamic Choice List instead of a number on OTBI AnalysisSummary How to display the text value of a DCL (Dynamic Choice List) on OTBI AnalysisContent Hi all, I have an analysis of a custom object where some fields are DCL. Whe…
-
How to get extracts from oracle commerce cloud and load into data lake (built on ADW)?Content How to get extracts from oracle commerce cloud and load into data lake (built on ADW)? We are looking forward to extract data from oracle commerce cloud applicat… -
Partner territory assignment to opportunitySummary If i create a opportunity 1st and associate partner afte that will the the partner territory assigned to opprtunityContent HI All, 1. if i create a opportunity f… -
Logged in UsersSummary List of Users logged into the ApplicationContent Team, Trying to find a way to pull a list of current users that are logged into the system. Any thoughts? Thanks…Inder-Oracle 35 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…Harish Gundre 23 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM -
Can I show the report description in a list of reports?Summary How to show the description of a report in a report that lists other reportsContent We are trying to generate lists of reports for a few different purposes, but …Kurt Helfrich 55 views 5 comments 3 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
SQL statements for DatastoresSummary What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?Content Hello, we are looking for the …User_0HYL0 47 views 2 comments 5 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales -
Combine CSV Files to ZIP fileSummary Combine CSV output to ZIP fileContent We have requirement to combine the multiple CSV output files to single ZIP file and move it to UCM server. There were enhan… -
Time in a certain dispositionSummary Need a report that will show how long an incident has been in a certain disposition.Content Hi, would anyone have any idea how we can show how long an incident h…jelsiao 20 views 1 comment 0 points Most recent by PavanSatishKumar Annavarapu-Oracle Reporting & Analytics for B2C Service -
Created By Account - No ValueSummary Incident Created by account is Null - Unknown - No ValueContent Hi, We ran into one scenario where incident is created by someone but unable to see who created t…Baljeet Singh-231094 27 views 9 comments 0 points Most recent by Suresh Thirukoti-Oracle Reporting & Analytics for B2C Service -
Download Attachments from Custom object throwing errorSummary I want to create a report that shows a list of attachments in a custom object and be able to download from the report. But error is occuring.Content Hello, I hav…User_2025-10-31-01-08-51-703 31 views 2 comments 1 point Most recent by User_2025-10-31-01-08-51-703 Reporting & Analytics for B2C Service -
Best Practices for Custom Subject AreaSummary Best Practices to design Custom Subject AreaContent Please refer: Oracle Engagement Cloud (Sales and Service): Best Practices for BI Extensibility and Using Cust…Syed Misbauddin-Support-Oracle 28 views 1 comment 2 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales