Reporting and Analytics
Discussion List
-
Extract Oracle Fusion BIP Report's SQL statementsHi, Is there a way to extract the SQL statements out of .Catalog files ? or this information is stored in any of the XDO tables ? ThanksNagarajuKanukanti 141 views 1 comment 0 points Most recent by User759763-Oracle Reporting & Analytics for Fusion Service -
Identify the Data Table and Column for Rule: Case.Email HeaderSummary/Content I am trying to create a report for cases that are coming from a specific email. Beside using the Rule Name (rule_log.rule_name), is there another table c… -
How to enable group by for Visualization Configuration ?Hi team, We want to create a table using Visualization Configuration from OTBI analysis, where we need column 1 as Estimator(Owner) Name and column 2 as Number of Submit… -
CRC 32 - Hash in Oracle fusionHello , We have one requirement where it has been asked to convert the 16 digits column value ( The site ID from Account Payable) into a CRC 32 HASH value. I did not fin…VarshaK 41 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Getting Blank row when we unmerge the rows in FRS reprotWe ran the FRS report and exported the data to Excel. Once we extract we merge the rows and when we unmerge the rows one row is blank and it another we have a data.Surabhi 51 views 5 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service -
How to track number of users visiting on any learning item (any offering) ?Summary: Hi experts, is there any way in HCM SAAS product -> Learning module , where for any offering item (any course/activity) , we can track the users who are just vi… -
Is there any documentation for the setup of FDI/FAW Fusion Analytic ?FDI Fusion data intelligence FAW Fusion analytic warehouseOmran Zeaiter 41 views 1 comment 1 point Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service -
PublicReportService - generateReport failedWe have a report in this path: /Custom/Customer Relationship Management/Data Warehouse/Res/Informes_Parametros/SpaceConfigurationDS_Analisis.xdo We reviewed the permissi…Jonatan Montiel 641 views 4 comments 0 points Most recent by Jonatan Montiel Reporting & Analytics for Sales -
Do you happen to know if we will be able to send vendor(ExperiencedRN) the XML feeds for our rolesDo you happen to know if we will be able to send vendor(ExperiencedRN) the XML feeds for our roles or have Taleo create a source code for their link. Source Code-UTM Cod…Carla Clendenon 11 views 0 comments 0 points Most recent by Carla Clendenon Reporting and Analytics Taleo Enterprise -
Custom analysis on Service HomeWe would like to customize the home page of the Service Center (Service Home) by adding different sections than those currently available. We have searched extensively t… -
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…Chanida 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr…Simon Kaplun 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…Vitor Nakamura 51 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Sales -
report that shows any Due date changes happened after october 1st 2024I need to create a report that shows any Due date changes happened after october 1st 2024. How to track due date changes?Please help. Thanks MeeraMeera Saseendran T 61 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for B2C Service -
Move Dashboard Page to a subpageSummary: Hi, I have created a dashboard with multiple Subpages under one Dashboard page. When i rename the Subpage names (In Dashboard Properties), somehow its convertin…Sudheer YN 201 views 8 comments 0 points Most recent by Dianne Barnhouse Reporting and Analytics for SCM -
Getting Sign In option for Power BI Dashboard URLs embedded on Oracle Sales Cloud even SSO setupdoneSummary: When we try to embed Power BI dashboard URL on oracle sales cloud it is asking for Sign In option instead of opening the links directly since SSO setup is estab…Sukumaran Ayyaswamy 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Roles and privileges required to create and execute the BIP reports in fusionHi, What are Roles and privileges required to create and execute the BIP reports and Data models in fusion ERP apart form Admin Roles. As part of the Support project, it…Perumalla Ashok 1.1K views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Service -
Ability to add BI report from custom object either using smart action or any related optionsSummary:Ability to add BI report from custom object either using smart action or any related options Content (please ensure you mask any confidential information): Hi Te… -
How to get what are all the Permissions assigned to the report for xdo file and xdm filesHow get what are all the Permissions assigned to the report for xdo file and xdm files through back end (sql script or rest services)UdayKuditipudi 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting & Analytics for Fusion Service -
Fetch all OTBI Reports custom adhoc & scheduledSummary: Would it be possible to generate a OTBI report that includes all system-generated of adhoc and recurring reports/views ? I have tried to use OTBI Usage Real Tim… -
Where is the Organization Name on the SCM BICC Extracts?Summary: In the BICC Extracts for Sales Orders Transfer Orders Purchase Orders Shipments On Hand Installed Base We need to Find the Organisation Name but can only find a…Martin Hutchison 2 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Upload excel for search criteria to find on hand dataSummary: One of my customer has huge number of SKUs (6 million SKUs). The user would like to query the on-hand quantity for SKU's by uploading an excel. The excel file h…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
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 111 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Service usage metrics reports Alert / AutomatedWe are looking for alerts/automation for service usage metrics daily/ monthly for different interfaces. The section in which we are interested in setting alerts are Stor…Rahul Ram 101 views 4 comments 0 points Most recent by Nithin Nassar-Oracle Reporting & Analytics for B2C Service -
Could BI Report Show Report Total Lines and Total Amounts InformationSummary: Based on audit requirements, user want BI report searching page could show total lines and total amount of exported report data. Is it possible for BI to realiz…Abby Chen522 41 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Data not showing accurately in the reportHi Team, We have a custom report to see the Agents productivity in the oracle B2C. We are using the incidents, Agents and Incident performance table in the data and usin…Kiranprasanna Dhanasekaran 51 views 2 comments 0 points Most recent by Kiranprasanna Dhanasekaran Reporting & Analytics for B2C Service -
Opportunity Line Revenue exchange rateSummary: Hi, Does "Pipeline Detail Facts"."Opportunity Line Revenue" column uses exchange rates for non USD opportunities? Content (please ensure you mask any confidenti… -
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications through …Camilo Martinez-114335 32 views 1 comment 1 point Most recent by Radhika Abhyankar-Support-Oracle Fusion Service -
How to restrict data visibility across different Business Units in Oracle Sales ?Summary: Need to restrict data visibility (read/write both) for all the objects in Oracle Sales Cloud. (Leads, Opportunities, Service Requests etc.) Content (please ensu… -
Create tables(DDL) from PVO metadata provided by REST APIWe are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata) Url: https://{server_name}/biacm/rest/meta/da…Alex25 51 views 1 comment 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting and Analytics for SCM