To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for B2C Service
Discussion List
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… -
How to know the Source URL of the ChatSummary i want to check what was the URL of the page from where chat was initiatedContent I have multiple instances of syndicated proactive chat and syndicated condition… -
Custom report extract from Oracle Service CloudSummary Custom report extract from Oracle Service CloudContent Hi There, We have a custom report created in Oracle Right Now which is reading the data from multiple tabl… -
Formula to pull previous day solved when date filter is broader rangeSummary Pulling all open statuses while only pulling solved for the previous day or week, month, etc.Content I am pulling all open status incidents based on date filter …User_2025-02-01-08-49-49-892 39 views 7 comments 0 points Most recent by User_2025-02-01-08-49-49-892 -
Calculated Column to Show Time Until Aged Database Utility sets an Incident to Solved?Summary I am trying to find a way to display a calculated column that will show the amount of time remaining before the Aged Database Utility changes an SR from Waiting … -
Report Not Displaying all Community Questions or CommentsSummary Report Not Displaying all Community Questions or CommentsContent We have a report that displayed the basic Community information (see attached) that had been wor… -
How can I get the report id of a reportSummary Can I use the custom scripts to get the report_id?Content I created an AddIn and would like to get the report ID to use it to refresh the report after running a …User_2025-07-18-03-19-20-600 61 views 6 comments 3 points Most recent by User_2025-07-18-03-19-20-600
-
REPORT_ERROR_EXCEEDS_MAX_JOIN_SIZE despite report running quicklyContent Hi, Definition as per the attached. When I run the report in the console, it runs quickly and brings back about 300 rows. Prior to the recent 18D upgrade, callin… -
How to set the default output formats for reportsContent We have created the reports through the BIP and for each and every report there are some default output formats ara predefined if my required output format is no… -
How to count Number of incidents Created by Service mailbox and Ask a questionSummary How to count Number of incidents Created by Service mailbox and Ask a questionContent i created a report to count how many incidents Created, Edited, Solved by a…
-
Report Scheduling Not Working With Custom ScriptContent Hi, I need to run cron job from OSvC for particular interval of time. I created one custom report and wrote my custom code in custom script. Initialization Tab p…User_2025-02-04-06-31-46-728 99 views 13 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
search for phone number in ph_mobile with our without leading 0Content Hi, Currently we have the challenge to find a mobile phone number, that is maintained sometimes with and sometimes without leading 0 (yes I know, that should not…
-
How to Display the Min Login for the Max DaySummary I am trying to create a report column that displays the Min Time for the Max Date?Content I am trying to create a Staff Account Login report that will show the A…
-
Extract the middle section of thread noteContent Hi, I need to extract the middle-part of thread notes for incidents relating to a given product. The format of the note is consistent, but the middle part may so…User_2025-02-03-17-31-49-785 53 views 12 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
Create CX reports to display on tabletsSummary Tips on creating reports so that they display correctly on tablets as well as laptops/desktopsContent Does anyone have any tips on creating reports so they are u…
-
Add new note/thread from reportSummary Add new note/thread from reportContent Our finance team need to respond to queries in their queue from a report. They'd like a faster way to do this without havi…User_2025-02-01-07-03-13-295 43 views 3 comments 1 point Most recent by User_2025-02-03-20-46-35-138
-
Sum of integers in report column out of integer rangeSummary Sum of integers in report column out of integer rangeContent Hi, I'm working on a report where I need to sum an integer field using 'sum' function and it is unab…PavanSatishKumar Annavarapu-Oracle 43 views 4 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
distinct group_concatSummary How to get a group concat to only show distinct values?Content Hello, I have a parent table with two children tables (siblings). I need information from one chil…User_2025-10-31-01-08-51-703 231 views 33 comments 1 point Most recent by User_2025-02-03-16-51-39-328
-
Help with an AlertSummary Alert for number of emails routed to a QueueContent Hi, Can anyone maybe help me with setting up an alert? I have a simple report showing incidents that arrived …
-
Is there a way to add the Report ID (AcId) to the title of a report?Summary We occasionally need to know the report ID of the report for our scheduled reports and would like to add this to the report title or somewhere in the reportConte…
-
Using Score as a variableSummary Using Score as a variableContent Good day, and Happy New Year! We’ve recently run into an issue with a survey report we’ve had running for a few years. Its set u… -
Incident last updated by and last status change byContent Hi, Happy new year! I have a report which lists incidents. I want to show who last updated it and who did the last status change. They can be the same person at …
-
'Expanded Report Audit Log'Content We have upgraded our instance to 18D. I was looking forward to this report 'Expanded Report Audit Log', but currently I am seeing any data in it even though ther…
-
Show Warning Message in ReportSummary Show Warning Message in ReportContent I want show following warning message in my report. I don't want to add any fields into the report. "WARNING! You have logg…User_2025-02-03-16-53-11-440 43 views 18 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
Count the number of customers who make chat dailyContent Hi, Everyone I have a problem, now our business wants to know how many customers have launched chat every day, we want to count the number of people who launch c…
-
Excel template date format issueSummary No date format is recognized by Excel templateContent Hi Team, It seems Excel templates in BI Publisher do not recognize any date format when receiving data from… -
Is it possible to show the Report Definition as a report column?Summary Output the report definition as a columnContent I have a report that shows information about reports, such as the Report ID (name), ACID, Owner, Last Run, etc. I…
-
Custom report data display is wrongContent Dear all When using the RN system, we need to record the status of the agent login every day, such as the number of logins, the number of logouts, the login dura…
-
Report information about custom objectsSummary How do I report a list of all my custom objects and the descriptionsContent Hello, I'm trying to get a list of all the custom objects I've created, along with th…User_2025-10-31-01-08-51-703 49 views 11 comments 0 points Most recent by Sebastiaan Draaisma-122509
-
Report Export to Excel formatting issue.Summary Preset Report formatting is not working when reports export to Excel, but only for certain users.Content I am having an issue with getting Reports to keep the pr…