Reporting and Analytics
Discussion List
-
Tracking geolocation of the logged in users in OCC storefrontSummary: We have a requirement to track the geolocations of the users logged into the OCC storefront. We have done an integration between OCC and Google analytics to tra… -
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job? -
Do you know how can I get the email of Reporting Manager from the Resource User Information section?Summary: Do you have an idea on how can I get the email of reporting manager in the resource user information section under Manage Users? I am using the table jtf_rs_rep… -
how to convert Universal time to CDT timeSummary: PROCESSSTART is displaying as 2024-06-06T06:03:22.173+00:00 (Universal time) in table fusion.ess_request_history. Could you please Help how to convert Universal…Rama Krishna Annam 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Data flow in fusion.ess_request_history table while Running the BIP Report which was scheduled.Below are values populated in fusion.ess_request_history table while Running the BIP Report which was scheduled. state value is 3(Running),processend is NULL value and E…Rama Krishna Annam 72 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Inquiring about whether BOs are enabled for CRM Application Composer & Trading Community ModelHi team, I want to inquire whether BOs are enabled for the following products in the audit report: -CRM Application Composer -Trading Community Model Thanks and best reg… -
Create Analysis Report for Marketing Interactions with Account informationDear Community, we are trying to create an analysis report for Marketing Activities linked to various Contacts but it's hard to find a good subject area that works corre…George Papadogiannopoulos 11 views 1 comment 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales -
Need to Create Data Model for Account and Contact change history tabSummary: We need to create Create Data Model for Account and Contact change history tab. But we could not find any Table to create it. Does we have tables to create repo… -
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 11 views 2 comments 0 points Most recent by JohnCap Reporting & Analytics for Fusion Service -
how to create multi edit reportSummary: I need to create report for editing a contact of a incident. For that I need to enable that report with multi edit. How to do that? Regards, MeeraMeera Saseendran T 11 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
How to check who modified a reportSummary: we have a folder containing sub folders and custom reports, we notice that its last modified date are same in all file. we are thinking that maybe it's from bac… -
How to compare current and previous data in OTBI?Hi All, We have a requirement where we need to fetch and compare the data (an attribute on employee assignment page, say Job or Position) on 2 different dates in OTBI an…Suyog 106 views 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting & Analytics for Fusion Service -
Cx - Dashboards are unable to be linked with or bring in.Summary: When a dashboard is filtered using Opportunity Number, automatically all the dashboards should get generated individually but not as a list form as shown in the…Nalsoft Pvt Ltd 31 views 4 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting & Analytics for Sales -
Which table contains Credit Management, Credit scoring model detailsCould you please provide the name of the backend table where the details of credit collection data points, such as category, data point name, DataPointId, data type, and…Jeetesh Singh 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI…Rajat Pandey 21 views 6 comments 0 points Most recent by Rajat Pandey Reporting and Analytics for SCM -
Cx - Are predefined templates available for Sales in OTBI?Can we have predefined templates available for Sales in OTBI.Nalsoft Pvt Ltd 31 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 72 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Cx - Can we develop blocks using OTBISummary: Can we develop the report by the following design using OTBI. Content (please ensure you mask any confidential information): Version (include the version you ar…Nalsoft Pvt Ltd 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM -
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 31 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…Naga Peddiraju Chennu 11 views 7 comments 0 points Most recent by Prassanna_Srinivasan Reporting and Analytics for SCM -
Inquiring about business object in audit reportSummary: Hi team, Please help us with the following questions: 1. What kind of log will appear when Business object type is not selected and is blank? 2. Are there any b…Zafar Ara Nawreen 29 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
how can i report on all the web pages including answershow can i report on all the web pages including answers possible on a site, along with the URL to reach it?spence_abcd0109uk 1 view 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service -
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…Nalsoft Pvt Ltd 31 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service -
My Team's Leads Tile - OOTB report is not showing proper data to the managers.Summary: My Team's Leads Tile - OOTB report is not showing proper data to the managers. Do we need to run any job? Path Sales/Embedded Content/ Sales Manager . Could you…NikhilSamudrala-Oracle 21 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales