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 1 view 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 32 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 41 views 3 comments 0 points Most recent by Narula Shray Reporting & Analytics for Sales
-
Dashboard Filter in IST but results in ESTI have a dashboard filter that is run off IST time. Is there a way to modify the time zone in the dashboard filter? For Example: When entering a date range of 5/29/23 to…1Name1 1 view 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle 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 191 views 1 comment 0 points Most recent by Ian Rumble Reporting & Analytics for Sales -
Enterprise Seniority Date is blank for Global Transfer Employee after Upgrade Seniority Date to V3Summary: We have upgrade Seniority Date functionality to V3. After upgrade, OTBI Analysis report is not pulling Enterprise Seniority Date for Global Transfer employees W…
-
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 31 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 43 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 41 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 101 views 8 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
User Adoption Insights - Preconfigured Sample Reports in OTBISummary Sample reports for user adoption insights in OTBI are available with attached .catalog fileContent Oracle CX Sales has received requests to provide pre-configure…Greg Rice-Oracle 488 views 9 comments 8 points Most recent by Priscila Terazawa - Support-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 31 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 51 views 0 comments 3 points Started by Noelle Bartlam-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 21 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 41 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 102 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 61 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 51 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 74 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 42 views 1 comment 0 points Most recent by Dragos Deak-Support-Oracle Reporting & Analytics for Sales