Reporting and Analytics
Discussion List
-
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 31 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 21 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 43 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 62 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 57 views 1 comment 0 points Most recent by Daniel Placinta -Support-Oracle Fusion Service
-
Custom View ESS Role is behaving unexpectedlySummary: There is a custom role created for business to provide access ESS history to certain users. The role was created under Role Category 'Common - Abstract Roles' w…Rahul_M8SG8 24 views 1 comment 0 points Most recent by Andrada-Oracle Fusion Applications Administration
-
Send custom report to Microsoft SharepointSummary: A custom report needs to be scheduled and sent to MS share-point. Content (please ensure you mask any confidential information): We have a custom BIP report tha…A V K JAYA SURYA 141 views 1 comment 1 point Most recent by Iulian Hanza-Support-Oracle Reporting & Analytics for Sales
-
How to schedule a BI Weekly run of scheduled reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way we can add the link of Attachment in a report?Summary: is it possible to create a report that will include the link of attachment? Example an opportunity record have a document attached. we would like to create a re…
-
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 41 views 3 comments 0 points Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
Data type - HTMLSummary: We have a field with long description and the data type set as 'html' in the column properties , so now in the dashboard that field is displaying the data corre…
-
How to restrict Inventory Items or On hand data based on User data access role in BIP Reports?Hi All, We have a requirement to restrict the Inventory Items or On-hand data based on User data access role Org assignments through BIP Reports. Currently, we have buil…Nagaraju Vandavasi 22 views 5 comments 0 points Most recent by Nagaraju Vandavasi Reporting and Analytics for SCM
-
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job?
-
How can we enable audit in Fusion BIP layer to track who executed what query and when?As we do not have any way to restrict a user with Reporting and analytics access in Oracle Fusion to view data of certain tables. Hence, we're looking to explore the aud…PranjulG 45 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
How can we export attachments from opportunity objectSummary: We want to know the process to export all the attachments from opportunity object. Content (please ensure you mask any confidential information): We want to exp… -
How to get details of ESS jobs and the associated logs into an onprem monitoring tool like SplunkSummary: I am trying to get details of the scheduled processes and its logs from fusion cloud application (specifically Subscription management cloud) into internal Splu…Kumar Masand 71 views 2 comments 0 points Most recent by Vijaya Sekhar A-Oracle Fusion Applications Administration
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 157 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM