Reporting and Analytics
Discussion List
-
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 23 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 108 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 162 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 22 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
-
Is CREATOR_PARTY_ID of ZMM_NOTES refers to Resource PartyId?Summary: I am loading the Account Note from one POD to another POD with following attributes. "CURRENCY_CODE,SOURCEOBJECTID,NOTETYPECODE,VISIBILITYCODE,NOTETITLE,CREATOR…
-
How to access Party Source System Reference for Contact object using Groovy ScriptSummary: I need to retrieve the "Party Source System Reference" field from the "Contacts" standard object using a groovy script. This field is not visible in BI and also…
-
How to increase resulted row data limit in BIP data modelSummary: We have created a custom BIP data model and when we are trying to view data it is showing "ORA-01795: maximum number of expressions in a list is 1000" Content (…
-
Can we open a Quote Screen from CX DashboardSummary: We build a dashboard for quotes using standard subject area in analytics , there we have a information of Opportunity and Quotes. If we want to navigate to Quot…
-
How to Invoke http Request In reportSummary: HI, I am try to use in Invoke http Request in report but i am getting error Soap invocation failure. HTTP error code: '
-
Error with dashboard linked to a infoletSummary: Hello, I have 3 infolets in the initial page and all are linked to a dashboard created at BI. When i put in page compose the path to the dashboard, the preview … -
How to call web service option in BI report.Summary: We have API end points & we need to add in Action Link in BI report in Invoke Web service Option. Please let me know how to make use this option Content (requir…
-
limit prompt values based on the analysis resultSummary: Is there a way to limit my prompt values based on the analysis result Content (required): Ex - for the Status prompt I don't want to see retired as a value, as …
-
Oracle CX Release 12 OTBI Database Mapping with ViewObjectsSummary Supporting report creation in the new CX Release 12 we are making the mappings of Sales, Marketing and Service OTBI subject areas and columns to database tables …