Category 192-2
Discussion List
-
how to add a link to BIP report in the DOR work flow approvalsSummary: Currently I am using DOR in employee self service to request for employee salary certificate. SO when the approvals flow through different people , how to attac… -
CX - Is venn diagram possible in OTBI?Total value of opportunities and Total number of opportunities should be displayed in the diagram along with the status. Is following design possible in OTBI?Nalsoft Pvt Ltd 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
OTBI how to include manager department hierarchy in an analysisI have a need to include the Managers department hierarchy in an analysis. The managers department hierarchy does not appear to be a set of standard fields in any of the…Sharon Ferguson 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to create a text to column like Excel column in OTBI based on a Listagg column?Summary: I need to see data on one row. I've managed to do this using Listagg. However, now they are asking if that it not be concatenated and still keep it all on one r…Donna Fazio 23 views 5 comments 0 points Most recent by Clare Murtagh - new Reporting & Analytics for Sales
-
how to add dynamic values inside message content in BIP report schedulingSummary: I would like to know whether we can add parameter values under "message" while scheduling the report . The screen shot is given below. Content (please ensure yo…Simi_SS 42 views 6 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to find linkage between renewed subscription and original subscriptionSummary: Lets say we have a renewed subscription having number as 123456. How do we find the original subscription for this renewed one. Content (please ensure you mask …Neelesh Varma 31 views 2 comments 0 points Most recent by Ashwinikumar Sharma Subscription Management
-
OOTB Subject Area Partner does not OOTB field Preferred Contact NameSummary: Hi Experts, I am trying to create a simple OTBI Analysis report within Oracle Sales Cloud (CX Sales) SaaS. The OTBI Analysis report should show all Partner Orga…AparajitMalliJawaharBapu 11 views 2 comments 0 points Most recent by AparajitMalliJawaharBapu Reporting & Analytics for Sales
-
OTBI does not show attributes standar that were created in Oracle CxSummary: Hello community! When creating an analyst in OTBI, and located in the object "Lead" missing the field "ExpirationDate", this field is standard, however, does no…SUUM Technologies 32 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Filter to get the earliest date in the OTBI Analysis.Summary: Content (please ensure you mask any confidential information): Hi, kindly asking for your help. I am trying to get the earliest date per account/activity within…Ivony Ann Paula Salango 24 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
custom subject area factSummary: My customer requested the creation of custom subject areas to put the information from these child custom objects in the reports. My team and I created the cust…Matheustavares#1412 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Diagnose link purpose?Summary: What's the purpose of the Diagnose link in analytics dashboard? Content (please ensure you mask any confidential information): What's the purpose of the Diagnos…Chin Chi-Oracle 12 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle 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…Ashok Patil 72 views 1 comment 1 point Most recent by BogdanFarcasanu-Oracle Human Capital Management
-
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
-
ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUESummary: ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE Content (required): ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE IN DATA MODEL PROPERTY I HAVE INCREASED …RIfdhy Zain 31 views 4 comments 0 points Most recent by Priscila Terazawa - 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 305 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 51 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 81 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 13 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 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 137 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 33 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 123 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales