Reporting and Analytics
Discussion List
-
Way to export the OOTB attributes and descriptionHello, We have a requirement here to export the OOTB attributes and description. Need to know in which way we can achieve this. Any help relevant to above is appreciated… -
Portuguese language conversionHi, We have a requirement to convert Receipt amount in words to PORTUGUESE language. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, …Anusha DP 22 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
how to resolve usage of function count() does not include requested usage - filterSummary: how to resolve usage of function count() does not include requested usage - filter Content (please ensure you mask any confidential information): I am receiving…bosun 11 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
CDM: Unable to find hierarchy fields in Fusion back end tablesHello, In a requirement we are creating hierarchy in CDM through the import management. We are required to create a report based on the fields in the import Hierarchy an…
-
Can we build a BIP report for the child processesCan we build a BIP report for the child processes that are run after after load interface file for import.Shalini S 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Getting error when trying to fetch profile values in field trigger before insertHi Everyone, we are getting error when creating error after adding the below condition in if (oracle.apps.fnd.applcore.Profile.get("SERVICE_2_0_SR_LIST").contains(Catego… -
Reporting Time Between Chat EventsContent I've been tasked with creating a report to isolate the number of chats where there is no post by the end user within a minute of the agent interaction beginning.…User_2025-02-01-08-26-22-513 25 views 2 comments 0 points Most recent by OBerg Reporting & Analytics for B2C Service -
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …Nalsoft Pvt Ltd 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 1.5K views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
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 32 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 34 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 2 views 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 2 views 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 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…