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
-
Exported Excel from Data Model Reports has names repeating twice in its File NameHi Team, We have created few reports using the data model in the CX Cloud. the reports are running as expected. But whenever we export the file as excel from the reports… -
Get Data from OTBI to PowerBIIs there a way to get data from OTBI to integrate to PowerBI?
-
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…
-
Multi Select field in UI returning Lookup Code in OTBISummary: We have this field in Sales UI having an FCL multi select in Division custom field. We have tried to add DESCRIPTOR_IDOF in this field however it is showing bla…
-
Freezing of Headers in a Pivot TableSummary: We have this analysis showing multiple records. Is there a way to freeze the pivot table header view in this dashboard? We have checked Oracle documentations an…
-
BICC View Object encountering errors on extract.Summary: We would like to seek assistance on this Issue. BICC Extract is failing and upon investigation, removing the Role Code column in View Object ResourcePartnerPVO …
-
How to schedule a BI Weekly run of scheduled reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
DCL on OOTB Object doesn't show in OOTB subject areaSummary: Hi, I create a custom DCL on Activity Object. When I check the standard subject area (CRM - CRM Activity Real Time), I don't see this DCL in Activity Extension … -
CX SaIes CDM: Is it possible to create a custom table in backendSummary: We have a requirement in CDM to create a custom table in ERP backend in order to maintain a relationship which currently does not exist in ERP. If this is possi…
-
How can I dynamically count a column in OTBI?Summary: Hi, In OTBI, how will I be able to get the count dynamically per year when the data type is string, and the sample value is "ABC 2024". Here is my theory but it…Ivony Ann Paula Salango 84 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle
-
How to get the login statistics for Mobile app logged-in UserSummary: We want to capture the Mobile User's logged-in Device name, IP address, Login Time, Logout time etc. In the current Subject area "Sales - CRM Resource System Us…
-
Analysis Close Ratio by Trailing 12 MonthsHello, We are trying to create a dashboard that will show the close ratio - win vs loss - of each month as a trailing 12 total. We are looking to have the months as the …
-
CDM: Unable to find hierarchy fields in Fusion back end tablesHello, In a requirement we are creating hierarchy in CDM through the import management. We are required to create a report based on the fields in the import Hierarchy an…
-
BICC can output be csv formatSummary: BICC can output be csv format Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Fusion …
-
Reports APII am looking to get Rest API to get folder contents of Report Path Mentioned in Report and Analytics Catalog. I have found the SOAP API but it is using Username and Pass…
-
How to fetch the Covered Levels of a Subscription using querySummary: How to fetch the Covered Levels of a Subscription using query Content (please ensure you mask any confidential information): How to fetch the Covered Levels of …
-
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job?
-
What is the REST API to upload a file to Content Server? What will be the end point url for this?Summary: What is the REST API to upload a file to Content Server? What will be the end point url for this? Content (please ensure you mask any confidential information):…
-
Create Analysis Report for Marketing Interactions with Account informationDear Community, we are trying to create an analysis report for Marketing Activities linked to various Contacts but it's hard to find a good subject area that works corre…
-
Cx - Dashboards are unable to be linked with or bring in.Summary: When a dashboard is filtered using Opportunity Number, automatically all the dashboards should get generated individually but not as a list form as shown in the…
-
Cx - Can we develop blocks using OTBISummary: Can we develop the report by the following design using OTBI. Content (please ensure you mask any confidential information): Version (include the version you ar…
-
Cx - Are predefined templates available for Sales in OTBI?Can we have predefined templates available for Sales in OTBI.
-
Can a Vanity URL be setup for the OTBI or BIP ReportsSummary: One of the requirements is to have a Vanity URL setup for accessing the OTBI/BIP reports from external source. Content (please ensure you mask any confidential …
-
My Team's Leads Tile - OOTB report is not showing proper data to the managers.Summary: My Team's Leads Tile - OOTB report is not showing proper data to the managers. Do we need to run any job? Path Sales/Embedded Content/ Sales Manager . Could you…NikhilSamudrala-Oracle 26 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle
-
Redwood - ReportsSummary: On using Digital Sales, How do the reports work? do we still have to access the old OTBI reports exposed on Analytics? I see Sales dashboards but this is under …
-
Data access issue with HZ_LOCATIONS tableSummary: I am trying to troubleshoot an issue with a custom BI Publisher query. The report works just fine for some users, but for other users it never finishes and time…
-
Which PVOs in the BICC console we need to pull to access the below tablesHi Team, Could you please help to provide, which PVOs in the BICC console we need to pull to access the below tables? HZ_ROLE_RESPONSIBILITY HR_OPERATING_UNITS FND_SETID…
-
Render OTBI dashboard using external APISummary: Hi , Would it be possible to build OTBI dashboard fetching data from external (Third-party) APIs ? I have evaluated the possibility of data sources in Data mode…
-
Creating a DIFF Attribute in BI Publisher Analysis ReportSummary: Creating a DIFF attribute in BI Publisher analysis that provides an "aging count" of two date attributes from two separate subject areas. The aging count is bla…
-
ParameterNameValues in runReport() Method doesn't workHello everyone. I have a problem with the runReport() method, when I enter values in the section, it correctly returns a base64 but when I decode it, it only shows me…