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
-
Oracle Fusion Workflow Report for all pending transactionsSummary: Is there any seeded Report available for all pending Workflows (PR,PO,AP Invoice, Payment, GL Journals, Expenses, HCM, PPM, OTL,etc). The report should show tra… -
OTBI PO Balance Report to Tie to Budgetary Control Obligation BalancesSummary: I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We … -
Job Definitions Created Did not Connect to BIP reportSummary: l need to create job definitions to run reports as scheduled processes. However after l maintained the job definition and BI report's property, the schedule pro…
-
Is there a Standard report in Oracle Cloud for ECD in Brazil? Does it show the previous year's?Summary: Is there a Standard report in Oracle Cloud for ECD in Brazil? If so, does it show the previous year's operations? What to do when starting to use the platform? …
-
The search is not working in the drop down menu in Data set BU publisher reportI have this parameter that is related to a list of value that give all the contract number. the query i am using for the list of value is: select DISTINCT TV.CONTRACT_NU…
-
How we can invoke multiple templates/Grids in FRS reporting based on the input parameters ?how we can invoke multiple templates in FRS reporting based on the input parameters. Unfortunately, we have not found any functionality to invoke multiple templates like…
-
Unable to get the data of glcoding for unapplied prepayments in otbi reportwe have created prepayment application register OTBI report, and we are getting the glcoding for applied prepayments but requirement to all data for unapplied and applie…
-
Payment Approval HistorySummary: We need the payment approval history data to capture the approvers at template level Content (please ensure you mask any confidential information): Hello Team -…
-
can we fetch report for how many times a report runHi Everyone, we have a requirement to fetch the all custom reports in the fusion, along with their information of how many times that report run in 2024 and what is the … -
Parameter values to pass to save update Data model of Subledger Period Close Exception ReportSummary: Customer is looking for Customized Subledger Period Close Exception Report to add Supporting Reference columns. Thus looking for an input to know which valid va…
-
Custom role Project Administrator and Cost Controller cannot see AnalyticsThe custom role that we made Project Administrator and Cost Controller should be able to see the Analytics Widget with Project Dashboard information. However its missing…
-
i want sql query to find business days differnece between two datesSummary: I want a query in sql to get businees days between two dates E.g i have two dates of differnet tables the gap is of 15 days or may be 7 days or may be 30 i want…
-
Sending Customer Statements via API or SOAPSummary: Mass sending of customer statement of account to selected list of random customers. Similar to mail merge Is there any API or SOAP that can be used to call Stat… -
Convert English numbers into Arabic numbers in rtfI used function to calculate the summation of the VARI variable in the page and used this to show the number in footer, I need this number to be displayed in Arabic, n…
-
accouting hubSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…
-
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…
-
How to download entire Data ModelsHello, We have created an update of a very complex data model and would like to compare it with the old one. We remember that in the previous versions it was possible to…
-
Account is outside of report range message for Receivables to General Ledger ReconciliationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Fusion Finance Analytical Reports Dashboard in FAWSummary: GL Account Analysis Dashboard in FAW enables user to analyze account activity from various sub-ledger sources supported in FAW like AP, AR, etc. contributing to… -
How to export 500K rows from OTBI report into ExcelSummary: We have a report where total data is coming close to 500K and we are only able to export 25K in Excel, is there is any way to do this? If I develop this in BI P… -
What is the field where I can check the inactivated date of user in fusion.Summary: I want field where inactive date of user gets stored . Also if I delete some role from user I want to have when did I delete the role. Also in Front end I am ab…
-
Execute SQL Query against Cloud ERP/HCM without using DataModel/BI ReportSummary: Hello, Usually Oracle Fusion BI Report/Data model was used to create SQL(like "select * from poz_suppliers_int") against Fusion DB ( like ApplicationDB_FSCM,App…
-
24B INV_ORGANIZATION_DEFINITIONS_VHi , We were using the following query and post 24B its not fetching data set for users who are restricted for specific BU. Let me know if any one are facing similar iss…
-
Procurement - Purchasing Real Time project DFF missing after 24B updateSummary: Procurement - Purchasing Real Time project DFF missing after 24B update. This was working fine before the update. Did this get removed from the subject area? Co…
-
Need to know the table and api for Fusion application notification setupWe want to know the tables and web service APIs of the below two locations of notification setup. As we are creating bip reports and integrations for the same. Navigatio…
-
How to print a barcode in BIP report?Summary How to print a barcode in BIP report?Content How to print a barcode in BIP report? Version 19D -
Issue on Transaction Class in Receivables TransactionCredit memos always have "Credit Memo" as the transaction class. But some of the Transactions were populated on the report as "ONACC" as Transaction Class instead of "CM…
-
Not able to rename or delete existing folder in BI catalogSummary: Content (please ensure you mask any confidential information): Hello All, Hope you are having a great day. We are facing an issue while renaming a folder in BI … -
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an…