OTBI
Discussion List
-
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 105 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…Marko Puskac 21 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP -
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…Arin 11 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Download AR attachment from OTBIIs it possible to download the attachments from and AR invoice directly from OTBI? These are attachments that are uploaded directly into each invoice and the user wants …
-
Enhanced subject areas - Oracle Fusion ERP Analytics (24D)In the whats'new 24D note we have an enhancement in these subject areas: Encumbrance Accounting is available as an additional opt-in Generally Available pipeline feature…Rocha, Diego Rodrigo 32 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
OTBI Data Discrepancy for "Performed Action" Approve in Procurement - Requisitions Real TimeSummary: Hi Community, I'm encountering an issue in OTBI (Oracle Transactional Business Intelligence) when retrieving data from the Subject Area: Procurement - Requisiti…
-
What is the meaning of the LAST_UPDATED_BY and LAST_UPDATE_DATE in GL_FRC_REPORTS_B?Summary: Our auditors asked us to extract the contents of the table GL_FRC_REPORTS_B for them. While reviewing this data, we noticed that for many of the reports it is s…Chris Mansfield 33 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
When using smartview for the projects Essbase cluster how to display description instead of IdsWhen using smartview for the projects Essbase cluster how to display Tasks_Dimensions or Resource_Dimensions with their description instead of their IDs There is no clea…Ivan Olivera-Oracle 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Pivot Table in OTBI Not Displaying Response Value DataSummary: Where I need to transform data from a vertical format to a horizontal format using a pivot table. My original data looks like this: Buyer Name Question Name Sup…Warunyu.N34 22 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Enter prompt variable in SOAP executeXMLQuery requestSummary: We have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report…Nick H 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
receivables transactions real time oracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…RamaBrahmaReddy K-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Receivables & Collections
-
Billing number value not showing in receivables transactions real time oracleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…RamaBrahmaReddy K-Oracle 2 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Receivables & Collections
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…Sankhya 21 views 1 comment 2 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Specific user cant extract data from xla_transaction_entities .Need to Know role for this XLA tableSummary: Specific user can't extract data from xla_transaction_entities .Need to Know role for this XLA table We have made one report where we are using this table but a…
-
OTBI Agent - Error Generating DocumentI have an OTBI report that I'd like to schedule to run and send the report via email. I've created an Agent to run the report, but when I receive the results via email, …Steven Woods 61 views 3 comments 0 points Most recent by Sridhar_Rejeti_1423 Reporting and Analytics for ERP
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
Unable to view the Export option while accessing the OTBI report via infoletsSummary Unable to view the Export option while accessing the OTBI report via infoletsContent Hi Guys, I had created the independent OTBI Report with the report links and…SandeepPaspunuri 240 views 6 comments 0 points Most recent by Thiakeswaraa Reporting and Analytics for ERP -
Return to Vendor Report?Summary: Business needs a report of completed and pending RTV/RMA transactions. Content: Business is using Sales Orders to ship product to customers. Need a report to tr… -
Does the END_DATE field in PER_USERS table get populated when the user is made inactive?Summary: Does the END_DATE field in PER_USERS table get populated when the user is made inactive? Searched this filed and no values populated Content (required): Making …
-
OTBI Receivable transactions- Real Time- Trying to get the warehouse/ship from detailsHi Team, Trying to create OTBI Report using Receivables transactions Real time. We need to add warehouse/ship from organization details for each of the invoice line. Una…Garima Arora-Oracle 11 views 1 comment 0 points Most recent by Garima Arora-Oracle Reporting and Analytics for ERP
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 1.9K views 17 comments 22 points Most recent by cdreyer.de Reporting and Analytics for ERP -
My ledger currency and reporting currency is different.Summary: Need a report from Oracle cloud financial module that provides month end FX rates. Content (please ensure you mask any confidential information): My ledger curr…PiyushRathi1234 22 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
Schedule of Expenditures of Federal Awards (SEFA)Summary Attempting to built the SEFA report using the Projects - Cross Subject Area Analysis - Real Time subject area.Content Report requirements include: Accounting Yea…Meredith Bickell 210 views 7 comments 2 points Most recent by User_5C630 Reporting and Analytics for ERP -
Unable to access the Standard Invoice screen from the OTBI Action Link ReportSummary I am trying to navigate to the Standard Invoice Screen from the custom OTBI Report via Action LinksContent Hi , I had created a custom report with the Payable In…SandeepPaspunuri 171 views 16 comments 1 point Most recent by Joanne Heathcote Reporting and Analytics for ERP
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 23 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 303 views 3 comments 1 point Most recent by Gopi Krishna Pokuru Reporting and Analytics for ERP
-
Can you share Expense Reports OTBI including Approver information ?Summary: Can you share Expense Reports OTBI including Approver information ? Thank you Content (please ensure you mask any confidential information): Version (include th…
-
User and Report Access ReportBusiness is requesting a report that have the following columns details: User username Report Name Period Inventory Valuation Report Source Of Report Scheduled Process o…
-
How to identify new lines in a PO through tables?Hello community, We are customizing the purchase order PDF, and in a requirement my client asks to show the new lines that have been included in a change order after the… -
Time Lag when changes in Procurement appear in OTBIChanges made to PO's, Requisition do not appear immediately in OTBI but after a number of Hours? Is there a process that pushes through the Changes to OTBI?