Find Fusion table query using OTBI logical query Many a times developers face difficulty to find Fusion ERP table query. This approach can be used to identify underlying Fusion physical query and…
PL SQL block from Fusion BI Report using Procedure Call Fusion BI obviously supports standard SQL to generate report. But for complex scenario where one needs to use PL SQL command, Procedural Call type…
Custom function in Fusion BI report Sometimes there are scenarios when standard SQL in Fusion BI report data set is not sufficient to get relevant information. There could be some…
Oracle Fusion list of seeded reports If you want to know what are the list of seeded or standard reports which are prebuilt in Fusion application, follow below section. Navigate…
Unable to Archive or Unarchive BI report in Oracle Fusion BI When you login to Oracle Fusion, you do not get option to archive or unarchive reports. This is because the user does not has…
Call Web Service From Fusion BI Report Apart from creating Data Set based on Database query, there are other option as well to get data from other sources. Soap Web Service…
Customize Oracle Disbursement Separate Remittance Advice Formats Report This is an Oracle Fusion Payables seeded report for Remittance advice output format against Supplier’s AP invoice payment. Although Oracle provides this standard seeded…
You are creating a template in xslt 1.0, but this template has been built in xslt 2.0 before You may get above error message when you to edit Oracle BI RTF which uses xslt tags in Windows word. By default, BI Publisher…
Oracle Fusion xml data source file for Disbursement Separate Remittance Advice Formats Report This is a seeded report for the Remittance advice output format against Supplier’s AP invoice payment. The delivery of the this report output can…
Oracle BI Desktop Error: Java version has value ‘1.8’, but ‘1.7’ After Oracle BI desktop is installed, you may get above error when you load XML source file and preview the report in any particular…