Reporting and Analytics
Discussion List
-
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 41 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales -
How to cancel or terminate all scheduled ESS jobs or BIP reports in bulkSummary:How to cancel or terminate all scheduled ESS jobs or BIP reports in bulk Content : We are reimplementing the Oracle SAS Fusion Financials & Procurements Common M…Singh Rupak 179 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
When does data move from WFTASKHISTORY to FND_BPM_TASK_HISTORY_B table?Summary: We are no longer able to fetch approvers name in report using FA_FUSION_SOAINFRA.WFTASKHISTORY table. It looks like Approvers information get archived to FND_BP…Chandrashekhar_Cholli 132 views 2 comments 0 points Most recent by Chandrashekhar_Cholli Fusion Applications Administration
-
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…Grant Abbondanza 41 views 5 comments 0 points Most recent by Grant Abbondanza Reporting & Analytics for Fusion Service
-
How to get primary contact details of Partner in SQLSummary: Hi, I am working on partner object to get primary contact details of partner. not possible to get in SQL. Need to get 1.primary Contact Name 2. primary contact …
-
OTBI Succession plan - can't find fieldHello, I am working on an OTBI analysis and I'm having struggle finding some date fields. The subject area I have chosen is Workforce Succession Management - Plan Candid…Sara Suleiman 11 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
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…Sateesh Kumar 51 views 3 comments 0 points Most recent by Praveen Kumar Ponnusamy Reporting & Analytics for Fusion Service
-
How frequent views are refreshed from actual table, whether generic views rule applicable for fusionSummary: How frequent views are refreshed from actual table. Whether generic views rule applicable for fusion. We should use views or tables for frequent data retrieval …
-
Sales - CRM Resource is showing value of 'not found' in the Hierarchy Level.Summary I had some changes to use the new role as the resource role and with that there is a change in the Organization field. After that, the Sales - CRM Resource which…Cristelle Rose Sampang 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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…
-
Understand how Oracle is handling Special Characters and Non-english CharactersHello, We want to know how oracle is handling special characters and non-english characters. Also how these special characters and non-english characters are being store…
-
summing up all the columns in a cross tab reportSummary: I want to add the result of all the columns in the pivoted table to a new one, say Total. How do I do that? Content (please ensure you mask any confidential inf…Boby B Jacob 41 views 5 comments 0 points Most recent by James Branston Reporting & Analytics for B2C Service -
Is it possible to create a customer index on Oracle Cloud ERP seeded tables?Summary: We are currently using a BIP report to extract recently created transactions from ra_customer_trx_lines_all, relying on the last_updated_date field. The report …Pradeep Moganti 11 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Environment Usage Assessmentへのインプットとなるデータ量を確認する方法Summary: Environment Usage Assessmentのワークシートに記載する情報を環境から取得する方法はありますか？ Content (please ensure you mask any confidential information): Orac…xochiai.Tatsuya3 54 views 1 comment 1 point Most recent by Andrada-Oracle Fusion Applications Administration
-
How to hide headings in Dashboard filtersSummary: I have created a dashboard with 3 reports. While I run the dashboard, I can see few common filters and one filter from 1 report which is not common separetly. S…Meera Saseendran T 71 views 4 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service
-
How to rollback customized PDF templateSummary: How to rollback customized PDF template? Content (please ensure you mask any confidential information): Hi Experts, I got this requirement to rollback the custo…Liwen Chiu 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
what is this 3 lines symbol in report buiSummary: Hi, I could see a 3 lines symbol in the report header for a column, which I didnt see before. Please help me to understand what is this used for? Content (pleas…Meera Saseendran T 31 views 3 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…Carlos Benassi 12 views 2 comments 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
How to filter category dynamically in search filter when a product filter value changesSummary: Product and Category filter in analytics to behave exactly as they behave in workspace Content (please ensure you mask any confidential information): Hello All,…Rakesh Das 52 views 2 comments 0 points Most recent by Rakesh Das Reporting & Analytics for B2C Service
-
Tips for ensuring an up-to-date Hosted Named User Usage Drill Through ReportWhat is the Hosted Named User Usage Drill Through Report? Oracle Fusion SaaS customers are provided with SaaS Service Usage Metrics Reports that shows them commercial us…Yvonne Park-Oracle 473 views 0 comments 2 points Started by Yvonne Park-Oracle Fusion Applications Administration -
Searching Thread for KeywordsSummary: Hello, I have a report that searches the thread of each incident (using incidents.search_thread with the "LIKE" operator) to search for specific keywords. This …Lee Tympanick 31 views 2 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service
-
Average Handle Time for individual agentContent I'm trying to create a report that will show me each individual agent's AHT for chat. I started with a canned report that was intended for showing the AHT for a …User_2025-01-28-05-44-49-224 49 views 3 comments 0 points Most recent by Ashutosh_86 Reporting & Analytics for B2C Service -
How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI ReportHi All, How to do custom color formatting for only top 3 Horizontal bars Graph in Oracle fusion OTBI Report like below image?. Please share us your Ideas or Implementati…Sukumaran Ayyaswamy 31 views 3 comments 0 points Most recent by Manasi.Singh Reporting & Analytics for Sales
-
Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDMSummary: Is there any possibility to update the Sales Order Report Data Model - SalesOrderReportDM Content (required): Is there any possibility to update the Sales Order…
-
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…Darwin HP 81 views 4 comments 1 point Most recent by Darwin HP Reporting & Analytics for Fusion Service -
Data not showing correct values in HZ_LOCATIONS table for a particular person.Summary: Hi, I am creating a report for Longitude and Latitude using HZ_LOCATIONS table where I need data corresponding to HR_TABLES. But for 2 locations, HZ_LOCATIONS t…
-
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…Narasimha Raju 31 views 2 comments 0 points Most recent by Narasimha Raju Reporting & Analytics for Fusion Service
-
Item revision for onhand analysis reportSummary: Item revision for onhand analysis report. Content (please ensure you mask any confidential information): Created an analysis report using Inventory - Inventory …