OTBI
Discussion List
-
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… -
Financial Reporting Center reports not showing in searchHello, We are having an issue with reports showing in FRC. When a user searches for a report in FRC they return no results, but if the user navigates to the BI Catalog r… -
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… -
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …
-
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 57 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…
-
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…
-
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…
-
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 8 views 0 comments 0 points Started by Chris Mansfield Reporting and Analytics for ERP
-
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… -
Enable All or Multiple selections from a Pivot Table prompt in OTBISummary The Pivot Table prompt should allow the selection of all or multiple items.Content We have a requirement to allow the selection of All or multiple items from the…Krutik Kansara-228240 261 views 6 comments 0 points Most recent by Santhosh Jayasekhar 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… -
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 6 views 0 comments 0 points Started by Ivan Olivera-Oracle 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…
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 20 views 2 comments 0 points Most recent by Dileep Varanasi Reporting and Analytics for ERP
-
Looking for PO Receipt Number and related data in OTBISummary Cannot find PO Receipt Number, Receipt Date and related date in OTBI Subject Area: Procurement: Procure to Pay Real TimeContent Cannot find PO Receipt Number, Re…Rona Jeongco 340 views 9 comments 0 points Most recent by Brittney Fuller Reporting and Analytics for ERP
-
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 12 views 1 comment 0 points Most recent by Garima Arora-Oracle Reporting and Analytics for ERP
-
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…
-
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 0 comments 0 points Started by RamaBrahmaReddy K-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 3 views 0 comments 0 points Started by RamaBrahmaReddy K-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.7K views 17 comments 21 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 23 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 170 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…User_4A8FM 122 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 14 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 244 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…Fernando Chavez 1 view 1 comment 0 points Most recent by nothingname Reporting and Analytics for ERP