To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Fusion Service
Discussion List
-
where is almacenes all my data generated in fusion applications?My question is, how can I access all the data generated in my Fusion applications? I want to replicate my OAC instance in Power BI. I have an ADB instance, and I've conn… -
Is there any tool to migrate objects from B2B one instance to another Instance?Summary: One of my customers is using a Fusion instance for Service Cloud with multiple business units. They are planning to migrate and move selected business units int…
-
Hide/remove access to infolets for specific usersSummary: In Germany KPIs such as performance may not be measured at the individual level. It must not be apparent, for example, how quickly an employee has processed or … -
The report prompt doesn’t appear on the same page when I apply the report filter.Summary: We created a report-level prompt, not a dashboard prompt. We need the prompt and the report to remain on the same page, but when we apply the prompt filter, the…
-
How to report on Live Chat for Fusion Service wrap up resolution in OTBISummary: As part of our Live Chat for Fusion Service roll out in HR Helpdesk, we have built a suite of reports and dashboards that contain information on average wait ti…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…
-
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…
-
Case Management ReportingSummary: For Case Management my client would like to run a report that produces data relating to the Person number, Department, Job Title, ..etc Can you advise what tabl…
-
Help with Due Date Fields in OTBI for SR MetricsSummary: Hi Team, I’m working on an OTBI report to capture: First Response Metric Breached – Count of SRs that have breached first response time Resolution Metric Breach… -
Sep 2025 SOC and Bridge Letter Delivery DateSummary: What is the projected date for delivery of the Sep 2025 SOC1 report and Bridge letter? We have auditors anxiously awaiting delivery of these reports. Content (p…
-
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…
-
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …
-
Moved: Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle…This discussion has been moved. -
How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence completes with ErrorSummary: The following process Import Oracle Fusion Data Extensions for Transactional Business Intelligence has completed in ERROR. Log file attached. Any ideas what has…
-
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can… -
Can we create event base value set?At customer site level user have enabled one DFF value for SALESREP_ID which display LOV of all the SALESREP email ids through one value set. Now they are asking if we c…
-
Announcing: Oracle CX Partner Enablement Training Series (Sep 8 - Oct 2)We’re excited to invite all Oracle implementation partners to join our upcoming Oracle CX Partner Enablement Training Series, starting September 8 and running through Oc… -
how to display the date set in the user preference date format in BIP reportUser has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting. The setting…Munish Kumar Mittal-Oracle 45 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle
-
ESS JOB SHWOING DIFFRENT OUTPUTHi Experts! Greetings! Recently I Came across an issue in ESS JOB FOR BIP REPORT. When I run the ESS JOB then in the attachment (pdf) one part of the report is missing ,…
-
audit reportSummary: Requesting an audit report, which must contain the information listed in the attached images. It must be filtered by report name and the date the scheduled repo…ALFONSO JIMENEZ-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle
-
How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…
-
Query to get import/update customer in Oracle Fusion based on load request IDI am trying to import/update customer and wanted to get import error messages for those customer through the BI report. But getting few error messages even the customer …
-
Assistance Required to Identify Root Cause of Number Format Issue in Custom RTF TemplatesHi Team, We’re experiencing an issue with custom RTF templates where a predefined number format behaves inconsistently—working correctly for some users, but displaying i…Baswanth Kumar Reddy-Oracle 1 view 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle -
OOTB BIP Audit Report has date filters in UTCWe are using OOTB Audit reports that log a timestamp whenever a user Open,View or Download any BIP report in the system. Customer is using them to track which users are …
-
FDI versioned dataset -- how many versions are kept in the database?In Fusion Data Intelligence Data Augmentations there is an option to select versioned dataset. Documentation states this fully extracts the object from Fusion with each …
-
How to solve this below errorI have received this error notification from oac. I am new to it and not sure where to go to check this. What I am able to understand here is that there was some failed …
-
Schedule User and Role Access Audit Report with output destination as emailHi Team, We want to schedule "User and Role Access Audit Report" and its output file to be emailed to IT team email id. Currently, we are able to schedule report but una… -
Is there a report available for all transaction across all module for leadership prospective ?I am looking for a report available in Oracle Fusion for all transactional across all module for our leadership review ? For e.g. ESS and MSS links , how many time speci…
-
ERROR CODE OAMP2OPY:OPR4ONWYI am attaching the screenshot of an error - How to debug it? What could be the issue? Please help.