1. Implementing Joint Venture Management
  2. Modify the Bursting Definition to Update the Report Delivery Method

Modify the Bursting Definition to Update the Report Delivery Method

This example illustrates how to modify the bursting definition to update the report delivery method from email to file.

  1. Access the Catalog for BI Publisher Enterprise.
  2. In the Folders pane of the Catalog, navigate to the Custom folder and click Financials, Joint Venture Management.
  3. Click the Joint Venture Joint Interest Billing folder to access the data model.
  4. Click Expand below the Data Models folder to open it. It includes the data model for Joint Interest Billing. Click Edit to update this data model.
  5. On the Joint Interest Billing page, navigate to Bursting and click Joint Interest Billing.
    1. The Bursting Query page includes the SQL query on how to split information in the report, the report delivery method, and so on.
    2. The predefined bursting query includes instructions to use Email as the report delivery method. You’ll change the instructions for email to use File as the delivery method.
  6. In the SQL query, search for and select the following code that defines email as the delivery method: 
    case when stake.classification_code = 'ORA_JV_SH_NON_OPERATOR'
 then :P_DELIVERY_METHOD else null end DEL_CHANNEL , case when
 stake.classification_code = 'ORA_JV_SH_NON_OPERATOR' then '
 username@oracle.com' else null end PARAMETER1 , null PARAMETER2,
 case when :P_TEMPLATE_SOURCE = 'ORA_JV_JOINT_VENTURE' and stake.classification_code
 = 'ORA_JV_SH_NON_OPERATOR' and :P_EMAIL_ADDRESS is null then jv.email_address
 when stake.classification_code = 'ORA_JV_SH_NON_OPERATOR' then :P_EMAIL_ADDRESS
 else null end PARAMETER3, case when stake.classification_code =
 'ORA_JV_SH_NON_OPERATOR' then CONCAT( :P_EMAIL_SUBJECT, ' ' ||
 stake.stakeholder_short_name) else null end PARAMETER4, case when
 stake.classification_code = 'ORA_JV_SH_NON_OPERATOR' then :P_EMAIL_BODY
 else null end PARAMETER5, 'true' PARAMETER6, case when :P_TEMPLATE_SOURCE
 = 'ORA_JV_JOINT_VENTURE' and stake.classification_code = 'ORA_JV_SH_NON_OPERATOR'
 then jv.email_address when stake.classification_code = 'ORA_JV_SH_NON_OPERATOR'
 then :P_EMAIL_ADDRESS else null end PARAMETER7
  7. Replace the selected code with the following code that provides instructions to use “File” as the delivery method: 
    :P_DELIVERY_METHOD DEL_CHANNEL, '<file location
 directory>/' PARAMETER1, CONCAT('<user-defined report name>', '<user-defined
 suffix to add to the report name>') PARAMETER2
    Here, PARAMETER1 is the File Directory and PARAMETER2 is the File Name.
  8. Click OK.