Category 192
Discussion List
-
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 8 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
BIP Bursting to object StorageSummary: We have a requirement where we want to schedule BIP report output and store it to object storage . Is it possible burst BIP report to object storage. Also,We do…Mandar -Oracle 579 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Retrieve ParentAccountPartyId from Oracle CX tablesHi, I need a query that extracts data from hz_organization_profiles, and among the fields I need is ParentAccountPartyId. This field is available in the endpoint: /crmRe…
-
セールスクラウドでBIエージェントを実行できる権限を付与したいセールスクラウドでBIエージェントを実行できる権限を付与したいです。 BIの編集はできないようにしてほしいです。 どうやって制御したらいいですか？M.AZUMA 14 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Which Data Store should be used to get Lookup information from BICC?Summary: Hi, We're using BICC to export data from Sales, however the lookup columns doesn't show the meaning, only the the codes. For example, "BR" instead of "Brazil" o…Max Prestes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
BIのサブジェクトエリアSales CRM LeadResourceでリードのチームメンバーを取得したいサブジェクトエリアSales CRM LeadResourceでリードのチームメンバー全員を取得したいです。 方法を教えてください。M.AZUMA 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
OIC Report Creation Date of plan component assignment to participantSummary: Hi, The business requires a standard report related to OIC Plan Components. The requirement is as follows: The report should capture any new creation of a plan …
-
Service Usage Metrics Report for EPMSummary: One of our customers has requested the Service Usage Metrics Report for EPM (Hosted Named User, Hosted Employee, Records, and Hosted Employee details) from OCI.…Swathi Gutta-Oracle 31 views 2 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
User Access Report (v2) API has only POST command available currentlySummary: One of our clients has requested the GET command for the user access report. Could you please let us know the expected timeline for its availability? Content (p…Swathi Gutta-Oracle 31 views 2 comments 4 points Most recent by Aishwarya Waghmale-Oracle Reporting & Analytics for Sales
-
BICC Manage Jobs to DatabricksSummary: Since we will be using managed jobs, and scheduling each job in Databricks by its job ID to invoke, upload, or export files from UCM, should we anticipate any i…Carlo Orolfo 21 views 2 comments 0 points Most recent by Carlo Orolfo Reporting & Analytics for Sales
-
SQL error - discounted price | BI publisher multiplication issue.I'm in the process of generating the cost price list, but I'm encountering a runtime error. The error message doesn't provide specific details, so the root cause is uncl…
-
Looking for a way to limit/disable the use of the refresh button on the BIPublisher rep executionMy client has a report that runs based on a date range. However, after running the report, when they immediately click the Refresh button, it triggers the data extractio…Oscar Chahestian-Oracle 1 view 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting & Analytics for Sales
-
Hero Templates & 25B Roadmap – Setup Guide for Sales DashboardsHi @Piyush Jain I saw mention of Hero Templates being enabled as part of the 25B update, specifically in relation to the Sales Dashboard. Could someone from the Oracle t…Robert Lewis 31 views 3 comments 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Table name to get packag unit details for a shipment/deliveryDelivery line is performed with a Pack. I need to retrieve the package unit details to display on my Custom BI report. Can you please help me obtain the Package Unit Det…
-
Is there a button we need to enable for Custom View ObjectsSummary: Can we confirm if there is a button or something we need to enable for Custom View Objects to be automatically added on the BICC Data Store list? Content (pleas…Carlo Orolfo 13 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Unable to Use Dynamic URL with EL Bindings in Action and Links (Application Composer)We are trying to implement a dynamic BI Publisher report URL in a Sales Opportunity page. The goal is to pass parameters dynamically using EL expressions (e.g., #{bindin…KirolosMagdy 22 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
What is equivalent table to xla_trial_balances in Oracle Fusion?Summary: Hi All, I am working on migartion a RDF report from EBS to fusion. Existing EBS report is using table xla_trial_balances which or equivalent table i am not able…hiteshsaroha 11 views 2 comments 0 points Most recent by hiteshsaroha Reporting and Analytics for ERP
-
Filter contact's account's address in Contact object - redwood UISummary: Need to see a list of the Contact's Account's addresses. Content (please ensure you mask any confidential information): Suppose I am creating a new Contact or e…
-
Searching on HZ_ORGANIZATION_PROFILES_Hi all we need to create a report, to run weekly, that searches for Accounts/Organizations on which a specific field changed in the last week. Any idea how to avoid a FU…Luca Angheben 21 views 3 comments 0 points Most recent by HD - Oracle Fusion ERP-Oracle Reporting & Analytics for Sales
-
BIP delivery destination to MS Sharepoint or OneDriveSummary: Hi, If I need to deliver the report directly to MS Sharepoint or OneDrive, what delivery channel should I use? For example, HTTP, WebDAV? Thanks, Adam Content (… -
How to check if there is a scheduled refresh on PVO in BICC?Summary: We need to check if there is a scheduled job that runs for a PVO to Full Refresh. Content (please ensure you mask any confidential information): Version (includ…Carlo Orolfo 13 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to enable Support Incremental Checkbox on a PVO on BICCSummary: How to enable Support Incremental Checkbox on a PVO on BICC? We currently do not have the option to enable this. Content (please ensure you mask any confidentia…Carlo Orolfo 16 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Query for Account Profile DataNeed support to get the information in the screenshoot… CRM Account Profile. thanksMMendoza 11 views 3 comments 0 points Most recent by Madhuri Cheruku-Support-Oracle Reporting & Analytics for Sales
-
Email option in DashboardsHi All, We have developed couple of dashboards and we have scenario to share it across with some users through emails on demand. We are trying to look for enabling the '…Vigneshwar 11 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
R13.x CX BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Develo…Rashmi M-Oracle 8.4K views 10 comments 15 points Most recent by Max Prestes Reporting & Analytics for Sales
-
Need BI Report to get total Payout amounts per plan components in SalesSummary: Hi Experts, We are looking for BI Report to get total Payout amounts per plan components, the sum needs to group by based on Plan Name , Component Name, Perform…Rama123-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
What is the Subject Area to retrieve Invoice DetailsSummary: We are currently retrieving invoice details using a DM (Data Model) report with the SQL query provided below. Now, we want to create an Analytics Report using a…Anusha716 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Query to get Sales order line with Kit item like 1.1..2Summary: Please help me determine if a Sales order line is a Kit item and the line number should display as 1.1.2, 1.1.3, etc. Content (please ensure you mask any confid…
-
Is there a way to extract Active Primary Key for View Objects in BICC by batch?Summary: We would like to confirm if there is a feasible way to extract all Active Primary Key for every available View Object in the Data Store List by batch? Currently…Carlo Orolfo 12 views 2 comments 0 points Most recent by Carlo Orolfo Reporting & Analytics for Sales
-
OOTB Subject Area and Custom Subject Area crossedIf OOTB Subject Area and Custom Subject Area have crossed, Is there any support to see if this can be done?M.AZUMA 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales