OTBI
Discussion List
-
How can I create a custom job Role in BI Publisher?Summary: I can view the Roles and Permission under the Security Center using the /xmlpserver/. However, I cannot create a custom Role as there is no way for me to see th…Cristelle Rose Sampang 11 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to Version Invoice templatesSummary: We currently create Invoices by using an OTBI report to gather the data and put it into a RTF Template. However when you upload a new version of the template, t…
-
OTBI Union Report Data IssueSummary: I have created OTBI UNION Report with below subject areas and applied all mandatory filters but did not see any data in the report. 1. Subledger Accounting - Jo…FirozahamedSK 31 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Is there a way to automatically trigger a scheduled job if it encounters failure on scheduled run?Summary: We have one file that was not sent to SFTP location as there is a connection issue in the SFTP as there is an emergency change in SFTP. In Oracle BI Publisher, …Cristelle Rose Sampang 71 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales
-
How to create BI analysis for Sales Product and Product GroupsSummary: How to create BI analysis for Sales Product and Product Groups Content (required): Hi, We want to create a couple of analysis to show a list of product groups a…Max Prestes 31 views 2 comments 0 points Most recent by jiweiss-Oracle Reporting & Analytics for Sales -
How to Set Date Format to Dashboard Prompt?Summary: How to Set Date Format to Dashboard Prompt? Content (required): How to Set Date Format to Dashboard Prompt? Does the Date Format shown by default is based on Us…Shivakumar Ayyanagowdar-Oracle 271 views 1 comment 0 points Most recent by Ian Rumble Reporting & Analytics for Sales -
Where to find Deal Size (Sales Lead) in Subject Area of OTBISummary: I'm trying to find the Deal Size field of Sales Lead object in any Subject Area in OTBI for a report but I can't find it. Content (required): I'm trying to find…edpalomo 52 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Cannot find Operations for Work Order TransactionsSummary: In querying the data found in WIE_OPERATION_TRANSACTIONS, I'm noticing that there are WO_OPERATION_ID values that cannot be found in WIE_WO_OPERATIONS_TL. It is…
-
Needs feasible outputs from BICCSummary: We have a requirement where we are configuring object loads from BICC and consuming it at a third party system. The BICC output files are currently outputted as…Rajita Ganti 84 views 3 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting & Analytics for Sales
-
How can I create a historical overview from a flexfield CHARACTER Data type?I have data information stored in a CHARACTER data type flexfield. To expose it in an analysis in Oracle Business Intelligence (OITBI), I navigate to the 'Incentive Comp…Priscila Banqueri 11 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to filter for Finalized territories in Sales - CRM Territory Resource subject area?Summary: How to filter for Finalized territories in Sales - CRM Territory Resource subject area analysis? Content (required): I'm using Sales - CRM Territory Resource su…Chin Chi-Oracle 51 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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…SERGIO BARRETO 141 views 8 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
How to align 63 Report Fields in RTF Report TemplateSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 101 views 7 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
SQL Query for Territory BIP ReportSummary: Actually I trying to create a Territory Report includes the Territory Name,Parent Territory,Status , Dimension and Converge details . Can somebody helps with th…Tinu 93 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Is there any subject area to get the Module to which each object belongs toSummary: What is the equivalent Subject Area for this table - adf_extensible_table_usage Content (required): 'adf_extensible_table_usage' has a column - 'Application_nam…Venkateswari 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to Generate a BIP Report in xlsx Format with 90+ Report FieldsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 71 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Mask/Hide OTBI File Path Location on Browser Address BarSummary: Trying to find a way to hide/mask the OTBI file path location shown on browser address bar to minimize unexpected attack from anyone. Content (required): We jus…Karen Benita 51 views 3 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Sales
-
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Balaji Midhun Kumar Sanagapalli-146903 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Restricted Access to Reports and AnalyticsSummary: Hello All, I have a requirement where users should be able to access all reports and analytics in OTBI but should not be able to access any objects in Fusion Ho…Manju_Bujendra 111 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to build a report to show as when a specific report has been run and at which time?**This post was created as part of a How-To Service Request (SR) Summary: I need to report to show as when a specific report has been run and at which time. Version (inc…Priscila Terazawa - Support-Oracle 51 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to build an Analysis using Subject Area with Subscription Product Associated Asset fields?Hello! I was not able to find a Subject Area that brought Associated Assets fields. I also tried to create a custom Subject Area to have those fields, but the only child…Bruno Matheus 61 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Subscription Management
-
How do we obtain a report of the notes associated with a lead?Summary: We need to obtain a report to obtain the relationship of leads with the notes that have been created. Content (required): We tried to build this report across s…SERGIO BARRETO 61 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to build a bar graph report, grouping by color ?**This post was created as part of a How to Service Request (SR) Summary: How to build a bar graph report, grouping by color ?Priscila Terazawa - Support-Oracle 51 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to add lead notes to a reportSummary: We need to add in a report through of subject areas the notes that are recorded on the leads Content (required): How can we add the notes that are related to th…SERGIO BARRETO 41 views 2 comments 2 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales
-
Subject Area - How to add the attachments field in a reportSummary: How to add the attchament field in a report made through the subject area "Sales - CRM pipeline" Content (required): We want to add the attachment field in a re…SERGIO BARRETO 136 views 2 comments 0 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales
-
Subject Area - OTBI Performance Real Time**This post was created as part of a How to Service Request (SR) Release: 23A Summary: Can you provide any documentation that contains information about all the fields i…Dragos Deak-Support-Oracle 41 views 1 comment 0 points Most recent by Dragos Deak-Support-Oracle Reporting & Analytics for Sales
-
Why is my new custom field not showing in BI?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: I have created a new field 'NewField_c' in the 'Object_c' custom o…Ionel Spaloghe-Support-Oracle 71 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
Create Custom Subject AreaHi, Please help with the steps how to create custom subject area from the custom data model ? ThanksMohammed Rafi 61 views 3 comments 2 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 daysSummary: I am trying to generate reports on Opportunities Created or modified in last 7 days - or "Last Week". Also, I want to do the same with Contacts and Accounts cre…
-
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 31 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales