Reporting and Analytics
Discussion List
-
Pull Contacts in the Contacts Report using Account Manager and Regional Manager criteria.Summary: What is missing or incorrect in below queries or approach we are trying to use. Criteria: As an Account Manager when I launch the Contact Report, I would see My…Myles S. 52 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Unable to burst a BIP report for data model based on web service?I have created a data model based on web service which I have created in OIC(exposed a SOAP based web service). This pulls data from ATP database based on parameters sen…Shikha Charadva 41 views 4 comments 0 points Most recent by Saptadip Datta DXB Reporting & Analytics for Fusion Service
-
Where can I get the list of standard reports for Sales?Summary: Where can I get the list of standard reports for Redwood Sales? Content (please ensure you mask any confidential information): In previous version, there is a l…
-
How is the ‘Result view’ generated when the same subject area is joined more than onceWhen I create an analysis and report in Oracle Fusion Cloud and include the same subject area more than once, I sometimes see a “Result view” appear as part of the union…Andrea Lopez 21 views 1 comment 2 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Development.…Noelle Bartlam-Oracle 3.7K views 15 comments 11 points Most recent by Sachin Bhadange Reporting & Analytics for Sales
-
How to remove Carriage Return in the CSV files generated by the BIPHello, This is in 25C. We are generating a CSV file out of a BIP report that has output like this. As we can see from the above, line #1,#2 and #3 are part of the questi…Darsh123 22 views 3 comments 0 points Most recent by James McBride Fusion Applications Administration
-
Seeking Solution: Account Hierarchy Roll-up Report for Leads, Opportunities, and Service RequestsSummary: Hello Community, We have a business requirement to build a comprehensive dashboard or report in Oracle Sales Cloud that provides a consolidated view of Accounts…Sudheer V-Oracle 11 views 3 comments 0 points Most recent by Sudheer V-Oracle Reporting & Analytics for Sales
-
Users not able to see ess custom jobsThe BI author role is assigned to the users and report level the permission is given to BI author role, still users are not able to see the Reports from Tools—>Scheduled…Chandana.palaparthi 27 views 1 comment 0 points Most recent by HD - Fusion ERP-Oracle Fusion Service
-
how to add a column for who closed incident in a reportHi, I need to add a column in a report. How to get incident closed by details in a report? Regards, MeeraMeera Saseendran T 31 views 3 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service
-
How to add drill down to total in reportsI need to add drilldown report to total of cases: How to do that? Thanks, MeeraMeera Saseendran T 21 views 4 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
How to get total email count and AHT in a reportI am looking for a way to get a count of all emails sent by the customer, and average handle time for the agents (AHT) in a particular queue. So if a customer sends 3 em… -
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…Martina Di Battista 2 views 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Fusion Service
-
Build BI Report on Contact Deduplication CX SalesOn our instance there are around 20000 duplicate contacts so we want to build a report on Contact Duplication data. Same report output will be send to business for appro…AMIT KUMAR YADAV 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to create analysis to identify contacts with duplicated e-mail?Summary: How to create analysis to identify contacts with duplicated e-mail? Content (please ensure you mask any confidential information): Hi, We're trying to create an…Max Prestes 31 views 10 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Business Intelligence Publisher Bursting to Email upper ThresholdContent Business Intelligence Publisher Bursting to Email upper Threshold Requirement: 50000 Bursting records get selected and they need to be sent as Email Attachment i…Shivakumar Ayyanagowdar-Oracle 269 views 13 comments 1 point Most recent by Prudvi_Batlanki Reporting & Analytics for Sales -
Smart text usage report in Fusion serviceSummary: I am looking for smart text usage report in the ADF in the fusion service. We have a subject area in the analytics "CRM/Help Desk - Service Request SmartText Us…Varun Thankappan 21 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Service
-
How to get latest updated records from ess_request_history ?Summary: Hi team, We are building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’…
-
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …Nikhil_Samudrala 62 views 4 comments 0 points Most recent by Nikhil_Samudrala Reporting & Analytics for Fusion Service
-
Internal Server Error while calling /biacm/rest/meta/export APISummary: We are encountering an Internal Server Error (500) while trying to get a response from the API endpoint /biacm/rest/meta/export. Has anyone faced a similar issu…PremC 11 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Looking for file path of Audit Report in Oracle FusionSummary: Hi All, We would like to customize "Generate Audit Report" the seeded report provided by Oracle, kindly help us with the report files path so that we can custom…
-
CX Sales Dashboard control by which role and privilegeSummary: There is no CX Sales role assigned to user but still they can see the dashboard in landing page, want to know which role or privilege provide this access. Also … -
Finish tab in custom script reportSummary: Can any one help us how we can use custom script in service cloud report Content (please ensure you mask any confidential information): We have successfully abl…Santosh kumar purusottam 21 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …
-
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.Peter Obong 14 views 3 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for SCM
-
Inquiry on Standard Report for Tracking Manually Released Invoices by UsersSummary: Is there a standard report available in Oracle Cloud OTBI/Scheduled Processes that tracks and reports invoices manually released by users within a specific peri…Temi A. 1 view 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
How to hide "Reports and Analytics" for a user.We have a requirement to create a custom role a specific user to run only programs using Scheduled Processes. But we are also seeing "Reports and Analytics" even without…Sadanand Gunda 63 views 5 comments 0 points Most recent by James McBride Fusion Applications Administration
-
How to retrieve full update history for a specific Opportunity via OTBIThe business requirement is to retrieve all records/updates (audit history) related to a specific Opportunity in Oracle Sales Cloud, using OTBI. Required fields to be re…Paraskevi Thanasi 82 views 6 comments 0 points Most recent by Paraskevi Thanasi Reporting & Analytics for Sales
-
Documents required for integration of fusion Audit log with SPLUNK.Summary: We are trying to integrate Audit and Admin user activity logs to a log monitoring tool call as SPLUNK. Help us with some documents around the integration is the…Poonam Yadav 37 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Fusion Application Performance MonitoringSummary: We have an initiative and plan to run approximately 40 BIP scheduled reports concurrently, and we wanted to assess any potential impact this could have on the u…JEngalan 22 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …Sudeepto 24 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM