Reporting and Analytics
Discussion List
-
APIs or web Services for Om TasksSummary: I have a requirement to configure the configurations using web services or API's for the below tasks, can someone please help me with web services/API's? OM Tas…Jai.S.Chavan 11 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 1 view 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Adding Pending Approver to a ReportWe need to add the next approver to a Report. We are unable derive the next approver (to whom the requisition is not yet assigned for approval) for requisitions which ar…Eddie Zucker 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to get the approval history for Claims?Hello. I am trying to build a custom report that would get the approval history for claims (approvers, latest date of submission, etc.). Does anyone have any idea on wha…missy_21 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…srikanth gollapally 22 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Error adding PVO to BICCHave SR open—no useful response yet so looking for other response. Error adding an existing PVO in BICC shows this error " [BIACM0185] Error saving data store due to [BI…JDC 43 views 3 comments 0 points Most recent by Mark Di Ponio Reporting & Analytics for Fusion Service
-
Connect to OAC via a REST serviceHello.I wanted to ask about a feature I need to create for my company.In this case, I need to download CSV files from OAC. I have some reports that were provided to me, …wilberth Canales Romero 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to enable drill-down for BIP reports.Summary: Need to enable drill-down feature for BIP report in oracle fusion cloud. Content (please ensure you mask any confidential information): We have created one regi…
-
PO PDF templateWe have created a custom PO PDF template for the customer The user is able to download any PO PDF when the document amount < = 999 $/Rs/Euro(Any currency) But for amount…Kinjal Patel-Oracle 41 views 2 comments 3 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service
-
How does the data get restored into a useable format so that reports can be generated?Hi Team, Could you please help with the following query. Client is running SaaS Fusion ERP, HCM, SCM, and a few others. Client is dissolving and going out of business Cl…Vbhat_19 42 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
External logging to Sumo Logic or SplunkHi, any guides how to configure our new Oracle ERP Fusion to forward its logs to an external logging SAAS like Splunk or Sumo Logic? Logs like who is logging on to our F…
-
Link Action in the Analytics ReportSummary: The Link Action is not returning the correct result. The URL is not working as expected in the defined parameters. The URL below is directing to another page as…
-
Rel 13.20B User Adoption – Object Activity and Resource System UsageContent User Adoption metrics help CRM stakeholders continuously measure the success of their CRM implementation. Using these metrics, CRM business leaders can obtain cr…Sudharshanan K B-Oracle 1.4K views 25 comments 21 points Most recent by Pavan Kumar Thummalapalli Reporting & Analytics for Sales
-
How to change column sorting in Express Report?Summary: How to change column sorting in Express Report? Content (please ensure you mask any confidential information): The output is always sorted by the first column/g…Chin Chi-Oracle 31 views 5 comments 0 points Most recent by Chin Chi-Oracle Reporting & Analytics for Sales
-
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. 51 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 25 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 23 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 1 view 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 268 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 23 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Service