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 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… -
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 …
-
Calling runReport in xmlpserver/services/v2/ReportService Webservice with SSO enabled user(Azure AD)Summary: Hi All, I am working on calling a BI Publisher report from a custom application using xmlpserver/services/v2/ReportService webservice. The requirement is to use… -
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…
-
"FAWService" Oracle Account is consuming Oracle Cloud Fusion LicenseWe have ran order built "UserPrivilegesByService" report and found "FAWService" which is an Oracle Account is consuming licenses due to "Supply Chain Planner" role. Plea… -
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…
-
Oracle Fusion - Trying to recreate an OTBI analysis using a custom reportWe have created an OTBI analysis that displays the following categories: Account Code, Invoice Distribution Amount, Accounted Amount CR, Accounted Amount DR, Invoice Num…
-
How do I get my .csv output columns in same order as ExcelHow do I get my .csv output columns in same order as Excel? Thank you. Esmeralda -
Editing a page using sandbox subjected to a user roleSummary: Content (required): Hi All, We have a requirement to publish the dash boards created using OTBI analysis in the 'My Dashboard' page. However, the published dash…
-
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…
-
Which function can be used to display only one value from multiple values result?Summary: Display the first value from a result including many values Content (required): We're using an OTBI analysis for delayed PO deliveries and we've supplier's deta…
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below. -
Supplier Qualification Infolets page showing initiatives status graph by login baseSummary: Supplier Qualification have Infolets page showing initiatives status by graphical view by the login base and customer want to see the globally ,how many initiat…
-
Clubbing of SOA Instances while Invoking a web service using BIP reportSummary Clubbing at SOA instance instead of creating new instance while calling a external web service from SaaS BIP report as a Webservice type of BIP report.Content We…
-
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…
-
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…
-
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…
-
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…
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe… -
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…
-
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… -
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 -
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 …
-
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.
-
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…
-
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. …
-
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…