OTBI
Discussion List
-
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 909 views 7 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Error whilst joining Subledger and GLHi, I am trying to create a report that joins the subject areas Subledger Accounting: Journals Real and General Ledger: Journals Real Time. It works fine up to the point…BillM 71 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP -
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…Arun N-OC 361 views 8 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Customize Receivables aging seeded ReportSummary Customize Receivables aging seeded Report - to include Project information and grouping totalsContent Hi, We want to customize Receivables aging by General Ledge…User_V0Y9V 594 views 7 comments 6 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F…Rihan Jameel 61 views 4 comments 0 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
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 85 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 175 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 201 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 181 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 41 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 51 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 41 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 41 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 32 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 331 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 408 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 21 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 31 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 41 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 21 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 91 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 31 views 4 comments 0 points Most recent by Shashank Verma-Oracle Reporting and Analytics for ERP