ERP - How to stop auto run of a parameterized BI report

When we use parameters in BI report and go all data case, we observe it starts auto running while we just open the report. To avoid this, we simply need to stop the auto run option from properties.

Detailed Steps are below:

ERP - How to create the RTF Template from MSWORD BI publisher

Use case: we will perform the following in the RTF template:

• Show data in tabular format and provide a report name.
• Repeat table header in each page
• Sort data in Ascending order on Invoice Number
• <?sort:INVOICE_NUM;'Ascending'?>
• Show or limit only 5 records per page
• <if:position() mod 5 =0?><xsl:attribute name="break-before">page</xsl:attribute><?end if?>
• Show "NO DATA FOUND" if query does not fetch any data
• <?choose:?><?when:count(INVOICE_NUM) > 0?><?end when?><?otherwise:?>NO DATA FOUND<?end otherwise?><?end choose?>

Detailed steps with screenshots:

Now, my RTF template is ready. Upload it and use.

ERP BI REPORT - XSLT vs BIP Tags | BI publishers

XSLT vs BIP Tags:

• Simple BI Publisher RTF template can be developed with BIP tags. BIP Tags are easier to use even who does not have XML or XSLT experience.
• Behind the scene, BIP tags are translated to XSL code at runtime.
• To develop rich functionality such as Charts, Graps XSLT is used, wizards can be used to define simple charts and graps but to customize the only option is XSLT coding.
• XSLT and BIP Tags can co-exist in the RTF template. Custom functions can be created in XSL template and can be invoked from RTF template.

Example of XSL :

<OrderNum>

  <xsl:value-of select="/Data_DS/G_1/Order_Number"/>

</OrderNum>

<xsl:for-each select="DATA_DS/G_1">

  <SalesOrder>

    <OrderNum>

      <xsl:value-of select="Order_Number"/>

    </OrderNum>

  </SalesOrder>

</xsl:for-each>

Example of BIP tags :

<OrderNum>

  <?/Data_DS/G_1/Order_Number?>

</OrderNum>

<?for-each select="DATA_DS/G_1"?>

  <SalesOrder>

    <OrderNum>

      <?Order_Number?>

    </OrderNum>

  </SalesOrder>

<?end for-each?>

ERP - Create BI reports with Parameters and Dependent LOVs

Usecase: Here, we will create a BI report with parameters and also create dependent LOVs. We will fetch invoice_num,source and description from ap_invoices_all table using p_source and p_inv_num parameters and here, LOV of invoice num will be depended on the parameter p_source.

logic steps:

• Create 2 parameters - p_source and p_inv_num which will be pointing to the following 2 LOVs
• p_source => source_lov
• p_inv_num => inv_num_lov
• Create 2 LOVs where inv_num_lov depended on p_source
• source_lov = select distinct source from ap_invoives_all
• inv_num_lov = select invoice_num from ap_invoices_all where source =:p_source
• Create data set using sql query
• Select invoice_num,source, description from ap_invoices_all where source=nvl(:p_source,source) and invoice_num=nvl(:p_inv_num,invoice_num)
• Create report based on this data model.

Detailed steps with screenshots:

Navigation >> Tools >> Reports and Analytics >> Browse Catalog >> create >> Data Model

Parameters >> Create 2 parameters(initially with text type)

List of Values >> create 2 LOVs,

Parameters >> update paramter type with Menu and select the respective LOVs.

Data sets >> Click + sign >> SQL Query

Provide Name, data source and SQL query.

Click data

Select the source and dependend invoice >> view

Note: if you want to create custom RTF template, export the data. 

Save as sample data >> save data model

Create report

Cancel >> select Data model >> generate RTF

Save the report name

Save Report >> View Report

Test

We can also export data.

Oracle Cloud ERP links

Followig blogs are related to ERP technical activities like BIP/OTBI, ESS, FRS, SmartView etc.

1. ERP BI Roles & Configurations
   
2. Cloud ERP | How to create a simple BI publisher Report | Create an OTBI report
   
3. How to create BI report in Oracle ERP
   
4. ERP - Create BI reports with Parameters and Dependent LOVs
5. Create BI report using eText template
   
1. ERP - Create EText EFT template based BI report | Create etext fixed position based BI Report
2. ERP - Create EDI template based BI report | Create Delimiter based report
6. Create BI report using Excel template
7. Create ERP BI report using RTF Template
8. Create ERP BI report using ETEXT template
9. Create ERP BI report text output using XSL template
10. Create ERP BI report xml output using XSL template
11. Create ERP control file BI report using XSL template
12. ERP BI REPORT - XSLT vs BIP Tags | BI publishers
13. ERP BI Report Migration
14. ERP - BI Report Output | Send to UCM | Send as Email Attachment
15. ERP - How to create RTF template in MS WORD BI Publisher.
16. About ERP BI Bursting
    
17. ERP BI Bursting using FTP delivery channel
18. ERP how to test sql query in OTBI | BI Publishers
    
19. ERP BI Publisher installation and enable add ins the word | RTF template
20. ERP BI sql query to fetch output based on ESS Request History table last run date | Fetch Process start from ESS_Request_history table
21. ERP - How to stop auto run of a parameterized BI report
22. ERP Secure BI report
    
23. Create first ESS job on BI Report | ERP Cloud
    
24. Oracle Cloud ERP - Fix for SQL query time out error in BI reports | How to increase SQL timeout for BI reports
    
25. ERP - About Oracle Payable Invoices
    
26. ERP - Import AP Invoice using FBDI files from ERP scheduled Processes
    
27. Oracle Cloud ERP - Create an Integration user with adequate roles and Priviledges | Assign Required roles to an Integration User
    
28. ERP - Register the CSF key | subscribe to Oracle Fusion Cloud | Subscribe to Fusion Business Events and FBDI Callback
    
29. Oracle Cloud ERP : Missing Scheduled Processes function while creating an integration user
    
30. Oracle Cloud ERP - What are the roles required to create data model in Oracle Fusion
    
31. SOAP UI - ERP - download ESS job output and logs using erpIntegrationService from SOAPUI
    
32. OIC - ERP - BI report bursting using email delivery channel
33. Oracle ERP - Supplier callback BI report SQL query
    
34. SOAP UI - ERP - Run BI report using ExternalReportWSSService from SOAPUI
    
35. ERP Custom folder is not showing under shared folders in reports and analytics section | how to get the shared folders access using permission
    
36. OIC - ERP - Custom callback BI report | What we can do after the FBDI import
    
37. Oracle ERP - Supplier interface, base and error table details.
    
38. Oracle Payable invoice interface, base and error table details.
    
39. Oracle ERP - what roles required to show supplier under procurement section
    
40. Supplier import failed due to supplier type is inactive