To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Performance issueSummary AR | Performance issue with ra_cust_trx_line_gl_dist_all tableContent Hi All, Table ra_cust_trx_line_gl_dist_all is taking long time to run query when we use gl_…
-
Payables positive pay fileSummary Rename positive pay file nameContent Hello Guys, Can someone help on the below requirement, We have to send positive pay file to external server and with specifi… -
Due Date Calculation Formula based on Terms Date and Terms Name in OTBI ReportSummary Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI RepoertContent Hi All, I have a requirement to derive Invoice Due Date based … -
Bursting feature in BI PublisherSummary Burst contents to email body than attachmentContent Hi - I have a requirement to send Dunning letters in BIP but the contents should be in the email body rather … -
Approval Workflow ReportSummary Completing an audit of approval workflow for expenses, procurement and budget transactions.Content I am completing an audit of our approval workflow setup for ex… -
How to Clean / Erase all configuration & data from a POD ?Summary POD Clean upContent Good People, How to clean the POD by erasing all data & configuration ? Just make it reset as untouched environment. Thanks, Soumya
-
ERP Cloud R13 quarterly upgrades to advance for one monthSummary Requiring to advance Quarterly release one month aheadContent Hello community, Could I know if an ERP Cloud (Financials/Purchasing) client can move ahead the qua… -
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev… -
BI report parameter entries - allow manual entries or search a value in the drop-down listSummary Need to allow users to make manual entries or click on the drop-down list to search for a report parameterContent All of our BI reports are set up with a drop-do…User_2025-01-25-04-50-08-084 58 views 14 comments 3 points Most recent by User_2025-01-25-04-50-08-084 -
Print Receivables Transactions: Email Delivery --Override email address for non prod instanceSummary How to override or block emails to customers in non prod instanceContent For Print Receivables Transactions-Email Delivery , Is it possible to have an override e… -
How to rename the Worksheet name from Sheet1 to ?Summary Sheet1 to Content Good People, We are using the guided template for the BIP report and exporting it to Excel. When its exported the File Name appears correctly w…
-
Custom Subject Areas for Cloud ERPSummary Custom subject areas can be created under application composer for CRM, but is this available for ERP?Content Hi, I have been using the Fusion Rel 13 partner env… -
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working…
-
Project Portfolio Management Cloud OTBI Release 13: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this… -
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… -
Budgetary Control Analysis Report Sample - Projects High VolumeSummary This is a sample budgetary control analysis report for projects control budgets.Content This is a sample report that is a based upon the standard budgetary contr… -
OTBI Subject Areas documentationSummary Does documentation exist for OTBI Subject AreasContent Does documentation exist for the content of the ERP OTBI Subject Areas? My goal is to determine the subjec… -
OTBI on delegated authoritySummary I require an OTBI report to display the users who have set up a delegated approval (for OTL, Requisitions etc), when they created and who they delegated their ap… -
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this… -
premature availability of BI Output files in SFTP causes problemsSummary BI Output files found in SFTP are available for download before being completely writtenContent I am using BI Publisher within our deployment of Oracle Fusion Fi… -
Doing a Supplier analysis in Fusion FinancialsSummary Doing an analyses on groups of suppliersContent Hi all, One request we are getting is to do an analysis on our suppliers by grouping them - by their legal struct…User_2024-12-02-18-02-01-030 84 views 0 comments 3 points Most recent by User_2024-12-02-18-02-01-030 -
Reporting against Legal Entity TransactionsSummary How can you report against Legal Entities in Fusion when it is not directly part of the chart of accounts?Content Hi there, We are trying to create reports for o…User_2024-12-02-18-02-01-030 126 views 8 comments 3 points Most recent by User_2024-12-02-18-02-01-030 -
How to open a Financial Report in SmartviewSummary Using FRS- report in SmartviewContent Hi all, We have created a few reports in Oracle Financial Report Studio in Oracle Fusion R11.1.7 We are able to open the re… -
Redwood roadmap for Oracle FinancialsSummary: We would like to know Redwood implementation roadmap for Oracle Financials. It involves lots of planning and effort sooner we know the roadmap it will help cust… -
RVIE Report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) Not Showing Any InvoicesHello everyone, I’m currently facing an issue with the RVIE report (14.1 Registro de Ventas e Ingresos Electrónico – SUNAT Format) in OTBI. When executing the report for… -
OTBI Report 8.4 RCE Anexo 11 – No Invoices DisplayedI am experiencing an issue with the OTBI report “8.4 RCE Anexo 11 – Replaces Proposal” under Oracle Fusion Cloud Financials. When I run the report for the September acco… -
Users with experience of using SQLConnect by BI SplashSummary: Users with experience of using SQLConnect by BI Splash Content (please ensure you mask any confidential information): We are reviewing the feasibility of granti… -
Best Practices for OTBI Reports Handling Large Data VolumesSummary: Hi everyone, I’m looking for recommendations and best practices for developing OTBI reports that need to handle large amounts of data. Is there a recommended st… -
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… -
How to add a deep link to items ?I have attempted to use the Deep Link SCM document to create a deep link for Items, but unfortunately, it didn’t work as expected. Could you kindly assist me with a step…