OBIEE Answers
Discussion List
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 1.2K views 5 comments 0 points Most recent by Hugo Martínez Reporting and Analytics for ERP -
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the …amy hardtke 75 views 5 comments 0 points Most recent by Emily McAdams Reporting and Analytics for ERP -
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaRamaKrishna-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Editing a page using sandbox subjected to a user roleSummary: Content (required): Hi All, We have a requirement to publish the dash boards created using OTBI analysis in the 'My Dashboard' page. However, the published dash…Vipusha Chandrakumaran 32 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…Nageshwaran1 40 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
Missing data in some columns in FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVSummary: Hi We can see all our columns in our COA, but there is only data in segment1. What do we need to do in order to see more data? Content (required): Version (incl…Bo Tøpgaard 67 views 4 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Smart view - OBIEE - ExcelSummary: When working with multible excel workbooks and connected to OBIEE in one of them, when shifting to another workbook the OBIEE extension tab always open. Content…johannoli 42 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Privilege/Duty Role to be granted to view GL Transaction Balance Real Time SA reportsSummary: Content (required): Hi, We have a user that DOES NOT have the General Accountant or General Accounting Manager roles assigned. However, there is a requirement f…Sheneli98 72 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How to create a custom tab in oracle fusion UI page?Summary: How to create a custom tab on the oracle fusion UI page? Content (required): Hi Experts, We got a requirement to add a custom tab to enter supplier details. Is …Venkatesan 231 views 8 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Invoice Filter does not work. Please review and provide any suggestion for this OTBI code.Summary: Invoice id Filter does not work. Please review and provide any suggestion for this OTBI code. Content (required): OTBI Version (include the version you are usin…Abhilash K - Deloitte USI 51 views 3 comments 0 points Most recent by Manu R-Oracle Reporting and Analytics for ERP -
Subject Areas Exposing PPM KPI'sSummary Do any of the delivered PPM Subject Areas expose the KPI and related informationContent I am not seeing any of the Project-based KPI information such as measures…Charles Heishman 100 views 3 comments 1 point Most recent by Santhi Sree Reporting and Analytics for ERP
-
How to filter by Invoice ID that has had the invoice approval state 'Automatic Rejected'.I want to filter a dashboard to show all invoices that still require action to be taken, that were automatically rejected by the system. I want to see all rows of "Payab… -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 765 views 2 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for ERP
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…Rajagopalan Rangarajan 121 views 1 comment 3 points Most recent by Gillian Kilbride Reporting and Analytics for ERP
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Manage Project Sets - Table/Subject AreaSummary: Content (required): Hi I would like to know which tables stores the information in regards to Project Sets that is created in Fusion. I find the manage project …Nicolas Vahman 11 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Payables Invoices by Cost Centre/SupplierSummary Dashboard & reports showing summary of AP invoice value by period/cost centre/supplier, with drill-down to invoice detailsContent Please see attached documents f…Andy Gough 908 views 10 comments 13 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 231 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP -
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…Abhilash K - Deloitte USI 63 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
OTBI Analysis: Is it possible to add a column that summarizes Invoice Amount by Supplier?Summary I'm building an analysis in OTBI and wanted to know if it's possible to have a calculated column that summarizes one of the other columnsContent I'm building an … -
Report on OTBI Agents Scheduled / StatusesSummary: Report on OTBI Agents Scheduled / Statuses Content (required): Is there any way to Report on OTBI Agents Scheduled / Statuses, either via SQL in BI Publisher or…AngelOftheNorth 45 views 3 comments 0 points Most recent by User_VX7QK Reporting and Analytics for ERP
-
how to define a xml in rtf if there are multiple datasets with the same column nameSummary: Hi everyone, Recently I faced an issue with a seeded report that was customized. The report had two datasets with the same column on both, where when I try to l…
-
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …Bernard T 424 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri 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 -
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
-
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 411 views 32 comments 3 points Most recent by Aitor Quintela 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 Mullin 92 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
BIP Report to read file from UCMSummary Need to read file in UCM using BIP ReportContent Hi Team, Could you please let us know whether it is possible to read file from UCM via BIP report ? If anyone ha…Uvaraja-Oracle 143 views 7 comments 0 points Most recent by Rory Mullin 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 11 views 2 comments 0 points Most recent by Bharath Raghupathi-Oracle Reporting and Analytics for ERP