To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting & Analytics for Sales
Discussion List
-
I have created an OTBI report in which customer name is promptSummary: I have created an OTBI report in which customer name is prompt but the LOV contains all the parties instead of customer only How to restrict that LOV? Content (… -
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…
-
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…
-
Not able to add Metric card to sales dashboardSummary: While personalizing the Redwood Sales Dashboard, there is option to add KPI metric card when trying to add the metric the metric card is not getting added. Afte…
-
User Login ReportHi, we have received a request from the customer who needs a report listing all users who have not accessed Oracle Fusion for more than one month. We have written the fo…
-
August 6th webinar: Build Exceptional AI-Driven Customer ExperiencesCX expectations are higher than ever, with 24/7, first-time resolutions now the baseline. But with digital engagement outpacing human capacity, how can you keep up? Orac… -
We are unable to restrict the Users Bi report access for Fixed AssetsSo the requirement we are looking at is to extract the FA_books related information on base of Security roles for an user at BU or org . We are unable to restrict the Us…
-
"Redwood Reports Showing Partial Quota Data – Need Full Quarterly & Annual View"We have uploaded the Quota data for all four quarters in Redwood. However, when we try to fetch the reports, we are only able to access the data for the current quarter …
-
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…
-
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…
-
Customer wants to have email and in-app notifications for Sales reports to be sent to team membersCustomer wants to have email and in-app notifications for Sales reports to be sent to team members. How can this be achieved?
-
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 '…
-
Query for Account Profile DataNeed support to get the information in the screenshoot… CRM Account Profile. thanks
-
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…
-
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…
-
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…
-
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…
-
How to optimize SQL query on MOO_OPTYSummary: A BI Report must extract daily a specific set of specific opportunities Content (please ensure you mask any confidential information): We want to query on MOO_O…
-
Specific information regarding the UCM (Universal Content Management) folderSummary: Requesting for some specific information regarding the UCM (Universal Content Management) folder that we are currently working with. Accessing View Object Files…
-
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…
-
Is there a functionality called 'Active Primary Key' that retrieves a list of primary keys in a PVO?Summary: Is there a functionality called 'Active Primary Key' that retrieves a list of all primary keys in a PVO? we will be using this for performing soft deletes in ou…
-
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? -
BI Report: multiple filters return no results but when filters used individually returns recordsSummary: I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportuniti…
-
Alignment issue in Absence Approval Seeded notificationSummary: Let me explain theissue clearly how the notification is been triggered in Responsive UI andRedwood in over mail and in bell notification.Responsive UI level the… -
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…
-
OTBI Analytics >CX sales FusionSummary: In OTBI Analytics > Administation > Manage Priviliges If there is a Change in Sections like Catalog, Access , in the Manage Priviliges set to certain roles whic… -
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t… -
How can I duplicate a standard panelSummary: In the account object, I need to duplicate with the same structure and appearance the Opportunity Panel. How can I make a copy or how can I build a structure an…
-
BICC Reset to Full Extract FunctionalitySummary: If we perform a Reset to Full Extract, does this mean our incremental data replication job will perform a full data load by default when we reset to a full extr…