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
-
MICR line zeros showing too smallHi, We have created a cheque rtf template and to display the MICR line we have used MICRE13B font as per the bank suggested font and font size is 13. However in the MICR… -
OTBI Report - Advanced Query - presentation variable is null, how to handle?Summary: In OTBI Report, I have used Advanced Query to combine multiple subject areas. As a parameter I'm using presentation variable. If the presentation variable is pa… -
How To Remove Data Augmentation Column From Subject AreaSetup data augmentation to bring additional attributes to the subject area. Now I've deleted that data augmentation table from data augmentation screen, But still I can … -
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_… -
Oracle BIP Bursting to AWS S3Summary: Oracle bursting definition requires a folder specified; however, no folder exists when bursting to AWS S3 bucket. Content (required): I have a requirement to co… -
How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance. -
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 … -
Every report where a field is being usedHello, is it possible to determine all reports that contain a specific field? We are adding new values to a field's LOV, and want to know every report that may be using … -
why the Export Data has different results than Export FormattedSummary: why the Export Data has different results than Export Formatted Content (please ensure you mask any confidential information): We are actually trying to export … -
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 … -
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 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… -
How to generate BIP report bursting output in PDF and HTML bothThe requirement is to get the email notification through bursting BIP report as an attachment and email body both. The template of the report contains tables , company l… -
Filter unique values in a custom object on a DCL fieldSummary: A custom object has one of the fields as DCL(Dynamic Choice List). This DCL is in turn dependent on a custom object (LOV custom object) which will have duplicat… -
Does Oracle Analytics publisher desktop needs licensing?We are already using Oracle Fusion cloud. For creating BI report templates, we would require Oracle Analytics publisher desktop. Do we need additional license to downloa… -
Drill Down in Reporting not workingSummary: My pivot table is coming up as not able to drill down into even though the settings are correct for it to be allowed to be clicked into, not sure what I'm doing… -
Case Management/HR Helpdesk delivered OTBI reports not openingHi Everyone, I am facing issue accessing the delivered case management OTBI analyses that is found under Shared Folders > Service > Embedded Content > all Help Desk subj… -
Does BI Publisher SFTP delivery connection support with Azure SFTP server ?Does BI Publisher SFTP delivery connection support with Azure SFTP server ? -
Inventory on hand report in FusionIs there a standard report in Fusion that has inventory on hand by subinventory, locator, lot? -
How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li… -
25B REDWOOD INVENTORY MANAGEMENTIn 25B Inventory Landing Page - Reports and Analytics option is not available in REDWOOD UI but available in Classic UI. -
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 … -
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in Requisitions -
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. -
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj… -
Need a Report of all the approvers once the PR Approval is initiatedSummary: We have requirement to include display all the PR approvers in a BIP report as soon as PR approval is initiated. During the investigation found out that only th… -
we have requirement to pull the data from Fusion Custom Apps Lookup. Is that same Fnd_lookup_valuesSummary: we have requirement to pull the data from Fusion Custom Apps Lookup. Is that same Fnd_lookup_values or do we need to pull differently? Content (please ensure yo… -
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…