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
-
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…Elise Hymes - Oracle CX-Oracle 12 views 0 comments 0 points Started by Elise Hymes - Oracle CX-Oracle
-
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 …
-
how to pass dynamic input values in BIP REPORTDear 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 …
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…
-
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_…
-
List of data Masked/Obfuscated during P2T refreshWe need the entire list of data masked/obfuscated in Oracle Financials cloud during P2T refresh to share with customer to identify the masked/obfuscated data in the shar…
-
How to fetch the time period for fetching the salary details of the employeesSummary: I am working on a query to fetch the period name as per the payroll name selected from the LOV as parameter to fetch the salary details of the employees . I am …
-
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…
-
COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_valuesHi Guys Does anyone please have a list of what each attribute is in the COMPILED_VALUE_ATTRIBUTES field in table fnd_flex_values? Data Source : ApplicationDB_FSCM E.G. C…
-
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…
-
I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,
-
invoice_id is blank in ap_trial_balances_gt tableHello All, We have a requirement to create a custom Payables Trial Balance Report by copying and customizing the data model to add more columns from ap_invoices_all tabl…
-
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…
-
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 …
-
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…
-
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…
-
I am creating a data extraction query, but cannot fetch rule name and to link to discount list.Would appreciate help if you could provide the table name and the respective join for this.
-
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…
-
FDI impact on SaaS Performance?Summary: FDI has been set up to do additional reporting. We´re worried about how it can impact on SaaS performance. Content (please ensure you mask any confidential info…
-
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…
-
BI Publisher Report QuestionOne of the fields that's being exported to excel in a BI Publisher Report contains line breaks within the actual characters. The business does not want to export to CSV …
-
Need to hide a sheet when no Data Exists in Excel Mutilsheet Excel Template ReportHello I created a Data Model with multiple data sheets in Oracle Cloud BI. I have also created a multisheet Excel Template. The template is working fine but i want to hi…
-
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…
-
Reports are not filtering the data on dashboard based on the parameterSummary: We have created a Dashboard in which we have attached some OTBI Reports and BIP reports and filtering the data based on the date parameter, it is filtering the …
-
Inventory on hand report in FusionIs there a standard report in Fusion that has inventory on hand by subinventory, locator, lot?
-
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…