Reporting and Analytics
Discussion List
-
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 63 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 31 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 81 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 21 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 212 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 351 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…
-
How to get number of records created (SFA/CPQ) in realtime without impact performance?Summary: We need to know how we can get the number of records created in the last 5 minutes for the objects Service Request, Quotes and Orders. Content: This information… -
Facing issue with FTP Server setup in OBIEEHi All, We are setting up the FTP server in OBIEE to burst the BIP report output to FTP server. But the connection is failing after passing the Server, Host, Port, Secur…Ashok Ganesh-Oracle 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Sales
-
List all opportunities via APISummary: List all opportunities created using API Content (required): De momento necesitamos hacer una consulta de todas las oportunidades a través de API, en la documen…
-
Defaulting the dashboard filterSummary: We have a dashboard which includes prompt as well, which is built based on custom subject areas with lead , opportunity , activity and custom object data. we de…
-
How to setup different schedules on the same BICC datastoreIn BICC (OSC Sales Cloud) , I want to have two extracts of a datastore e.g. CrmAnalyticsAM.OpportunityAM.Revenue going to two destinations for different reporting use ca…
-
Opening the Text field link in a new tab obieeSummary: In OBIEE , I have a text field and which contains a URL. I made it to clickable from data format. When we choose the data format as html hypertext it started wo…
-
Are Custom Field Values from Custom Objects stored in PageFlowScope Variable? How can I access them?Summary: Getting Custom Objects Custom Fields Values from PageFlowScope Variable Content (required): Hello, I added an OTBI analysis to a custom object details page (Ana… -
Partner Table (ZPM_PARTNER_PROFILES ) is not return Primary contact detailsSummary: I am using ZPM_PARTNER_PROFILES table to fetch partner primary contact detail. But it is not getting any field to check partner primary contact detail. select *…
-
Equivalent Oracle Cloud table/view for the EBS entity - Contracts ModuleSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS entities mentioned below?Krutika Narayankar 21 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Enterprise Contracts