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
-
How to generate XML Positive Pay File in COS payments formatSummary HSBC bank needs XML Positive Pay File in COS payments formatContent ERP Cloud customer is engaging with HSBC for payment processing. Customer will continue to pr… -
Income Statement and Balance Sheet reportsSummary Are there a Balance Sheet and/or Income Statement reports available in ERP Cloud?Content I'm surprised there isn't an out of the box version for an Income Statem… -
Supplier Tax informationSummary Find the supplier tax data on the OBIContent hi i need to create reports on supplier tax information like tax registration and taxpayer d. i do not found them on… -
New Metrics for Oracle Fusion Cloud ApplicationsContent New Metrics for Oracle Fusion Cloud Applications We are pleased to introduce new subscription, usage and operational metrics for Oracle Cloud Fusion Applications… -
Financials ReportsSummary Financials reports resourcesContent You can refer to the following resources for information about Financials reports: * List of seeded reports * Sample reports … -
Financials ReportsSummary Financials reports resourcesContent You can refer to the following resources for information about Financials reports: * List of seeded reports * Sample reports … -
Automated Printing reports from Fusion FinancialsSummary What are the options to print Seeded/Custom reports automatically from Fusion.Content Currently we have to download the report(PDF or Word etc.,) and print it lo…User_2025-01-23-23-57-50-589 61 views 1 comment 2 points Most recent by User_2025-01-23-21-46-35-156 -
FX Rate Reports from FusionSummary Extract of given days' FX RatesContent Hi There, We are trying to use a report to see what FX Rates were used in Fusion on a given day in the past. The provided … -
Is there a way to dynamically rename split rtf files using PDFZ output?Summary: We have a requirement to rename the individual pdfs that get generated from an .rtf report in BIP. I think I am "close", but I can't seem to get the XML tags co… -
Get FRS report results in different currencySummary: Is it possible to get all FRS report output in a group currency? Content (please ensure you mask any confidential information): We have a requirement to calcula… -
There is a image placed in Custom/Image folder. How to access this image in the BI report template?Unable to access images from Custom folder in BI report template. We have placed the test image in Custom/Image folder and tried to access this image in the template but… -
Print receivables transaction process different default parameters for different usersI noticed that different users have different default parameters when running print receivables transaction process in scheduled process. Our configuration user access h… -
OTBI Case Statement excludes some of the row from StatementsSummary: After adding Transaction code formula as follows CASE WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement L… -
Is there any way to integrate BI Publisher bursting with Fusion’s notification frameworkSummary: We currently use BI Publisher bursting to send report outputs via email to users. This works fine, but we also want the same notification to appear in Oracle Fu… -
Is there any REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM Demo ?I am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us… -
Smart View handled an unknown exception thrown by Microsoft OfficeSummary: Smart View Error - Smart View handled an unknown exception thrown by Microsoft Office Content (please ensure you mask any confidential information): Steps to re… -
Recommended OTBI and BI Publisher Reports for Financial ReconciliationI’m exploring OTBI and BI Publisher in Oracle ERP Cloud and would like to build useful reports for reconciliation between Payables, Receivables, and GL. Could someone re… -
Is there a way to replace Oracle logo at the platform level for all seeded reports?Summary: How can we replace Oracle logo with customer logo (white labeling) for all seeded reports? Content (please ensure you mask any confidential information): We hav… -
What are the considerations of enabling and disabling the global "SQL Pruning" setting in BIP?A customer enabled the global SQL pruning setting in production which caused various BI publisher report issues (primarily, missing columns from various CSV and RTF outp… -
Audit Trail in Procurement and Self Service ProcurementSummary: Currently in Procurement its possible to see only Supplier Audit History. Requisiton and Purchase Orders don't have any detailed history data available. Content… -
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o… -
Is there functionality to leverage Data Access Sets for BIP reportsHello, Does anyone have any feedback on how to secure BIP reports via Data Access Sets? We are trying to split out security roles so that International crew only see the… -
Is there a way to change the format of the output from a report?We currently have a custom report we use for maintenance, and the user is requesting we help him change the output options so CSV can be used. We currently only have HTM… -
Is there any standard checklist or set of best practices to follow after a P2T process?Dear all, Following the completion of a P2T process (data migration from Production to Test), I would like to inquire whether there is a standardized checklist or a set … -
Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP BackendHi Team, We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PR… -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin… -
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb… -
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):… -
Are there available audit reports to track master data changes?Summary: Client wants a report to track master data changes - customer, supplier, system configurations. Are there available seeded reports to cater to this requirement?… -
How to control the scheduled BIP report Output based on Row CountRequirement : BIP report schedule daily - which is configured to send an email - base don the configured emails. Is it possible to control sending an email based on the …