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
-
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… -
Fusion Financials: Configuring Accounting Segments for OTBI reportingSummary This document describes how to configure the accounting segments in Fusion Financials cloud to facilitate consumption of the accounting segments in Oracle Transa…
-
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 … -
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…
-
How to stop notifications for PO's at instance level.Content How to stop notifications/transmissions for Purchase Orders at instance level? Version Rel 13 19A
-
Any way to pull Previous year's generated 1099s?Summary Any way to pull Previous year's generated 1099s?Content We are reviewing our 1099 process and wanted to look at what we have generated in previous years... Is an… -
How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud? Please Find attached Screen shot explaining the issue in detail. Your re…
-
OTBI Dashboard - Drilldown FunctionalitySummary OTBI Dashboard - Drilldown FunctionalityContent Can anyone provide me with guidance on the exact URL that should be used with OTBI dashboard to drill down from O…
-
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Debtors / Supplier's view at consolidated level (Across Ledgers)Summary Debtors / Supplier's view at consolidated level (Across Ledgers)Content Hi, If I have a "supplier" with whom my organization is trading across BU and across Ledg…
-
Cash Flow statementSummary Cash Flow statementContent Hello anyoune has experience or suggestion about creation of a cash flow report? Best regards, Antonio -
Issue seeing requisitioner details in procurement subject areaSummary Financial users are unable to see requisitioner names for purchase ordersContent I am hoping someone can please advise in regards to this issue, we have a report…
-
Cost Center DescriptionSummary Link from GL_CODE_COMBINATIONS table to Cost Center DescriptionContent Using BI Publisher I need to get from the GL_CODE_COMBINATIONS Table to a Table which cont…
-
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…
-
BIP Report Output To Content ServerSummary Need to burst BIP Report Output to Content ServerContent Hi As per the oracle doc, I need to add a content server by navigating to Administrator--> Manage BIP --… -
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 MobileSummary Documentation for best practice OTBI moblieContent Is there documentation for best practices for OTBI mobile? Should I use Oracle Business Intelligence Mobile or…
-
Filtering Issue on Data ModelSummary The results of the data model are not being filteredContent we are trying to create a simple data model with a variable. But the data is not being filtered as pe…
-
OTBI Report: Issue Aging AnalysisSummary PMOs, Project managers and stakeholders want to view their issues and due dates in a summary compressed view initially and then have the ability to drill down to… -
Role Customization to view Procurement and Finance AnalysisSummary Role Customization to view Procurement and Finance AnalysisContent Hi All, We have a requirement where Procurement Team will be accessing (only view) customized …
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs… -
Fusion POD name in rtf template -- AP Check PrintingSummary How to get Fusion POD name in rtf template -- AP Check PrintingContent Is it possible to refer the fusion pod name in check template. We would like to watermark …
-
Credit Memo Generation on Receivable Invoices via SOAP APISummary Generation of Credit Memo (Refunds) on Receiables Invoices (Transactions) using oracle available SOAP API.Content Hi Friends, (Please correct me if i've posted i…
-
eText Header RecordSummary I need to create a header record in an fixed position eText Template.Content I need to create a header record in an fixed position eText Template. Which contains…
-
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…
-
How to hide the reports icon from the vertical bar on the performance documentContent Hi, We have created a couple of dashboards using performance real time subject areas. Have personalized the home page to provide the link for these dashboards. T…
-
Project Portfolio Management 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…
-
Project Portfolio Management Cloud OTBI Release 11: 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…
-
Supply Chain Management Reporting and Analytics Subject AreasSummary Overview of key business questions addressed in SCM Subject Areas