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
-
Lineage document for Oracle Analytics For Fusion ERPSummary This document provides the lineage report from Subject Area to data warehouse table and column.Content Enclosed Oracle Analytics For Fusion ERP subject area to d… -
Financial reporting studio report using a custom heading repeats when expandingContent We are using a custom heading with expansion enabled, the member and its children are renamed as well. How can we edit this so that the Custom heading only appea…
-
Financial Reporting Studio - Pages Function / Data AccessSummary Financial Reporting Studio - Pages Function / Data AccessContent My client has multiple Legal Entities that deal in different Currencies and Ledgers. They wish t…
-
Paid Status for invoicesSummary Looking for the table that holds the field displaying the Paid Status for invoicesContent Hi, I am looking for the Oracle table that has the field that displays …
-
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …
-
Instance details for BI Publisher Report Template - Fusion ERP/SCMSummary Water marking Instance details on BI Publisher Report and EmailingContent We have a requirement to display the Instance name as watermark in some of the BI Publi… -
Generate file name at runtime in BI publisherSummary Generate file name at runtime in BI publisherContent Hi We have a requirement to generate the output file name with some custom name appended with timestamp in B…
-
Daily Report that highlights supplier submitted invoicesContent Dear, Please can someone advise how to set up a report that can be scheduled daily to provide us with any new invoices that have been submitted by the supplier s…
-
Generate Summary Metrics for Expenses - Scheduled Process & OTBISummary Seeding Data for OTBI Subject Area: Expenses - Employee Expense Overview Real Time via Scheduled Process - Options and FrequencyContent While working through rep… -
GlTrialBalanceReport is not workSummary Standard report General ledger trial balance report giv error fileContent Hi when start run General ledger trial balance report from schadenfreude process error … -
Payments and Batch details should pull into single row with eText templateSummary Payments and Batch details should pull into single row with eText templateContent Hi Friends, eText payment template file using different groups where always hav… -
BI Report using Saas and Paas DataSummary How to access Paas Database data from SaasContent Hi, I have a requirement to develop a BI Report in ERP Saas using data from the ERP and also from a custom we'v…
-
Drill down in fusion BIP ReportsSummary Using drill down functionality in BIP Reports (using BIP template and output in excel)Content Hi, Does anyone use drill down functionality in BIP Reports (using …
-
How to use Seniority Date in Analysis?Summary 19D release includes new Seniority Date fields which I can't figure out how to useContent Hi, According to the documentation for the 19D release, Seniority Date …
-
How to secure ESS LOV by Business UnitSummary How to secure ESS LOV by Business UnitContent How to secure ESS LOV by Business Unit. i.e. There are two Business Units -> BU1 and BU2 I have access only to BU1.…
-
Combing OTBI Output in one rowSummary Combing OTBI Output in one rowContent I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Li…
-
BICS migration to OACSummary BICS migration to OACContent Hi All we have BICS on Paas which is not implemented yet and Oracle recommend to migrate to OAC. We need to know do we really need t…
-
Sales Credit information not available in Projects - Cross Subject Area Analysis - Real TimeSummary Sales Credit information not avaible in Projects - Cross Subject Area Analysis - Real TimeContent Sales credit information such as salesperson name, percent, sta…
-
ESS Job Definition Table NameSummary Which Table Stores the ESS Job Definition Table NameContent Good People, I am just asking the Table Name / View Name that stored the ESS Job Definition Details ,… -
"Supplier - Supplier Real Time"."- General"."Alternate Site Name" with Error: 14025Summary While developing an OTBI Report using two Subject Areas ( "Payables Invoices - Transactions Real Time" and "Supplier - Supplier Real Time"), "Supplier - Supplier…
-
R13 Avaliable Cloud Reports in ExcelSummary Avaliable Cloud Reports in ExcelContent Hello : I was wondering if you can share with me the avaliable Cloud Reports in Excel. Thanks for your help Best Regards
-
In Oracle Fusion 20A update Data models will be discontinue or not?Content Dear All, In Oracle Fusion 20A update Data models will be discontinue or not?. And you have to migrate your reports which is created on data models. Can anyone k… -
Viewobjects used in OTBI RPDSummary Viewobjects used in OTBI RPDContent Hi, I've noticed that OTBI RPD queries view objects such as 'oracle.apps.financials.payables.invoices.transactions.publicView…
-
OTBI Customer SurveyContent Oracle BI development is planning OTBI feature improvements. To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting … -
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …
-
Group by Due DateContent Hi, I have output of the report from RTF template as below Due Date Amount ---------------------------------- 01/01/2020 1000 01/04/2020 1000 01/05/2020 1000 01/… -
Deprecating BI Publisher connectivity to the Oracle Fusion TablesSummary Restricting access to Fusion Cloud database via BI Publisher Data ModelContent Heard that Oracle is planning is to restrict the access to Oracle Fusion cloud tab…
-
Displaying the PO MATCHED DATE from the Procurement Subject areaSummary Displaying the PO MATCHED DATE in PO Details report.Content I want to display PO Matched Date and PO receipt date in my PO Details report. for the receipt date i…
-
Convert number to wordsContent Hi, In the invoice report which has payment terms of 10 months it generates 10 invoices with payment due date, amount and the instalment number say 1...10 The in…
-
ODBC driver returned an error (SQLExecuDirectW)Content I tried to build a report on the subject area 'Payables Invoices - Installments Real Time', by querying the following 5 fields: Business Unit.Business Unit Name …