Reporting and Analytics
Discussion List
-
My array for $exit_obj does not display all the dataSummary: I'm using custom script to export the data into an array, manipulate it and dump it back into the $exit_obj. However, when the data is displayed - it does not d…Jason Phillip 44 views 2 comments 0 points Most recent by Jason Phillip Reporting & Analytics for B2C Service -
Can the note filed from the threads table be processed as a string?Summary: I have some content in the threads field, and i want to split it apart in to separate strings for a report. However every function i use says its expects a stri…spence_abcd0109uk 33 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service -
Help with report - answers last accessed by users in specific profileSummary: Help with report - answers last accessed by users in specific profile Content (required): Hello. I am trying to write a report that shows the last time an answe…kerry walker 71 views 5 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User-Summary: Copy of Uninvoiced Receipt Accruals Report Job is failing when it is run using Custom Role User Content (required): Hi, We have a requirement for a report which…Aman Chaturvedi 41 views 1 comment 0 points Most recent by Rohan Kamat Reporting and Analytics for SCM -
Exporting incidents with attachmentsSummary: We have a requirement to export the old incidents with attachment for old customers Content (required): Can we export the incidents from old customers along wit…Jayashankar Lingaiah-Oracle 61 views 5 comments 0 points Most recent by Lisa Bright Reporting & Analytics for B2C Service -
How to fetch a list of users linked to Account/Account sitesSummary: How to fetch a list of users linked to Account/Account sites. Content (required): How to fetch a list of users linked to Account/Account sites. The ask is to fe…Neelesh Varma 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
How to fetch a list of users linked to Account/Account sitesSummary: How to fetch a list of users linked to Account/Account sites Content (required): How to fetch a list of users linked to Account/Account sites. The ask is to fet… -
How to create build an analysis report for Lead Source?**This post was created as part of a How to Service Request (SR) Release: 22D Summary of the question: How to create build an analysis report for Lead Source? Though the… -
How to send HTML content email using OTBI agentSummary: Not able to send an email which include html tags and image contents to be scheduled and sent over agents in OTBI Content (required): Version (include the versi…Kostare 102 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Using deep link with Workspace and being able to open a record from the tabI am doing a POC for a customer for the following requirement: I have a report showing Customer Name and Activities for that customer. I want to click on the account nam…Andres Munoz 73 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Reports in the oracle cx sales mobile app does not return any dataSummary: Reports in the oracle cx sales mobile app does not return any data; cannot see/access any reports. What could be the reason for this? and how to fix it? Thank y… -
Report Filters for null and not null queriesSummary: I need to be able to create a filter that if blank will return rows with that column blank, but if not blank then return rows that match the filter Content (req…Rob Shorney 105 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
How to give access to a custom dashboard and data within itSummary: How to give access to a custom dashboard and data within it Content (required): Hi, We have some custom dashbaords developed and each dashboard has multiple ana…Abhishek Gattu 74 views 4 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Why is my new custom field not showing in BI?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: I have created a new field 'NewField_c' in the 'Object_c' custom o…Ionel Spaloghe-Support-Oracle 73 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales -
Filter Planned Completion Date Based on Current DateSummary: Content (required): Hi, We have created an OTBI report with the column "Planned Completion Date" using Maintenance Management - Work Order Performance Real Time…Sheneli98 41 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for SCM -
How do I obtain a flitered list of attachments and then export them from OSvC?Content Hello, We frequently have agents who want to create a list of attachments for specific incidents, filter for attachments that have a specific name, and then expo…User_2025-10-31-01-08-51-703 48 views 6 comments 0 points Most recent by User_2025-10-31-01-08-51-703 Reporting & Analytics for B2C Service -
Create Custom Subject AreaHi, Please help with the steps how to create custom subject area from the custom data model ? ThanksMohammed Rafi 74 views 3 comments 5 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to create a report to show opportunities for the logged in user territory hierarchy?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: How to create a report to show opportunities for the logged in use…Deborah Bourgeois-Support-Oracle 66 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Time with agentSummary: What is the best way to calculate the time the case has been with an agent? Content (required): For example, when a client raises a case it gets assigned to an …SDP 52 views 1 comment 1 point Most recent by michael garverick Reporting & Analytics for B2C Service -
How to pull in a column full name of ctype_id=10 the main name not the representative the name =10?Summary: I have build a report and trying to pull with if(contact.ctype_id=10). I tried substring but it doesn't work, I guess I didn't make the correct combination of c…TinaB 36 views 6 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
What's the most efficient way to temporarily 'tag' records for reporting purposes?Summary: We need to check on a particular field for a large group of contacts, but have no way of querying for them. There is a separate/external and 'official' contact …Christos S. 54 views 6 comments 0 points Most recent by Christos S. Reporting & Analytics for B2C Service -
Why does Rule State double each Answer in the report?Summary: Adding Rule State to Answer Default report doubles every row for each answer. Content (required): I want to modify the Answers Default report that is a simple l…User_2025-10-31-01-08-51-703 43 views 22 comments 1 point Most recent by Christian UoA Reporting & Analytics for B2C Service -
How to insert page breaks for report PDF print out?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: How To: 1. Insert page break in the narrative between accounts 2. …Deborah Bourgeois-Support-Oracle 115 views 4 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
How to give user friendly names to Custom Subject Areas when using queries on Data Model?**This post was created as part of a How to Service Request (SR) Release: 22D Summary of the question: How to give user friendly names to Custom Subject Areas (CSA) to m…Deborah Bourgeois-Support-Oracle 71 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Can we add one new Detail (filter) to Configuration Visualization from a Saved Search?**This post was created as part of a How to Service Request (SR) Release: 22D Summary of the question: We are trying to create a new Configuration Visualization with Sou…Ionel Spaloghe-Support-Oracle 54 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Sales -
Subject Area to pull all contacts from Accounts (that are not customers)Summary: Subject Area to pull all contacts from Accounts (that are not customers) Content (required): I am trying to pull a list of all contacts and want to include thei… -
Help with BI answers Report - AccountContactIDSummary: I am trying to create a report for contact information that has a relationship with that Account. In the import mapping for AccountContact I am able to see the … -
How to add the Supplier Site Attribute information to the Requisition PDF ReportSummary: I want to add the Attribute Information from the Supplier Site to the Requisition PDF Report. Based on the attachment from Doc ID 2595071.1 (RequistionPDF Attri…Hendra_innopia 31 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for SCM -
Custom DCL fields are not visible in analyticsSummary: We have custom DCL fields in Lead , those were not coming in standard subject area , so created custom subject area by adding all the fields and published , aft… -
How to retrieve province's Primary and Alternative Names of CA country using SQL query?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.10.0 Summary of the question: Customer requested to know how to retrieve province's Pr…Manoj Kumar-Support-Oracle 193 views 1 comment 0 points Most recent by Manoj Kumar-Support-Oracle Sales