Reporting and Analytics
Discussion List
-
View analytical reports in SFA from other users as adminSummary: View analytical reports in SFA from other users as admin Content (please ensure you mask any confidential information): Dear All, There is a way to view the rep…AlexFH 21 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Has anyone had success adding 3rd party UI/UX analytics tools to CX Sales?Summary: I'm interested to see if anyone has had luck connecting any 3rd party UI/UX analytics tools into CX Sales, such as Adobe Analytics or Mixpanel. I need to unders…
-
Export Bulk dataContent Hello, I am trying to export bulk data. I want to build a scheduled process that runs every day and in case of an error, the next run will include all the data s…
-
Last activity date w/ owner of last activity by accounts reportWe have a number of reports on our OTBI Dashboards that looks at last activity by account by a few different categories. Recently we've felt that bringing in the name of…mfribeiro 21 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Count of Opportunity for a Custom ObjectSummary: We have created a custom object (Sub Account) and it is related to Opportunity. One Sub Account can have many Opportunities. We want to show the count of opport…
-
Report to find the number of times an opportunity close date is updated.Summary: Is it possible to create reporting in OSC to track Opportunity push counts. (Push count - Number of times an opportunity close date is updated) The two scenario…
-
In OTBI, is it posible to center the bar on the graph if the second bar has no results?Summary: In OTBI, is it possible to center the bar on the graph if the second bar has no results? Content (please ensure you mask any confidential information): In OTBI,…Rubielyn Tomas 32 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Redwood - Can we add OTBI Dashboards or Reports to Foldout Panel viewSummary: Can we add OTBI Dashboard or Reports as Redwood Foldout Panel. ? Content (please ensure you mask any confidential information): Version (include the version you…
-
CRM Application Composer not available in Audit Reports Product dropdownSummary: Our Business team needs to be able to view Audit Reports for Custom Object as an alternative to the slow loading of Change History table for each object record.…
-
Trying to Find Table With List of JOB_TITLE_CODEs Appearing in Manage Contacts/HZ_ORG_CONTACTSSummary: I'm building a BI Publisher report that is pulling in the Customer Account Contacts, and am trying to find the table that has the list of Job Title Codes that a…
-
OTBI Report to pull Opportunity details with team membersSummary: Need an OTBI report on Opportunity and associated team members Content (please ensure you mask any confidential information): How to expose Opty team members de…S.Kumar 72 views 5 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Error in casting date in OTBI Reports ConditionSummary: I need to display a different formatting in date time. However, when I try to use the To_DateTime("Goals_c"."FacetoFaceMeeting1_c", 'YYYY-MM-DD') condition, it …zelagozum 32 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to create a Last Completed Activity in OTBISummary: I have created a report in OTBI using a custom subject area based on primary object Opportunity however there is one more field i would like to add to this repo…Jay Patel-157091 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
CRM Database Tables for via SQL/Analytics Query - Oracle Sales Cloud (FUSION)Hello, Everyone. Is there a documentation for Oracle Sales Cloud (FUSION) CRM Database Tables that can be used for SQL/Analytics Query. I am building a report where User…Christian Gerald Patacsil 93 views 2 comments 0 points Most recent by Christian Gerald Patacsil Sales
-
How to use custom field as parameter in Analytics Sub TabSummary: Hi, i referred below link. this is for Standard Id field But how to use custom field as parameter Content (please ensure you mask any confidential information):…VIBHA S D 22 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Retrieve Scheduled Processes Report via SQL/Analytics Query - Oracle Sales Cloud (FUSION)Hello, Everyone. Does anyone know if it is possible to Get/Retrieve Scheduled Processes Report/Data via SQL/Analytics Query -in Oracle Sales Cloud (FUSION)? similar to t…
-
How can I view or export the information of a deleted lead?I need to see the information of some leads in Oracle Sales Cloud that have been deleted, I have tried to get this information through SQL, POSTMAN, EXPORTS, but I see t… -
Is there a way to get overlay credit details in opportunity OTBI report ?Summary: Is there a way to get overlay credit details in opportunity OTBI report ? Content (please ensure you mask any confidential information): Version (include the ve…Rehana Tadimerri 21 views 4 comments 0 points Most recent by Rehana Tadimerri Reporting & Analytics for Sales
-
Sales Reporting - to Excel including detailed product line itemsSummary: We are looking to be able to get reports in Excel that show opportunities by sales rep by close date by Forecast status that include the detailed line items inc…
-
How to create Purchase order which Requisition is having more than one RequisitionLineIdHow to create Purchase order which Requisition is having more than one RequisitionLineId . using REST API -------> API details for creating PO using single RequisitionLi… -
BI Report Not giving correct Result Based on Multi Choice list value Printable ViewSummary: I have create Subject area report & we are filter data based on Multiple choice list. But Its not returning result Using data from 2 custom objects (i)View Docu…VIBHA S D 21 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to get the audit logs for admin related activities in oracle sales cloudHi, We have a business requirement as per Security guidelines from customer, where we need to track the admin related activities like activating/inactivating user, addin…
-
BIP SQL to Retrieve Meaning Instead of Lookup Codes for Multi-Select FCLsOur organization has a requirement to depict the meaning of a multi-select FCL in a BIP report. The attribute currently pulls the lookup codes properly, but when applyin…Anthony_La 249 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Application Usage Insight-Whether total session duration is in minutes?Hi Team, In the application usage insight dashboard, we have multiple reports to track the sign ins and duration. I just needed a clarification on the 'Session duration'…
-
How to use images dynamically in BI Publisher RTF templateSummary: How to add conditions to the RTF template. checked on this Oracle Fusion BI Publisher: How to use images dynamically in BI Publisher RTF template (Doc ID 240985…VIBHA S D 366 views 2 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Express ReportHi, Is the express reports are available only for Opportunity object please clarify. -
How do we get privileges on schema CRM_FUSION_SOAINFRA?Summary: To come up with a custom report using BPM tables in CRM Cloud, we need privileges on schema CRM_FUSION_SOAINFRA or let us know the tables that store the details…
-
Analytics drill is not working on oracle CX Sales mobile AppSummary: I have created an analysis for mobile app, its working fine but when i tap on mobile for drill. It automatically navigates to following URL. but you see 'https/…
-
Subject Area for Resource and its Resource Org and RoleSummary: Report that shows list of Resources and their assigned Resource Role and Organization Content (required): Which subject area can I use to create an analysis tha…
-
How does the currency conversion for currency type field work? for Sales application.We're running an analysis in our BI catalog on a custom object in our staging environment. The analysis shows a custom field: Amount, field type: currency - the field is…