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
-
Activities and Related Activities ReportingContent In 21C, OTBI CX delivered a new subject area "CRM - CRM Activities with Related Activities". This subject area allows users to report on all activities with rela… -
Data Lineage document or BICCC PVO Details for 21B Sales subject Area - OTBIContent Hi Team, We need some data exports from oracle subscription management cloud application 21B. As we see there is additional feature available as part of 20B, whe… -
CSV extract is showing date/time in UTC timeContent When the report is extracted to CSV format the time is shown in UTC time, is there a way we can convert the time to show Sydney time considering the daylight sav… -
Error in publishing custom subject areaContent Hi, Found the error as attached in the screenshot Thanks -
Weird Subject Area names appearing when using saved column featureContent When we are trying to use ‘saved columns’ we are observing weird subject area name folders in the catalog navigation. We are not able to identify in which folder…
-
"Sales - CRM Sales Activity"."Business Unit"."Business Unit Name" is nullSummary I am trying to do an Activities report but the Business Unit Name field is nullContent I am using the subject area "CRM - CRM Activity Real Time" but when I adde… -
Need out of box reports for Oracle recruitment(ORC)Summary Need out of box reports for Oracle recruitment(ORC)Content Hi Team, We are looking for Oracle recruitment(ORC) out of box reports. This is the new module for us …
-
Split BIP Report output (CSV) in to multiple filesSummary Split BIP Report output (CSV) in to multiple filesContent Hi Experts, We have a BIP Report that outputs a csv file and produces millions of rows. The output file…
-
Filter - AnalysisSummary Filter - Leads created in the current weekContent Hi all, Do you know how to add a filter to an analysis (OTBI) so that it only brings the Leads created in the c… -
Amount field in Sales - CRM Opportunities and Products Real Time subject areaContent Hi team, I am using Sales - CRM Opportunities and Products Real Time subject area and I want to get the Amount value. In what subject area can I find it or what …
-
How to embed hyperlink from OTBI report - data column field into Apps Composer CRM custom formSummary I need the ability to drill into some Custom App Composer CRM data from a Dashboard Report on that data set. Non Standard Oracle Cloud App FormsContent I need th…
-
Pulling reports dataContent Hi, Is there ways to pull data from BI report say Opportunity Report using any API and push to staging tables from the external application. I have requirement t…
-
Combine reporting on Incentive Compensation attainment, participant details, and plan assignmentsSummary Looking for help with ideal subject areas and tips/tricks to report on three areas simultaneously: achievement, participant details, and plan assignments.Content… -
Knowledge article view fact returning 0Content We have an OTBI report listing all of our knowledge articles and have included the # of article views fact from the Knowledge Management - Article Summary Histor…
-
Brokerage Security within ICMSummary Brokerage Security within ICMContent How can you apply security within ICM? We have a requirement for only certain people to see certain brokers, can you do that… -
Send report to FTP serverContent Can we automate BI report to be sent to FTP server? Using Oracle Sales cloud version 21A Use case: We need few reports created using analysis or BI publisher to …
-
Set Default Selection of Owner Prompt to Currently Logged-in UserSummary Set Default Selection of Owner Prompt to Currently Logged-in UserContent Hi, I want the currently logged-in user to be the default selection of Owner prompt I cr… -
Sales Rep Activity ReportContent Hi, Is there any seeded OTBI report to view activities performed by Sales Rep with the date range. Activities includes accounts, appointment, task, leads, opport…
-
Subject AreaContent Hi, I have created 2 custom fields in oppty. 1. Is there a way to get the custom fields in Standard Subject Area? 2. Is there a way to clone the Standard Subject…Mohana Gopal S-Oracle 32 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle -
Alternative Solution To Using User Organization Hierarchy Based LoginSummary Alternative Solution To Using User Organization Hierarchy Based LoginContent Hi, We're having issues with using User Organization Hierarchy Based Login filter in…
-
OTBI Analysis - collapsible/expandable rowsContent Hello Team, I have requirement to prepare analysis with collapsible/expandable rows (similar like in hierarchical column). Bisuness case i have Owner------------…
-
Configure option in Workspace Infolet MissingContent Hi, In DEV environment (Orange) I was able to see the Configure option, but in Production (Blue) there was no Configure option available for the infolets. How do…
-
Need Help in Logical SQL for recruiting sysdate time conditionSummary Need Help in Logical SQL for recruiting sysdate time conditionContent Hi Team, I am trying to add a new filter condition like "and TRUNC("Recruiting - Recruiting…
-
Cannot Access Workspace InfoletsSummary Cannot Access Workspace InfoletsContent Hi, I've already set the profile option ZCA_ENABLE_ADAPTIVE_INFOLETS to Yes and added ORA_ZBS_SALES_ADMINISTRATOR_JOB to …
-
how to define a prompt to get Sales Manager and his reportee manager and reportee salespersonContent Hi All, We have a scenario, where in one sales manager has salespersons and other sales managers as reportees. Now, we are trying to build a dashboard prompt, wh…
-
OOTB Sales and Service Report ListSummary a list of all OOTB OTBI reports for CX sales and B2B Service cloudContent Hi, Can anyone help me out with a list of all Out of the Box Oracle CX Sales and B2B se…
-
"Only quota contributing revenue is considered" - What does this mean?Summary "Only quota contributing revenue is considered" - What does this mean?Content Hi, I'm looking at the documentation of Pipeline Detail Facts and all metrics and m…
-
How to enable Enterprise Calendar and Custom Calendar at PromptsSummary How to enable Enterprise Calendar and Custom Calendar at PromptsContent We have use case where in our customer has "Enterprise Calendar" defined (01-Jan to 31-De…
-
Contract Start Date and End DateSummary Contract Start Date and End DateContent Hi, I am building analysis report on Enterprise Contract please help me to locate Contract Start Date and Contract End Da…
-
Get latest notes in OpportunityContent Hi, I am using Sales - CRM Opportunities and Products and Sales - CRM Opportunity Notes and able to bring the notes created against the Opportunity. Suppose if I…