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
-
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 …
-
OTBI Prompt to control AORIn OTBI, can we control the prompt list of alues based on area of responsibility. Example - if the employee is tagged to abc, xyz & 123 legal entity, then when opening t…
-
Change time frame (Last 30 Days) in Help Desk InfoletsSummary: The requirement is to change the time frame for the data shown in the Help Desk Infolets. How to change the "Last 30 Days"? Content (please ensure you mask any …
-
Is it possible to download a BI report PDF through API from a CRM Groovy script?Hello, We have a requirement to download a PDF from a CRM Service Request screen, when a button is clicked, so we'd like to know if it's possible to run and download a B…
-
Unclickable Pivot TableMy pivot table is coming up as not able to click into even though the settings are correct for it to be allowed to be clicked into, not sure what 'm doing wrong, the set…
-
Page Break function not working for excel(MHTML) output formatHi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We…
-
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 …
-
How do we get Customer detail(Party name, Party site name) based on the business unit.How do we get Customer detail(Party name, Account Number, Party site name) based on the business unit. Basically, I want the joining for FUN_ALL_BUSINESS_UNITS_V with hz…
-
Unable to burst a BIP report for data model based on web service?I have created a data model based on web service which I have created in OIC(exposed a SOAP based web service). This pulls data from ATP database based on parameters sen…
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …
-
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…
-
Is it possible to add conditions in etext template like when there is no dataSummary: Hi Everyone, We have a requirement not to show ("") double quotes in text output when there is no data returned from the output Can we add conditions in etext l…
-
Hi, Can somebody assist how to join external data source into subject area in Oracle Analytics CloudHi, Can somebody assist how to connect to external data source into subject area in Oracle Analytics Cloud - FDI?
-
REST API for FDI Fusion Data IntelligenceIs there a REST API available for FDI (aka FAW)? We have a requirement to initiate an incremental refresh of the FDI data after a specific event in an OIC orchestration.…
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…
-
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…
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…
-
Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…
-
Steps to add page break and print BIP report output splitting page wise through RTF templateI have BIP report with N number records and added RTF template to print the output in HTML format in fusion. When running the report, I want to view the output with pagi…
-
REST API for FDI Fusion Data IntelligenceSummary: REST API for FDI Fusion Data Intelligence to GET the information of users, groups, application roles, and data access Content (please ensure you mask any confid…
-
ESS API to submit job or retrieve job output in non-default formatI am looking for a way to retreive a non-default formatted output for an ESS job through an API. I need to submit the actual parent ESS job that runs the BI report for t…
-
when are the update for FAW?Summary: When are the updates for FAW Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Sni…
-
Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…
-
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…
-
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 …
-
1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev…
-
what is the option to get BIP and OTBI report usage details from Oracle Fusion Reports and AnalyticsWe have lots of custom reports (BIP and OTBI) piled up since years and want to cleaned up un-used reports. We are looking for any audit/usage report which will provide d…
-
Actually our dev leads asking for read only access to BI report on Prod instanceActually our dev leads asking for read only access to BI report on Production instance and we need to restrict them to query our salary , compensation, Performance relat…
-
Need to Create a OTBI analysis for Helpdesk reporting on Agents who update the SR severitySummary:How to get the old severity and New severity values updated by a given agent in the report from Help desk subject areas. I do not see this attributes in any subj…
-
Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…