OTBI
Discussion List
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh Kumarasamy-Oracle 91 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP -
Supplier Audit ReportSummary Supplier Audit ReportContent Good People, Anyone create supplier Audit Report as a custom one apart from the one available ? Thanks, SoumyaSoumya Prakash Parhi 213 views 18 comments 1 point Most recent by Gaurav Jain _Infosys Reporting and Analytics for ERP -
Receivables: Status Tracker in OTBI/BIPSummary: Content (required): Is it possible to report on this Status Tracker in OTBI? Or BIP? And if so which which subject area or which tables are these to find in? St…Nicolas Vahman 209 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Where to find the Building Society Roll number for a supplier on OTBISummary: I'm based in the UK and need to pull together a report (preferably using OTBI) listing suppliers' bank details that includes the Building Society Roll number or…Fraser HES 198 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Fixed column for year and other columns are promptedSummary: Content (required): Hi all I would like to know if it is possible to have one fixed column which always shows the forecast for e.g. 2022 while other columns are…Nicolas Vahman 46 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
How to modify Asset Cost Summary ReportSummary: I'm trying to modify the Asset Cost Summary Report. I created a copy of the DM (path = /shared/Custom/Financials/Fixed Assets/Asset Balances/Data Model/Cost Sum…
-
OTBI legal entity of AP invoiceSummary: Content (required): We want invoice header LE information in the report but as soon as we are adding payment details it starts showing payment LE information. S…Vinay Gharge 56 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Invoices on Hold with Matching DetailsSummary: I cannot find a good screen that will show you the pricing or quantity details that are behind a matching hold, so I created this set of reports that I hope you…Pam Clark-Oracle 43 views 1 comment 2 points Most recent by Pam Clark-Oracle Reporting and Analytics for ERP -
Is it possible to hide a graph prompt?Summary: I have a requirement to hide a graph prompt, because the graph is being updated by clicking in another table as a master-detail event. Content (required): It se…Anders W. Langholm 48 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
How do I remove grouping of grouped columns?Summary: I have created a report with a subject area and it has worked fine... For some reason, it's suddenly decided to group almost all my chosen columns and I simply …Anders W. Langholm 38 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How can I display a CLOB column value in a Data Model created from Oracle BI EE data source?Summary: Unable to display a CLOB column value in a Data Model created from Oracle BI EE data source Content (required): I have created a data model from a OTBI subject …Sujay Bandyopadhyay-Oracle 367 views 2 comments 0 points Most recent by Sujay Bandyopadhyay-Oracle Reporting and Analytics for ERP -
Adding and embedding BI content into Fusion Cloud ApplicationsSummary Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content intoContent Hi All, Our client wants to be able to add some BI con…Richard Beet 412 views 32 comments 3 points Most recent by Aitor Quintela Reporting and Analytics for ERP
-
Is it possible to report on requisition approval volumesSummary: Our business users are asking for reports to see who has approved purchase requisitions made in the business so that they can track volumes etc. Does anyone hav…DLMorgan 26 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
Asset Number not displaying in ascending order in OTBI reportSummary: OTBI report using Fixed Assets - Asset Depreciation Real Time displays asset numbers different sort order. screen shot attached. How to display asset numbers in…
-
Same report two different envonments different date formatsSummary: We created an OTBI report and the template specifies the field with a date format. We are trying to force the mm/dd/yy date in there. It works in our test envir…LOGAN-FELLOWES 35 views 9 comments 0 points Most recent by LOGAN-FELLOWES Reporting and Analytics for ERP
-
Display and ability to change parameter values in OTBI reportSummary: In BI Publisher report, report parameters are displayed and user can change the parameter values and run the report all on the same screen. Can the same be done…
-
Display and ability to change parameter values in OTBI reportSummary: In BI Publisher report, report parameters are displayed and user can change the parameter values and run the report all on the same screen. Can the same be done…NMM 46 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Accounting year in parameter displaying decimal valuesSummary: One of the parameters in an OTBI report is Accounting year but when I want to select a year, it displays the years with decimals Content (required): Defined a O…
-
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…
-
What is the current(22B) licensing/role description for OTBI reporting? ERPSelf-service vs. ERP Fin?Summary: Use Case 1 Store managers want to drill down on a report to view additional details in the report. View/Read=ERP Self-Service Use Case 2 Store Manager wants to …Mechelle Stone-Oracle 26 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
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… -
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 …
-
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 Mullin 100 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 36 views 4 comments 0 points Most recent by Shashank Verma-Oracle 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 176 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle 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…User_2025-01-30-04-49-10-284 134 views 4 comments 0 points Most recent by IIGC Reporting and Analytics for ERP -
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 18 views 2 comments 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for ERP