BI Publisher
Discussion List
-
RTF TemplatesSummary: Hi, Can anyone please provide documents or sample RTF templates for learning or exploring purpose. Thanks. Content (required): Version (include the version you …Padamatinti Varsha 92 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct…
-
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 43 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Outer join queriesSummary Outer join within same subject areaContent Hi, I am using "Marketing - CRM Leads" SA to create report on leads. this return only those customer who have leads th…azodpe 28 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Embed BI Publisher Report on Account PageSummary We need to embed a custom BIP Report on Account Page which gives info to users on unpaid customer invoices. I have created a report based on AccountID as paramet…Umang Gupta 27 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 24 views 0 comments 3 points Most recent by Pavel Buynitsky-Oracle Reporting & Analytics for Sales
-
SQL statements for DatastoresSummary What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?Content Hello, we are looking for the …User_0HYL0 47 views 2 comments 5 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales
-
What roles are needed to access the BI Data modelContent Hi, I created a custom role and assigned the roles: BI Administrator Role BI Applications Administrator Duty BI Applications Functional Developer Duty BI Publish…Valdir Dutra 67 views 3 comments 0 points Most recent by Valdir Dutra Reporting & Analytics for Sales -
"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…Edgar93 45 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
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 …Harish Kumar Kovi 67 views 1 comment 3 points Most recent by Craig Hennessy Reporting & Analytics for Sales
-
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…User_2025-01-30-01-01-15-242 34 views 2 comments 0 points Most recent by User_2025-01-30-01-01-15-242 Reporting & Analytics for Sales -
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…User_2025-07-18-06-07-44-367 47 views 3 comments 0 points Most recent by User_2025-07-18-06-07-44-367 Reporting & Analytics for Sales
-
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…User_2025-07-18-06-07-44-367 72 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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…User_2025-07-18-06-07-44-367 39 views 2 comments 0 points Most recent by User_2025-07-18-06-07-44-367 Reporting & Analytics for Sales
-
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…User_2025-02-01-03-43-13-079 39 views 1 comment 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting & Analytics for Sales
-
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 …User_2025-07-18-06-07-44-367 47 views 4 comments 0 points Most recent by User_2025-07-18-06-07-44-367 Reporting & Analytics for Sales
-
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…Srinivas Soora 62 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
"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…User_2025-07-18-06-07-44-367 27 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
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…Srinivas Soora 30 views 4 comments 1 point Most recent by Rupak Chowdhury-Oracle Reporting & Analytics for Sales
-
Embedding a BIP reportSummary Embedding a BIP report in the tool with all the functionalityContent Hello, Does anybody know... When you embed a BIP report into the Operational tool, does it c…User_2025-01-22-20-09-02-352 86 views 7 comments 2 points Most recent by Mohana Gopal S-Oracle Reporting & Analytics for Sales
-
Documentation for Sales - CRM Pipeline Facts 11.1.1.9Summary Documentation for Sales - CRM Pipeline Facts 11.1.1.9Content Hi, Is there a documentation for Oracle Business Intelligence 11.1.1.9 subject area metric measures?…User_2025-07-18-06-07-44-367 49 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Merge Values Created By Duplicate Sales Stage NameSummary Merge Values Created By Duplicate Sales Stage NameContent Hi, I created an analysis in OTBI and the Sales Stage Name is creating two sets of # of Opportunity Val…User_2025-07-18-06-07-44-367 35 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to extract Report from BI publisher Using BICC as a single CSV/zipSummary Not able to extract as a single CSV from a reports of multiple view objectsContent Hi Team, I have a report based on Lead, in which we have customer details, pro…
-
Custom Account Hierarchy ReportContent How to built the custom Hierarchy report through OBIEE, Please let me know any sample sql query is available. Structure : ___________Corporate Account__________ …Deepak Prakash 79 views 2 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Is it possible to customize the output csv file name after job in BICCSummary How to customize the zip file and CSV file after In BICC extract jobContent Hi All, Im exporting fusion application data to OCI using BICC, the file is generatin…Sudheer Vadla 134 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Is there any rest api to run the report and download outputSummary Rest api for BI analysisContent Hi, Is there any rest api availbe to run and BI analysis and download the output. eg: Lead analyis Regards, Sudheer.
-
Customer Details with SiteSummary Looking for Report for Customer Details with Site addresssContent Is there any custom or standard report for Customer details with Site addresses.Bilalemail 29 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Extend OTBI Agent Extract Maximum Rows for Excel FormatSummary Extend OTBI Agent Extract Maximum Rows for Excel FormatContent We recently implemented OTBI Agents that delivers extracts from an analysis that captures data wit…User_2025-02-07-20-17-33-726 237 views 7 comments 1 point Most recent by User_2025-02-07-20-17-33-726 Reporting & Analytics for Sales
-
OTBI - Table or view does not exist at OCI CallSummary Unable to generate risk management report from standard subject areaContent We are trying to generate an analysis report for "Risk Management Cloud - Compliance …Yasir Humayun 38 views 3 comments 1 point Most recent by Yasir Humayun Reporting & Analytics for Sales
-
How to apply permission to custom folderSummary To remove delete privilege from custom folderContent Hi Experts, We want to remove delete privilege from one of the custom folders. Which is nothing but the fold…User_2025-02-06-08-56-18-108 46 views 6 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales