Reporting and Analytics
Discussion List
-
Schedule User and Role Access Audit Report with output destination as emailHi Team, We want to schedule "User and Role Access Audit Report" and its output file to be emailed to IT team email id. Currently, we are able to schedule report but una…Anupam Rana-Oracle 22 views 3 comments 0 points Most recent by Anupam Rana-Oracle Reporting & Analytics for Fusion Service -
Is there a report available for all transaction across all module for leadership prospective ?I am looking for a report available in Oracle Fusion for all transactional across all module for our leadership review ? For e.g. ESS and MSS links , how many time speci…Devesh Shah 21 views 8 comments 0 points Most recent by Devesh Shah Reporting & Analytics for Fusion Service -
ERROR CODE OAMP2OPY:OPR4ONWYI am attaching the screenshot of an error - How to debug it? What could be the issue? Please help.Neelotpal01 13 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj…Curtis Allen 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Hi all, in bursting can I put the dynamic file name? example concatenate it to today's launch date!Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Emanuele De Marchi 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for B2C Service -
How to Create a Data Set Using a Web Service in Oracle FusionHi Experts, I tried to create a data set in BI Publisher using a web service that returns valid XML data. I referred to this document: Creating a Data Set Using a Web Se…Krishan_Palihakkara 41 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Getting error 401- Unauthorized error while calling WebService from Oracle Fusion BIPWhen we are calling Webservice from Oracle Fusion BIP , OIC is triggered but going into error 401- Unauthorized, however we are using the same User Name in OIC and BIP b…Hitesh Jasuja-Oracle 96 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
I have build the report using service request object with custom subject area but getting error.Summary: I have build the report using service request object with custom subject area and trying to map the reference number to SR number (custom object custom field) b…Manjula Bellamkonda-Oracle 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Reporting on opportunity assessment questions and answersSummary: I'm trying to generate a report for one of my customers with the following data: Opportunity Name, Contact Name, Assessment Score, Assessment Date, Question, An…Cristian Rogelio Velasco Gutiérrez 21 views 1 comment 0 points Most recent by Ravindra Sirigiri-Support-Oracle Sales -
Need BI Report to get total Payout amounts per plan components in SalesSummary: Hi Experts, We are looking for BI Report to get total Payout amounts per plan components, the sum needs to group by based on Plan Name , Component Name, Perform…Rama123-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Time in Status (Transactions Calculation w/ Custom Script) - Analytics Cookbook RecipeContent Time in Status Calculates time using custom script Author: Bastiaan van der Kooij Independent Oracle Service Cloud Consultant Difficulty rating: (Advanced) Targe…User_2025-02-03-19-30-01-975 334 views 9 comments 15 points Most recent by Archana Rajendran Reporting & Analytics for B2C Service -
How to create Employee as a SupplierWe have a requirement to create Supplier records for all active Employees. Please advise on the best approach to establish a link between the Employee and the correspond…Kinjal Patel-Oracle 72 views 3 comments 3 points Most recent by Umar Reporting & Analytics for Fusion Service -
Adaptive Search Query: No Data Displayed for ListOfContactsHi All, I am trying to fetch data via adaptive search query. Despite enabling the field, I have noticed that no data is being displayed for ListOfContacts. Could you ple… -
Sql query or Table name for Offering and Functional area for Opt in features in Oracle fusionSummary: Hi Team, We are stuck to find the table or query for Functional area and Offerings. Navigation: My Enterprise → New feature or Offerings. We have the below tabl…Opkey PA 121 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service -
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
BICC external storageSummary: We have to send bicc files to external storage allocated in a s3 site. wich kind of serviceName i'll request from my aws technician to make bicc get container n… -
OOTB Express Report Type on Territory HierarchySummary: Users want to create Express Report on Opportunity along with Territory and its Hierarchy. SA like is apt for this requirement but its unavailable as a OOTB re… -
Redwood: How to add OTBI reports in Redwood Sales Dashboard without creating visualization?Summary: We had OTBI dashboards in Classic UI that were added in Account and Opportunity page subtab. Now, how can we display these dashboards to Sales Dashboards as sub… -
Why is country code "CZ" missing in fusion.psc_com_country_bSummary: Why is country code "CZ" missing in fusion.psc_com_country_b to convert country codes between ISO 3166-1 alpha-2 and ISO 3166-1 alpha-3 or ISO 3166-1 numeric. C… -
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: I am building a custom report - Payable Trail abalance. But while running the report, I am getting Report data size exceeds the maximum limit (524288000 bytes).…Ritu123 228 views 3 comments 1 point Most recent by Erick.B Reporting & Analytics for Fusion Service -
Connecting Activities to Business PlanSummary: Is it possible to connect an existing Activity to an existing Business Plan? I know you can connect existing Opportunities and Leads to Business plans, but for …Meheffler 21 views 3 comments 0 points Most recent by Carmen, User Assistance Oracle CX-Oracle Sales -
Join chat_queue_stats with Incidents TableSummary: When I join Join chat_queue_stats with incidents table, it removes data and shows blank I need to join the tables, becuase I need to know what agency the client…Marissa Gonzales 51 views 7 comments 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
What is the BICC PVO for FND_VS_VALUES_B Fusion table that has the attribute values?We are on FDI 25.2. I have found some PVOS like FscmTopModelAM.AnalyticsServiceAM.ValueSetTypedValuesPVO in BICC that map back to the valueset/code data in Fusion data b… -
In Cloud Fusion need ability to audit changes in the admin profile optionsI need the information whether it is the correct Oracle doc or just an answer on how to enable and then report on how to report on any changes made using manage admin pr…Mike P 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
How we can find the extract name and BIP report path using the flow pattern and task nameSummary: Hi All, I need assistance in identifying the Extract Name and BI Publisher (BIP) Report Path based on a given Flow Pattern and Task Name in HCM. Could you pleas…Raushan Tiwari-Oracle 41 views 1 comment 0 points Most recent by MandeepGupta Fusion Applications Administration -
How can I remove a candidate from a report when candidate is hired under any other position?Hello! Our team is trying to create a report in OAS where we can see candidates that are under a specific step/status on any position, but we want the candidate to be re…Laura Glez 12 views 0 comments 0 points Started by Laura Glez Reporting and Analytics Taleo Enterprise -
What is the Subject Area to retrieve Invoice DetailsSummary: We are currently retrieving invoice details using a DM (Data Model) report with the SQL query provided below. Now, we want to create an Analytics Report using a…Anusha716 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales