Reporting and Analytics
Discussion List
-
We need assistance in identifying table(s) that capture shipment errorsSummary: Hi Team, We are building a BI report to fetch errors that occur during the shipment process triggered by HighJump via REST API. Currently, the team identifies e…Sai Sreeram Gundepudi 1 view 1 comment 0 points Most recent by Jagan Nori-Oracle Reporting and Analytics for SCM -
Hide Catalog menu item in Catalog BarBusiness users need to be restricted to access to entire catalog while executing reports. We have given page entries for reports to execute. So we thought to hide the me…SurendraPB 41 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
How to add Header and footer in Each group of E-text Template ?I have e-text fixed base position template in which I want to add header and footer in each group of template. I made variable in SQL query but my requirement is not ful…Malik_Umer 31 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Helpdesk Requests that have Journeys assigned to them on an OTBI**This post was created as part of a How to Service Request (SR) Release: [Version] 11.13.24.04.0 Summary of the question: Can we identify Helpdesk Requests that have Jo…Bodhisattwa Mukherjee-Oracle 1 view 2 comments 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Need to create a Job set which call Min Max Job 600 times with different parametersSummary: We need to create a Job set which will trigger the Min-Max planning report 500 times for different Inventory Organizations. We are able to create the job set th…
-
Sending Customer Statements via API or SOAPSummary: Mass sending of customer statement of account to selected list of random customers. Similar to mail merge Is there any API or SOAP that can be used to call Stat…Giri Venkatesan 21 views 3 comments 0 points Most recent by Giri Venkatesan Reporting and Analytics for ERP -
Is there a simple way to create a report based on Service request, Work Order and Debrief?we are working to create a report that will include information from the Service request and all the work that was done by the engineer. the entity structure we need (or…Boaz Hayon-Oracle 1 view 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Remove column header in BIP csv outputSummary is it possible?Content Quick question - Is it possible to remove column header for BIP csv output with configuration? I saw this MOS doc. I wonder if there are o… -
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 71 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 12 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 71 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 61 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