Reporting and Analytics
Discussion List
-
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 103 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 197 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 52 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 3 views 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 42 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 13 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
-
We need a Dashboard for all Scheduled Job in CX Sales and Service ProductSummary: We have around 15 Scheduled Jobs running in our instance and also 12 Agents (report agents). Business wants a dashboard or workarea where we can see status of a…
-
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…Kunwar Prashan Srivastava 117 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to Update an DataModel/Object in the BI Publisher Catalog Using the CatalogServicewe are trying to implement a solution to migrate BI(Data Model and Report) into oracle SAAS from Source to Target folder using Oracle standard WSDL- https:// /xmlpserver…Avilash1265 84 views 2 comments 0 points Most recent by Avilash1265 Reporting & Analytics for Fusion Service
-
Analytics CookbookContent Welcome to the Analytics Cookbook! This is an exciting resource intended to help with your Oracle Service Cloud Analytics. How do you measure the value your orga…Kenny Tietz-23935 6.7K views 3 comments 64 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
OTBI Agent does not send out an emailSummary: We have a daily agent which sends an email with an excel file attachment. The agent run successfully daily until a week ago, when running the agent we can see t…
-
how to calculate incident edit time for each transactionsSummary: Hi, I need to create a report for getting incident edit time of an incident. edit time for each agent in same incident is needed. Regards, Meera Content (please…Meera Saseendran T 11 views 2 comments 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Ask a Question FormSummary: Does anyone know the maximum number of characters that can be in the Summary and Question fields on the Ask a Question form? Content (please ensure you mask any…Dorothy Norman 93 views 3 comments 0 points Most recent by Dorothy Norman Reporting & Analytics for B2C Service -
BI Report: multiple filters return no results but when filters used individually returns recordsSummary: I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportuniti…Tonya H 42 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Specific information regarding the UCM (Universal Content Management) folderSummary: Requesting for some specific information regarding the UCM (Universal Content Management) folder that we are currently working with. Accessing View Object Files…Carlo Orolfo 21 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Is it possible to schedule ESS jobs in bulkWe currently have around 1,500+ ESS jobs, and we are looking for a solution that would allow us to schedule these jobs in bulk. All relevant job details are stored in an…Deep Mehta-Oracle 61 views 2 comments 5 points Most recent by Deep Mehta-Oracle Reporting & Analytics for Fusion Service
-
Alignment issue in Absence Approval Seeded notificationSummary: Let me explain theissue clearly how the notification is been triggered in Responsive UI andRedwood in over mail and in bell notification.Responsive UI level the…