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
-
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 … -
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…
-
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…
-
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…
-
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…
-
Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…
-
Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during … -
Equivalent Oracle Cloud table columns for the EBS HZ entitiesSummary: Could you please help us to provide the equivalent Oracle Cloud table columns for the below EBS HZ entities? EBS Table Name - Column Name HZ_PARTIES - CUSTOMER_…
-
Oracle Customer Excellence Awards - Nominations are OpenYou’ve done incredible work. Now you deserve the recognition. The Oracle Customer Excellence Awards celebrate the very best of business innovation, showcasing how organi… -
roles or privileges to enable a user to create Data Model via the Fusion OTBI web servicesSummary: I'm new to Oracle Fusion Cloud. We have a Service Account that we intend to use to create a Data Model in the Fusion reporting module (called OTBI that's bundle…
-
Oracle BIP Report Email Delivery to Outlook Distribution ListSummary: We are attempting to use Outlook Distribution listings in report delivery associated with BIP report schedules, but they will not deliver. The jobs complete suc… -
Query to get Roles hierarchySummary: A query to get role hierarchy by role ode Content (please ensure you mask any confidential information): Want a query where i can pass the role code, and get al…
-
Please help with the database column for 'Exchange Gain Or Loss' in Fusion ReceivablesSummary: Need database column for 'Exchange Gain Or Loss' in Fusion Receivables Content (required): There is a column when managing receipts in Oracle Fusion Receivables…
-
Oracle BIP Report Job ends in error: ORA-56733: logical I/O limit exceededWe have a customized report that when is scheduled ends in error: ORA-56733: logical I/O limit exceeded. What's weird is that when we run the report via the catalog with…
-
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…
-
How to prevent users from editing and deleting Custom ReportsSummary: We have seen many instances of users deleting custom reports from the Custom Folders, inadvertently. We then had to restore those reports from backups from lowe… -
RTF Template output alignment issue with Outlook appHi Team, We have recently created a welcome letter using an RTF template, which includes a logo at the top followed by the details in the email body. When we check the o…