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
-
May 21 upcoming webinar: The Future of Customer Experience: Product Strategy Statement of DirectionWe believe 2025 is a line in the sand for customer experience. Envision a world where: Customer experience transcends front (sales, service, marketing) and back-office d… -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available … -
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a… -
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, Nagendra
-
Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …
-
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…
-
Moved: Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle…This discussion has been moved. -
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 -
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…
-
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 23 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle
-
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… -
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 ,…
-
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 date in the format (like April 1st 2025) using RTF tags.The requirement is to display the date like April 1st, 2025 in the RTF Template using RTF Tags.
-
Roles: Missing Report and Analytics in Home > Menu after Role ChangesSummary: Hi everyone, Can anyone clarify what exact privileges are required to display the Report and Analytics function under Home > Menu? I’ve created a new role by re… -
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
-
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 … -
OTBI: HR HelpDesk Request Real Time - Line ManagerSummary: We are creating an analysis report using HR HelpDesk Request Real Time Subject Area with the ff goals: 1. If the Line Manager runs the report, the report should…
-
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…