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
-
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… -
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…
-
What would be the reason of showing the Enterprise Quarter as null in Analytics- Sales CRM PipelineSummary: Eventhough the Accounting calendar is setup with proper periods & quarters; Calendar profile option also set to the configured. The opportunity records are show… -
How can I remove the currency symbol from the metric card in the Sales DashboardIn Oracle Fusion Sales Cloud, the My Pipeline TCV ($Mn) metric card is a custom or duplicated version of the standard Pipeline metric card, showcasing the total primary …
-
PII data BICCSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Create BI with CustomSubject area crossed out.The subject area is crossed out to create a BI. One has the activity as the primary subject and the second has theOpportunity as the primary subject. When I add a “Resou…
-
Filtering NULL values in a dashboard promptSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use… -
Personalized Reports Not Retained for Some Users in Oracle Fusion's Sales DashboardSummary: Hi Community, We’re encountering an issue in the Sales Dashboard of Oracle Fusion Sales Cloud. Users with certain roles are able to use the Edit option on Sales…
-
Subject Area to Database Lineage MappingSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Enable Territory Filter for Information Displayed in the Sales DashboardSummary: Present State OTBI prompts : use Territory prompts based on "Sales - CRM Opportunity Territory"."Territory Hierarchy" Subject Area For Future State Prompts, OOT…
-
sales dashboard metric currency is always in USD.Summary: We have enabled the Sales Dashboard Metrics (For eg: Pipeline and Team pipeline). This calculates the Sum of all Revenue Amount of the opportunities. This value…
-
Translations of Badge Item in Redwood Sales DashboardSummary: Please find attached image, i need to translate the badge item to French language. I have added in translations bundle, just needed to make sure whether it is c…
-
How to Increase CSV Export Limit from AnalyticsHi, we have created some analyses and the related dashboards. We then made the analytics available in the Analytics section (the dashboards are very simple—for example, …
-
In partners, need the corresponding backend table and column name for Partner's Geographies Served.In partners, there is a column titled 'Partner's Geographies Served.' We need the corresponding backend table and column name. In BIA, we are currently able to retrieve …
-
May 21 upcoming webinar: The Future of Customer Experience: Product Strategy Statement of DirectionWe believe 2025 is a line in the sand for customer experience. Envision a world where: Customer experience transcends front (sales, service, marketing) and back-office d… -
Using Filters for Items with Rank Functions in BIThe Rank function is used to get the order of the employee numbers and divide the groups by 10's. Can I use this group for filters and prompts? Please let me know how to…
-
Query to get ResourceOrganizationName of the userHi All, I am trying to extract resources/users with specific ResourceOrganizationName. I want to extract the ResourcePartyNumber and ResourceOrganizationName. Can you pl…
-
Can I use responsive design when displaying BI?Can I use responsive design when displaying BI?
-
XMLPSERVERIn the XMLPServer section, can OTBI reports be seen, or are only BI reports visible?
-
In OTBI Analytics - How to export more than 75,000 records in Excel/CSV formatSummary: Currently in Oracle Transactional Business Intelligence, there is an export limit of 75,000 records in Excel format on a custom subject area we have created. Ar…