OTBI
Discussion List
-
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
Pass Column as a Presentation VariableSummary: Using presentation variable, compare one column against another in Conditional Format Content (required): Hi All, Does anyone know how to go about creating a pr…Rory Chirmside 4 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
schedule an analysis to run for sysdate and send email only if there is dataSummary: Content (required): Hi, I have created a very simple analysis - Project name, Project number, Project start date and project completion date and created by and …
-
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 22 views 6 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi… -
How to get the link for a custom application pageSummary: How to get the link for a custom application page? Content (required): We have created a custom page in our Fusion Cloud instance, were we have gathered our cus…Anders W. Langholm 1 view 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column.&…Noelle Bartlam-Oracle 1.4K views 19 comments 3 points Most recent by User541815-Oracle Reporting and Analytics for ERP
-
Invoice Count by Supplier From Prior MonthSummary: COUNT function to display number of invoices by submitted from supplier in prior month using Dynamic Date scheduling Content (required): Hi All, Using the COUNT…Rory Chirmside 13 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
OTBI : Facing Java:Null issue in Dashboard PropertiesSummary: OTBI : Facing Java: Null issue in Dashboard Properties. As shown in the SS below. Is it because of 22A Upgrade? Content (required): Version (include the version…Shashank Verma-Oracle 21 views 4 comments 0 points Most recent by Shashank Verma-Oracle Reporting and Analytics for ERP -
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment…Anders W. Langholm 1 view 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Is there a foreign exchange gains and losses report available?Summary: As a global company, with entities using +50 currencies, we'd like to see a report to understand what is generating the foreign exchange gains and losses at the…
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 2.3K views 124 comments 39 points Most recent by User_QUFPM Reporting and Analytics for ERP -
Can you change the font or color of a Dashboard tab?Summary: Can you change the font or color of a Dashboard tab? Content (required): Can you change the font or color of a Dashboard tab? Version (include the version you a… -
How can I create a BI Analysis that considers the credit limit of a customer at Party levelSummary: I need to create an analysis that considers the credit limit of a customer at Party level, all the subject areas that I found that have the credit limit are at …
-
Fixed Asset Balances - Real Time subject area is not updatingSummary: Content (required): We have developed a report using the Fixed Asset Extract Balances table and the recent transactions re not updated in the table. The "Extrac…Dian Minshan 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP -
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o…Mark_Daynes 118 views 5 comments 2 points Most recent by Marybeth Snodgrass Reporting and Analytics for ERP -
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 65 views 6 comments 8 points Most recent by Marisa Escobar Reporting and Analytics for ERP -
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 7K views 76 comments 40 points Most recent by Chris Alexander Reporting and Analytics for ERP
-
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if…
-
How do I create a variance Forecast - Actuals in OBIEE for EssbaseSummary: How do I create a variance Forecast - Actuals in OBIEE for Essbase where the Forcast and budget are row based as the Scenario dimension dictates whether the val…RichardChan 1 view 2 comments 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for ERP -
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 11 views 2 comments 0 points Most recent by Melissa G Reporting and Analytics for ERP
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 50 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
Vacation and Delegation Rules reportSummary: Hi All, We have a requirement to create the below report for Vacation and Delegation rules in the application. Say when Line Manager is going on Holiday and he …Dharmendra Jha 22 views 3 comments 0 points Most recent by Stephen_J Reporting and Analytics for ERP
-
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 11 views 3 comments 0 points Most recent by Rebecca Walker Reporting and Analytics for ERP -
Table for ESS Job scheduleSummary What is the table name in Oracle Cloud which stores the Schedule of an ESS JobContent Is there a table name or query which I can use for fetching the frequency, …Shubhojit Purkait 46 views 8 comments 0 points Most recent by User_M940T Reporting and Analytics for ERP
-
OTBI-Report-Supplier Portal - Invoice Real Time-Roles RequieredSummary: OTBI-Report-Supplier Portal - Invoice Real Time-Roles Requiered Content (required): Hello The following document state the role required to run the Supplier Por…Cesar Saveedra 21 views 3 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
How do i make a report which i created via OTBI available to be submitted via Scheduled processesHow do i make a report which i created via OTBI available to be submitted via Scheduled processes ? Version (include the version you are using, if applicable): 22A (11.1…
-
BI - Seeded and Custom Folders Mirroring Each Other?!Summary: We are experiencing several custom template issues and have noticed that our Custom and Seeded Folders are mirroring each other without human intervention. Cont… -
DFF not available in Subject area even after running the specified processSummary: We have created an OTBI report for Projects using Project Cost - Actual Real Time subject area and it includes a couple of DFFs. This report was migrated from o…Abhishek Shukla 1 view 3 comments 0 points Most recent by Abhishek Shukla Reporting and Analytics for ERP
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…Eren Göktepe-155015 19 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP