Reporting and Analytics
Discussion List
-
Stop incidents duplicating when joining to threadsSummary: I have a basic queues report counts the volume of open incidents by queue and date. It has a drill down filter that then lists the incident in detail its ref an…spence_abcd0109uk 51 views 7 comments 0 points Most recent by spence_abcd0109uk Reporting & Analytics for B2C Service -
Exported Excel with no records shows columns all distortedSummary: Hi Team, For certain report, the client wants the auto emailer for when there is no records in the excel for that specific filters. We have customized the error…Haider Saifee 32 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Supplier Owned Consigned Items valuationSummary: Does Period Inventory Valluation Report consider the inventory value for consigned items those are owned by supplier? Content (please ensure you mask any confid…Anurag Kumar Pandey 31 views 2 comments 0 points Most recent by Anurag Kumar Pandey Reporting and Analytics for SCM -
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 44 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service -
Application Usage Insights Dashboard Not Showing Data - Missing ProcessesSummary: Prerequisites to setup AUI dashboard: Content (please ensure you mask any confidential information): I'm trying to set up and configure the Application Usage In… -
FDI Report AccessHi, I am currently unable to see any workbooks in the FDI environment but a different user is able to for the same environment. What would I need to change for my accoun…User_EO6AY 41 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
What is the proper alternative to Adaptive Search aggregates Roll-ups is NOT itSummary: Roll-ups and Adaptive search aggregates (from what I understand) are not the same thing functionally. So if Adaptive Search is being deprecated, what do we use … -
Exported Excel from Data Model Reports has names repeating twice in its File NameHi Team, We have created few reports using the data model in the CX Cloud. the reports are running as expected. But whenever we export the file as excel from the reports…Haider Saifee 41 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Get Data from OTBI to PowerBIIs there a way to get data from OTBI to integrate to PowerBI?Anj M. 111 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Can we create custom folder in UCMHi Team, Can we create custom folder on UCM.vikram khengare 21 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Possibility to combine multiple rows into one cell in Oracle SQL data base.Summary: I have a query regarding the possibility to combine multiple rows into one cell in Oracle SQL data base. We have tried STRING_AGG, LISTAGG and WM_CONCAT, but no…Lizy Lazaro 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Sorting the actual filter view?Is there a way to sort the actual filter view, so the checkbox/selections are in A-Z order. For example - I have a QUEUE filter - I want the queue list in the All Items …Joe P. 21 views 2 comments 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
Report to show periods where no Chat agents were availableSummary Trying to identify gaps in Chat agent availabilityContent Hi, I'm trying to find the easiest way to find periods where there were no Chant Agents in Available st…User_2025-02-03-17-31-49-785 17 views 1 comment 0 points Most recent by Marissa Gonzales Reporting & Analytics for B2C Service -
Query or tables Details on LDAP User and Policy Stripe ColumnsSummary: Could you please provide me with the table names or the queries related to the following two columns: LDAP User Policy Stripea Content (please ensure you mask a…Shruti Agrawal 31 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
System Performance Health CheckSummary: We are seeking a solution that will help us monitor the health of our ESS Jobs. Something that would alert us of long run times, threads getting hung up etc. We…Schneider.Mark 21 views 3 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
BICC View Object encountering errors on extract.Summary: We would like to seek assistance on this Issue. BICC Extract is failing and upon investigation, removing the Role Code column in View Object ResourcePartnerPVO …Carlo Orolfo 32 views 3 comments 0 points Most recent by Carlo Orolfo Reporting & Analytics for Sales -
Is it possible to zip multiple template layout outputs from a single report into a single file?I'm looking to understand if there is a way to consolidate multiple template layout outputs from a single report into a single zipped file. If anyone has experience with…Omran Zeaiter 21 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
Consigned Inventory ValuationSummary Consigned Inventory ValuationContent Our healthcare organization is new to Oracle Cloud Fusion SCM. I ran inventory valuation reports (from scheduled processes) …Pattianne Belitz-Children's Hosp Omaha 60 views 3 comments 0 points Most recent by Pattianne Belitz-Children's Hosp Omaha Reporting and Analytics for SCM -
Freezing of Headers in a Pivot TableSummary: We have this analysis showing multiple records. Is there a way to freeze the pivot table header view in this dashboard? We have checked Oracle documentations an…Kelvin Jamil Reyes 22 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Multi Select field in UI returning Lookup Code in OTBISummary: We have this field in Sales UI having an FCL multi select in Division custom field. We have tried to add DESCRIPTOR_IDOF in this field however it is showing bla…Kelvin Jamil Reyes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to get the status and log file for a child ess job using websericves.Summary: Hello, Team. Greetings for the day We have a requirement to send out the log file of a failed ess job, but in our case, the actual error log file is generated a…User_2025-10-24-00-15-43-324 241 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Service -
using inc_performance type=7 gives duplicate rowsSummary: When adding the first closed date from the inc_perf table to my report, I get two rows for every solved incident, one with a closed date and one with no closed … -
BI Publisher template builder for Excel and Word Plugin in Microsoft integrated appsSummary: Hi Everyone, Our customer is moving to Microsoft integrated apps where all manual plugins will go away. Which means any plugin will be handled in MS Office 365 …Murugaganesh 41 views 4 comments 0 points Most recent by Murugaganesh Reporting & Analytics for Fusion Service -
SCM seeded report including bin location and on order countI'm needing a SCM report that has the bin location, and also the on order count. Does anyone know of a report that includes these two fields or know of what table I can …JWilliamson 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM -
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input… -
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 61 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Service Infolet doesn't show dataSummary: Hi I am trying to activate the infolets to make use of the analysis of the service team. But I can't find any documentation that allows me to make the settings …Johannys Lozano 51 views 1 comment 0 points Most recent by Daniel Placinta -Support-Oracle Fusion Service