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
-
Excel document that shows OTBI subject area, BI duty role name and BI job role for access purposeSummary: Need an excel document that shows Financials OTBI subject area, BI duty role name and BI job role for access purposes similar to attached output that was availa… -
How to enable the File Data Sources in Oracle BI PublisherSummary: How to enable the File Data Sources in Oracle BI Publisher? The guide shows how to do it but we are getting the error (Fusion Middleware Administrator's Guide f…
-
Account Analysis for Contra Account Standard Report - CustomizationHi , I have copy this standad report to my custom location . Now i want to add two more columns in this report. 1- Transaction Number ( Which is comming from subledger i…
-
Is it possible for an analysis to link to a dashboard prompt?Hello, I would like to link one analysis to the prompts on a dashboard which will then update another analysis. Is that possible? Thank you, Julia Oracle Fusion v23A -
Analysis - SQL expressionSummary: How to get first month of previous date - SQL Expression (Criteria ) Content (required): We have created a Analysis report and business needs to schedule this a…
-
Fusion BI Report Custom LOV description alignment problemSummary: The problem : The description is not properly aligned (see below in yellow) in custom LOV. The user has requested for the description to be left-aligned. Conten…
-
What is SQL Receipt Accounting join to source_id_int_1 column from xla_transaction_entities?Summary: Trying to go from GL through Subledger Accounting to Receipt Accounting in Data Model SQL. Didn't find any documentation or hints on this. Content (required): V…
-
BICC - Customization migrationSummary: BICC - Customization migration Content (required): I want to migrate one custom offering from one environment to another environment. BICC is giving an option t… -
Can anyone help in sharing an idea for developing contra account report.Summary: For example, if in parameter, an account is selected, all relevant Debit and Credit which were generated against that account gets reported. Content (required):…
-
Moved: Can I have multiple logos for 1 only income statement FRS report?This discussion has been moved. -
Moved: is it possible to have access for specific entities in FRS report(income statement)?This discussion has been moved.
-
How do I combine multiple subject areas in a one report?I am a Fusion Financial Customer and I am trying to write a simple report connecting Invoices to Payments. I need to include in my report the AP Routing and the Payment …
-
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …
-
Define Hyperion Financial Management from Financials Setup and MaintenanceSummary: On selecting the Setup and Maintenance --> Financials --> Financial Reporting --> Define Hyperion Financial Management Configuration task I get the below messag…
-
OTBI Dashboard combining two subject areas of two different modulesSummary: We want to prepare an OTBI dashboard having 2 analysis. First analysis will pull the data from Procurement contracts module for lets say 10 suppliers and then s…
-
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio…
-
Understanding BI Extender and Import Oracle Fusion Data Extensions for Transactional Business ess joSummary: Hi Team, When using the columns of Entity(Balancing Segments) individually using balances real time subject area, it is generating correct result. However, when…
-
How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?Summary: Just like the title says, we are having trouble find that information. I wrote the SQL Below which does return the required information but in XML/BLOB Format. …
-
How to fix envelope section in the first page when there are more than one page output in RTF?Summary: How to fix envelope section in the first page when there are more than one page output in RTF? Content (required): We have a requirement to fix the bottom secti… -
Connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data SourceSummary: Is it feasible to connect Oracle Fusion BI Publisher and Oracle e-Commerce using Web Services Data Source ? If yes, can you provide us with any white paper docu… -
Irreversible- Key setups/design considerations detailsSummary: Hi Experts, We are planning to implement Oracle Fusion modules(Financials-GL, AP, FA, Payments, Project Financials, Procurement - Purchasing & SSP and localizat…
-
Disable online Output view for BIP reportsSummary: Disable online output view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report op…
-
Disable online Output view for BIP reportsSummary: Disable online view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report option fo…
-
View Contract Authoring Party in OTBI?Summary: We are trying to see which contracts were created with an "external" authoring party or an "internal" authoring party, as well as which contracts had the contra… -
Is there any way to skip "Columns" in Report Output as when they are empty?Hi Dears, We're working on a new BIP Report under Cloud implementation project and we want to used Excel template. We've been looking around how to skip/hide columns whe…
-
Query for Transaction Console transactionsSummary: Query for Transaction Console transactions Content (required): I am looking to write a query that contains the below information from the Transaction Console, r…
-
Moved: BI publisher custom notification needs to be consolidatedThis discussion has been moved.
-
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…
-
Is GDPdU (German Audit File) and GoBD Data Extract Same and Oracle ERP Solution is Generic SAF-TSummary: I have one question on Germany and Poland's localization report. Business requirement is to generate GDPdU (German Audit File) for Germany and Poland. When I tr…
-
Need products and modules that are relevant to the services client has subscribed to (Readiness App)Summary: Need products and modules that are relevant to the services client has subscribed to for selection in Readiness App Content (required): Hi Team, We need to get …