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
-
Group Filter not working in Custom ReportContent We have developed a custom Report. The Data Model is a master detail query includes a main query and three child queries Q_1 - Main Q_2, Q_3, Q_4 are child queri… -
Smartview HelpSummary Large Report book for SmartviewContent We just implemented Oracle ERP cloud. We have certain reports in a package totaling 208. We are currently utilizing about …
-
File Error Data may have been lostin OTBI - BI Publisher report that has multiple tabs is showing this error on opening the excel file. File error : data may have been lost Users are able to provide a sp… -
Which PVO's have location level details (e.g., names, codes, address information)Summary: Which pvo should be used to join to in order to get the location information for the deliver_to_location_id for each purchase order distribution line? Content (…
-
What is the current(22B) licensing/role description for OTBI reporting? ERPSelf-service vs. ERP Fin?Summary: Use Case 1 Store managers want to drill down on a report to view additional details in the report. View/Read=ERP Self-Service Use Case 2 Store Manager wants to … -
What table stores the system transactions reference number for Bank Statement (CE) reconciled itemsSummary: We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions li… -
schedule an analysis to run for sysdate and send email only if there is dataSummary: Content (required): Hi, I have created a very simple analysis - Project name, Project number, Project start date and project completion date and created by and …
-
Is there an Archive and purge Strategy for Cloud ERP?Summary: Is there any document or reference guide for Archive and Purge strategy for Cloud ERP and EPM? Content (required): For EBS, we had excellent resources in form o… -
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C… -
How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Summary How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Content How to Translate the BI Publisher Catalog Report Name and param…
-
General Ledger Transaction Listing ReportSummary Lists down all Journal Entries along with corresponding subledger detailsContent This is one single consolidated view of all the transactions in ERP. This report… -
ERP Cloud - Restrict value set by Data Set / Business UnitSummary: Create a value set that restrict values based on Data Set / Business Unit selected. Content (required): I am trying to create a value set that only displays val…
-
Unauthorized Access: Either you do not have the privilege, or you have not signed inAfter latest upgrade from Oracle fusion to version 22A and 22B - OTBI users are experiencing this error - intermittently. Everytime they refresh it connects back - but i…
-
Question about Pre-Upgrade Tasks: Necessary or Overkill?Summary What tasks should be performed before a QPB?Content Hello, Before every Quarterly Patch Bundle, we take these precautions and we are just wondering if they are a… -
EPM OOTB report listSummary: Report list Content (required): Hi, Is there a consolidated list available that provides EPM OOTB reports like other areas in a speadsheet? Thanks Version (incl…
-
Best practice to re-use same query in the same BIP data modelSummary: I have a common query say for selecting business unit based on certain user based login. Now I have a main data model query with multiple sub-queries in it. And… -
Will MS Office 64-bit work for Fusion Smart View reporting?Summary: Our company is planning to migrate to EPM Financial Consolidation (FC), can we upgrade to MS Office 64-bit for both Fusion & EPM Smart View reporting? Content (…User_2025-01-25-04-50-08-084 11 views 2 comments 0 points Most recent by User_2025-01-25-04-50-08-084
-
-
Strange SQL results, can't explain causeHi, I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A. Example URL: example.fa.ocs.oraclecloud.com/analyti…
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
Audit trial for Financial Reports (FRC)Do we have audit trial for financial Reports ? lets say if we want to see that who run which FRC report and when
-
Is there any way to get the sub category for module identify column in HRC_TXN_HEADER tableWe could see lot of transactions for Manage Employment (Under Module Identify field --> Table HRC_TXN_HEADER). We are trying to segregate the transactions. We are trying…
-
How to download OTBI and BIP reports before the refresh of the instance ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
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…
-
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s…
-
how to join inv_item_sub_inventories to inv_secondary_inventorieshow to join inv_item_sub_inventories to inv_secondary_inventories
-
LLP/Partnership Implementation in OracleSummary: LLP/Partnership Implementation in Oracle Content (required): Has anyone implemented LLP/Partnership Firms in Oracle. We want to know how the Partners Accounts w…
-
OTBI : Facing Java:Null issue in Dashboard PropertiesSummary: OTBI : Facing Java: Null issue in Dashboard Properties. As shown in the SS below. Is it because of 22A Upgrade? Content (required): Version (include the version… -
Procurement Dashboard is not showing the correct informationSummary: My Procurement dashboard is not showing the correct information against the PR. The PR has been converted into the PO and system is showing it but Dashboard is …
-
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42…