Calling of subtemplate from Main template in BI Publisher in Oracle Fusion

 Sometimes there are requirement where header and footer are changing and rest content/body of template is same.

For example there are multiple addresses for any parent company.

In that case we can create subtemplate and call that subtemplate in parent template.

Creating Subtemplate:

In RTF template , do below

<?template:MyAddressUS?>
My Company
500 Main Street
Any City, CA 98765
<?end template?>                                                                    

?template:MyAddressIndia?>
My Company
500 Main Street
India
<?end template?>    

Now we can save that template in fusion, Go to oracle fusion

its extension will be .xsb

Now we need to call that template in our main template, 
wherever we want to call in the main template

Calling of Subtemplate from Main template:
In the Main template enter the following import statements in the form field or directly
anywhere in the template.

<?import:xdoxsl:///Customer Reports/Templates/Sub_Template_Address_XXX.xsb?>
In Main template where you want to show that address, use below Call command
<?call-template:MyAddressUS?>
At runtime, parent template will take care of those path.
To handle parameterized layout , use below command
In the RTF template define a parameter using syntax - 
<?param@begin:ParameterName?>
For example:
<?param@begin:DeptName?>

Happy Learning . 

How to send mail in CC in BIP bursting query

 We can use Parameter2 for sending mail in CC.

But if you want to give access to user for the same then create a lookup and define emails in "DESCRIPTION" of that lookup. 

for example :

abc@gmail.com,def@gmail.com, cef@gmail.com

and call that lookup in BI bursting query . 

It will work 

   (Select description from fnd_lookups where lookup_type='XXX EMAIL CC INV PRINT' and rownum=1)   PARAMETER2,

How to send external attachment with invoices in Oracle Fusion

 Please follow the below steps and retry running the Print Receivables job after.

Please pass the following SQL Query in the Transaction Delivery Bursting > Attachment tab.
Attachment Repository = FA_UCM_PROVISIONED

SQL Query: 
-----------------
SELECT del.customer_trx_id || '_' || del.payment_schedule_id AS "KEY",
doc.DM_VERSION_NUMBER AS "ATTACHMENT_ID"
FROM AR_BPA_DELIVERY_DETAILS del,
fnd_attached_documents att,
FND_DOCUMENTS_VL doc
WHERE att.entity_name = 'RA_CUSTOMER_TRX_ALL'
AND att.pk1_value = TO_CHAR(del.CUSTOMER_TRX_ID)
AND doc.DOCUMENT_ID =att.DOCUMENT_ID
AND att.Category_Name IN
(SELECT Lookup_Code
FROM Fnd_Lookups
WHERE LOOKUP_TYPE = 'AR_PRINT_ATTACHMENT_CATEGORIES'
AND ENABLED_FLAG = 'Y'
AND (TRUNC(SYSDATE) BETWEEN nvl(Start_Date_Active,TRUNC(SYSDATE)) AND nvl(End_Date_Active,TRUNC(SYSDATE)))
)

The Print Receivables Transactions process prints transaction attachments that satisfy the following criteria:

• The transaction delivery method is Paper or Email.
• The attachment is in PDF format.
• The attachment is attached to the transaction header.
• The attachment category is defined as an active lookup code of the AR_PRINT_ATTACHMENT_CATEGORIES lookup type (Categories of Attachments to be Printed).