Reporting and Analytics
Discussion List
-
How to create reports related to tables that are only in PaaSSummary: Hi, We want to know if there is a way to create reports in SaaS that retrieve information related to tables that are only in PaaS. I have created a custom table…Iker Garcia Martin 201 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
Table/Tables to find the "Cost Center Owner" Name/ID in OTBISummary: We are looking for the exact table name/set of tables through which we may find the Cost Center Owner Name or ID. Any information on the Subject Area where we m…
-
BIP report output file encoding is changing in different ERPC environment, why this is happening?Summary: We developed a BIP report and for that BIP report client requirement is to send data in particular format and it should be in UTF-16LE encoding . file is in .tx…maroti.n.pawde 111 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto…Richard_Page 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service -
What is the limitation for how large of an XML string Oracle/BIP can handle?Summary: **This post was created as part of a How to Service Request (SR) Release: 23A Content (required): Customer is getting data from external source using web servic…Suri Natarajan-Oracle 72 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
Adding static hyperlink to BIP RTF TemplateSummary: I need to add a basic static hyperlink to a BIP rtf template to open a OTBI analysis. I cannot get the hyperlink or even basic text to display once I upload the…Jarrett 234 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
Payload is required for the SOAP web service - BIP scheduled job historySummary: We require the payloads of BIP scheduled job history SOAP web service. Please find the following web service details and share the appropriate payloads to get t…Lakshmana Rao Bandaru-Oracle 151 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-Oracle Reporting & Analytics for Fusion Service
-
How to pass date to ESS Job for Oracle BI reportSummary: We have created a report that takes start and end date as mandatory parameters in the format (MM-dd-yyyy). When we run this report from Analytics Catalog page t…Hardik Gupta 1.1K views 1 comment 0 points Most recent by Hima Bindu Patil -Oracle Reporting & Analytics for Fusion Service -
i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…Ab_AM 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting & Analytics for Fusion Service
-
Multiple Values for BIP Report Parameter from LOVSummary: How to select multiple values from a LOV for a BIP report parameter Content (required): Version (include the version you are using, if applicable): Code Snippet…Robert A 102 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting & Analytics for Fusion Service
-
remove rows with 0 value from reportSummary: Remove rows with 0 value from report or remove weekend dates/Saturday and Sunday days only. Content (required): reports Version (include the version you are usi…Marissa Gonzales 21 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting & Analytics for Fusion Service -
How can we identify the reports that are using a Custom Subject Area?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: There is a way to find the reports that are using a Custom Subject…Ionel Spaloghe-Support-Oracle 21 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Fusion Service -
How do I display the lookup code in a OTBI analysis?Summary How to display a custom fiel lookup code in a OTBI analysis?Content Hi, A client wants a OTBI report with columns that contain the lookup code of some account's …XUM TECHNOLOGIES 514 views 4 comments 1 point Most recent by Roxana Oprean Reporting & Analytics for Fusion Service -
BICC PVO is extracting same delta extract every time irrelevant to Last Extract DateSummary: BICC PVO is extracting the same delta extract every time irrelevant to the Last Extract Date. Below are the two PVO for which we are encountering this issue: 1.…Vivek Gautam 71 views 2 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting & Analytics for Fusion Service -
Need all the columns with CLOB data type in the BICC Extract along with the PVO NameSummary: Hi All, We need all the columns with CLOB data type in the BICC Extract along with the PVO Name in Excel Format. Thanks in Advance :) Content (required): Ricoh …Vivek Gautam 61 views 3 comments 1 point Most recent by Nitin Deo Reporting & Analytics for Fusion Service
-
OTBI - How to get Person_Number for 'People Center Requests' -> 'Primary Point of Contact'?Summary: I am building an OTBI Analysis for Helpdesk Aged Tickets using Subject Area "Service - CRM Service Requests Real Time". How to get Person_Number for the Primary…Vinay Hardas 41 views 5 comments 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
Omni Channel - Events ReportSummary: Omni Channel - Events Report Content (required): 1. Omni Service Request and Queue Assignment performance Tile This report would help SR admin to know what is t…Venkataraman Ramakrishnan-Oracle 31 views 0 comments 0 points Started by Venkataraman Ramakrishnan-Oracle Reporting & Analytics for Fusion Service
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 41 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting & Analytics for Fusion Service
-
Sample Daily Digest for Agents - Unassigned and My Open TicketsSummary Daily digest report ready for subscribable agent to inform agent of open tickets currently assigned to them or unassigned but in their queueContent Our agents wo…Josh Vincent 60 views 2 comments 1 point Most recent by Josh Vincent Reporting & Analytics for Fusion Service -
Application table for standard coverage under subscription managementSummary Need to query coverage details under subscription management using data modelContent Subscription Management -> Standard Coverage - > (Template details) what is …ViswanathaReddyKetireddy 45 views 1 comment 0 points Most recent by Justin Anderson-Oracle Reporting & Analytics for Fusion Service
-
Workshop - A Modern Solution for your Oracle Cloud!Summary Derive greater value out of Oracle Cloud with our Next-Gen Managed ServicesContent If your company is like many others, you’ve invested in Oracle applications to…User_W4MMU 27 views 0 comments 1 point Most recent by User_W4MMU Reporting & Analytics for Fusion Service
-
Message content not displaying in exportContent Hi, I have created a report with the subject area "Service - CRM Service Request Messages Real Time" and bringing back the message content "Service - CRM Service…Mitch_123456 37 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
-
Unable to create a new analysis in OTBIContent Hello everyone! I am writing because I am observing an unexpected behavior in OTBI. I have two users with the same roles: the first one, by accessing otbi, is ab…Virginia M. Calvi 33 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service -
Action Plan reportingSummary Need to create a report showing actions due in a given period.Content Hi, I was wondering if anyone could help me out with a report I have to create around actio…Mitch_123456 31 views 4 comments 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
How to invoke OTBI report from Service Request pageSummary How to invoke OTBI report from Service Request pageContent We have requirement to launch the OTBI report from Service Request Summary page. Did anyone work on su…Jitendra Singh-Oracle 52 views 4 comments 0 points Most recent by Jitendra Singh-Oracle Reporting & Analytics for Fusion Service -
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 76 views 0 comments 5 points Most recent by Pavel Buynitsky-Oracle Reporting & Analytics for Fusion Service
-
HR Help desk - adding Level 3 of Org hierarchySummary Need to add "Level 3" to an exciting help desk reportContent Hello, I wonder if anyone can help me out. I need to add "Level 3" of the organizational hierarchy t…Mitch_123456 45 views 3 comments 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
List of pre-built metrics - B2B Service and Help Desk OTBISummary Provides the list of out of box metrics/facts in the B2B Service and Help Desk Subject AreasAnand DN-Oracle 125 views 0 comments 5 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)Summary Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)Content Hi All, We need to send/push a Fusion BIP Report using standard scheduler option…Kasinathan Palanikumar - Oracle-Oracle 61 views 1 comment 3 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Let’s continue the conversation on B2B Service and Help Desk Analytics!Content Welcome to the forum dedicated to Reporting and Analytics for Fusion Service As more and more of you, our customers and partners, implement Fusion B2B Service, t…Anand DN-Oracle 159 views 0 comments 6 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service