Reporting and Analytics
Discussion List
-
OTBIレポート作成のガイドお客様が自分でレポートを作りたいときに参考にできる日本語のガイドをご案内します。 簡単ガイド ERP/SCM/EPM Cloud日本語フォーラムに【簡単７ステップ】セルフBIレポートの作り方…Yumiko Uotsu-Oracle 491 views 1 comment 0 points Most recent by Yumiko Uotsu-Oracle 日本語Cloud HCMフォーラム -
Subject Area - How to add the attachments field in a reportSummary: How to add the attchament field in a report made through the subject area "Sales - CRM pipeline" Content (required): We want to add the attachment field in a re…SERGIO BARRETO 261 views 2 comments 0 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales -
Google reported that we have several url without good experienceSummary: We received a list of urls where google informs that they do not have a good experience Content (required): The urls are disapproved due to failure in the LCP, … -
Reporting on Answers where agents have NOT createdSummary: Ability to search for Agents that have NOT created an answer. I have a report that looks at the Answers table and it has the Creator field and Year Month with a…SDP 61 views 3 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service -
How to remove appointments which are completed or cancelled from the 'My Appointments'Summary: Greetings! Can anyone assist me on how to remove appointments/tasks that are 'completed 'or 'cancelled' from the 'My Appointments' present under Sales Infolets …
-
outer join with WHERE NOT EXISTS statementContent Hi, I'm looking for a way to configure a report with an outer join and the WHERE NOT EXISTS statement (known from native SQL). Sadly I do not find a solution. Th…User_2025-02-03-17-28-17-184 50 views 14 comments 1 point Most recent by SDP Reporting & Analytics for B2C Service -
Transaction Date (Parameter "param.p_date") shows up as prior day date for user but not for meSummary: Hello Forum-mates: A BI SCM report "Transaction Date" Parameter "param.p_date" expression is only showing prior date for the customer in accounting but whenever… -
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 41 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 31 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 101 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 71 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 101 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 71 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 71 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 44 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 71 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 61 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 51 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 31 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. 51 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 41 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 111 views 4 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales