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
-
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… -
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…
-
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_… -
Custom BIP report for Accounts payable trial balanceI am developing a Custom BIP report for Accounts payable trial balance. Here the paramters are legal entity, as on date and business unit. When I am trying to put the as…
-
which field should I use for the Validation Status of AP Invoices?I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status.
-
April 23,2025 webinar: Customer Roundtable – Achieving Success with Oracle Fusion Data IntelligenceHear how your fellow customers using Oracle Fusion Data Intelligence are benefitting from unified applications and analytics, thousands of out of the box KPIs, prebuilt … -
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…
-
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…
-
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …
-
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Can I know if there is a list of dashboards that is not part of Standard Fusion that is downloadableSummary: Is there a place where all the dashboards are available for download similar to the one available for expenses (provided by Andy in 2016) Content (please ensure…
-
Add BIP parameter list of values to ESS Job ParameterThe list of values created in BIP Publisher Report needs to be displayed in the ESS Job parameter list.Kunwar Prashan Srivastava 33 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle -
How to add date parameter while calling BIP Report using Custom ESS JobWe have created a BIP Report and calling it through ESS Job. The report is using a data parameter and we're trying to add the parameter in the ESS Job. The ESS Job is wo…
-
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…
-
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…
-
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 … -
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… -
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-…
-
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…
-
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…
-
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…
-
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…
-
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 …
-
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?
-
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…
-
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…
-
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 …