OTBI
Discussion List
-
SQL query to fetch employees holiday applied on during employees is on maternitySQL query to fetch employees holiday applied on during employees is on maternityManikanth Kumar 14 views 0 comments 0 points Started by Manikanth Kumar Reporting & Analytics for Fusion Service -
Bi Publisher CSV output IssueSummary: Bi Publisher CSV Output Issue displaying all the fields in the output Content (required): Requirement is to display all the fields from the data model output of…kalyan gade 53 views 4 comments 0 points Most recent by kalyan gade Reporting & Analytics for Fusion Service
-
Legal Disclaimer check box field under the External Career Site cannot be obtained from the reportThe Legal Disclaimer or Privacy Statement column under the Recruiting Career Site cannot be obtained from the BIP and OTBI report. We would like to ask for your help bec…Abbygail Mararac 4 views 0 comments 0 points Started by Abbygail Mararac Reporting & Analytics for Fusion Service
-
Can we get employee ID of salesperson in reportsHow can we get employee ID of salesperson in reports, From Opportunity, when we pull employee ID, its giving the employee ID of the Opportunity owner, but can we get emp…Pavan_Ketha 4 views 0 comments 0 points Started by Pavan_Ketha Reporting & Analytics for Fusion Service
-
Does anyone have an idea on how to Call Third Party API from Fusion via ESS JobSummary: We have a standalone Oracle DB and and API that exposes the data from a specific table. Since we can't connect OTBI to other DB, we just want to be able to call…PeterXavier 3 views 0 comments 0 points Started by PeterXavier Reporting & Analytics for Fusion Service
-
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…kalyan gade 33 views 2 comments 0 points Most recent by kalyan gade Reporting & Analytics for Fusion Service
-
Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 23 views 0 comments 0 points Started by Ashish A Jha Reporting & Analytics for Fusion Service
-
User is not able to run Customer report in OTBI report,Summary: Users is not able to run Customer report in OTBI report, could anyone please let me know which Duty Role or Privilege required to run this report, we have assig…Mohit07071990 33 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 23 views 0 comments 0 points Started by Noelle Bartlam-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…
-
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 34 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service -
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 105 views 0 comments 0 points Started by kalyan gade 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 84 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-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)…Amel_Ahmed_AHG 33 views 2 comments 0 points Most recent by Amrita Gupta-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 …SUUM Technologies 226 views 4 comments 1 point Most recent by Roxana Oprean 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 57 views 3 comments 1 point Most recent by Nitin Deo Reporting & Analytics for Fusion Service -
Sales Analytics DashboardHi, Kindly help me out where does the configuration need to be done to setup the hierarchy to be displayed in Sales Analysis Dashboard report For eg I need John in Globa…Mohammed Rafi 33 views 2 comments 0 points Most recent by Mohammed Rafi 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 46 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 34 views 0 comments 0 points Started by Venkataraman Ramakrishnan-Oracle Reporting & Analytics for Fusion Service
-
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 36 views 0 comments 0 points Started by ShreySH-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 53 views 2 comments 1 point Most recent by Josh Vincent Reporting & Analytics for Fusion Service -
Metric Descriptions - Service Subject AreasSummary Descriptions of all the out of box metrics found in the 'Service - CRM Service Requests Real Time' and 'Service - CRM Service Request Lifecycle' subject areasCon…Anand DN-Oracle 58 views 1 comment 2 points Most recent by Dimple-Nagesh-Support-Oracle 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 …User_GXFFS 48 views 1 comment 0 points Most recent by Justin Anderson-Oracle Reporting & Analytics for Fusion Service
-
BIP BurstingSummary BIP BurstingContent Hi, I have a requirement to send report output to different owners with the email attribute in the table. Here is what I did, 1. Create a BIP…Adam Liu 99 views 2 comments 3 points Most recent by User_KM4LK 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 30 views 0 comments 1 point Started 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 38 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 38 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 34 views 4 comments 0 points Most recent by Anand DN-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 47 views 0 comments 5 points Started by Pavel Buynitsky-Oracle Reporting & Analytics for Fusion Service
-
Category Name for HRHDContent We are implementing HRHD and I'm in the process of building reports. I've found Category ID works in the "Service - CRM Service Requests Real Time", but I can't …Matthew Voss 45 views 4 comments 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service