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
-
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject… -
How to enable audit log in report and analytics.Summary: Is there any possibility to add audit log in report and analytics? For example: In objects(like Lead ,Opportunity ) there is a field which shows the value of la… -
Table Industries CRM SALESCordial greetings Please help me to identify the table that brings the Industries field data from the account in oracle cloud sales. Thank you -
How to highlight the records with specific colors based on date conditions in OTBI reports.We need to highlight records in OTBI reports based on the following date conditions: Highlight records in green where the create date is earlier than the last update dat…
-
Unable to find industry in Account tablesHello, On Accounts we are using industry DCL field on accounts. Business is using the custom defined Classification Category for this industry field. I was able to see t…
-
Handling Double Quotes in BICC Data ExportsSummary: Handling Double Quotes in BICC Data Exports Content (please ensure you mask any confidential information): I am encountering an issue with my BICC export proces…
-
Changes to DM is not reflecting in FTP Schedule ReportSummary Changes to DM query is not reflecting in FTP scheduled reportContent We have scehdule FTP report based on data model. Recently we made changes to that data model…
-
To create a graph chart exactly shared in the screenshot using BIPOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Mastek Ltd Description (Required): Ca…
-
Service Usage Metrics Per User ReportSummary: Service Usage Metrics Per User Report Content (please ensure you mask any confidential information): Hi Could you help me to know if there is any report that pr… -
OTBI analysis for count of lead createdSummary: Hi, I want to create an analysis to show all the names of users in a branch and count of leads created by them. Could you please help me to create this analysis…Anjanah Ganapathy G S S 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle
-
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co… -
Query to get customer contacts by siteSummary: Query to get customer contacts by site Content (please ensure you mask any confidential information): Hi, I am trying to fetch AR Customer contact information w…
-
What is the Fusion documentation for TCA? Only finding EBSSummary: Looking for Fusion documentation on Trading Community and only finding references to EBS. Is there a delta between EBS and Fusion? Is it still referred to as TC…
-
Can't generate visualization The criteria used for the visualization doesn't return any data.Summary: I’m trying to configure the sales dashboard in Oracle Fusion CX Sales, but I keep encountering an error message stating that “no data is available.” Despite thi…
-
How to limit prompt values to values displayed on analysis - OTBISummary: I'm building an analysis using the "Incentive Compensation - Attainments Real Time" subject area. One of the prompts in the dashboard that includes this analysi…
-
PublicReportService - generateReport failedWe have a report in this path: /Custom/Customer Relationship Management/Data Warehouse/Res/Informes_Parametros/SpaceConfigurationDS_Analisis.xdo We reviewed the permissi…
-
Rel 13.20B User Adoption – Object Activity and Resource System UsageContent User Adoption metrics help CRM stakeholders continuously measure the success of their CRM implementation. Using these metrics, CRM business leaders can obtain cr…
-
Drill Down is possible in express reports in Redwood Sales?I am not able to see option to select drill down in express reports in redwood whereas option is available in Visualization Configuration.
-
Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…
-
Getting Sign In option for Power BI Dashboard URLs embedded on Oracle Sales Cloud even SSO setupdoneSummary: When we try to embed Power BI dashboard URL on oracle sales cloud it is asking for Sign In option instead of opening the links directly since SSO setup is estab…
-
Error when trying to add an analysis inside a datamodelI am trying to add an analysis inside a datamodel created through subject area, but when I click on view to see the information the application takes a long time and at …
-
Table used to store children custom objects!!Hi, We created Custom object "Proposal" and created child custom object from the parent object with name "Payment Plan" The parent custom object "Proposal" store its rec…
-
Date column in Excel File not showing recent recordsSummary: Why I was unable to see latest records in my excel output file. Content (please ensure you mask any confidential information): Version (include the version you …
-
AP Inquiry RoleI don't want to give ap manager role access to one of the user what privilege's I need to give to the user so that user can see the payables dashboard report
-
Is there a way to push report out of OTBI into a database?Is there a way to push a report out of OTBI on a weekly or daily basis that generates an excel file into a OneDrive folder?
-
Could BI Report Show Report Total Lines and Total Amounts InformationSummary: Based on audit requirements, user want BI report searching page could show total lines and total amount of exported report data. Is it possible for BI to realiz…
-
How to add analytic springboard On Home page?We would like to add the analytic springboard to the homepage. However, it currently appears on the right side of the page. Could you please move it to the bottom of the…
-
Table for main contact in CRMDear all, Please help, I need to identify the table that brings me the main contact of the CRM module in Oracle Fusion Cloud. Thank you.
-
BI Analysis Output Has Parameter and Line Counts InformationSummary: Based on audit requirement, user need Analysis report's output has following information: 1. View of the headers to see all the parameters selected for the repo…
-
Is it possible to have some documentation on the standard OTBI reports?Summary: Hello community, The client is starting to create reports, but wants to review the reports that the tool already has by default. Is there any documentation that…