Letter Generation from Oracle Fusion

 Overview:

Documents are an essential part of our life and it plays a vital role for any organization. Documents are been consider as one of the standard ways to communicate with your employees or candidates. In Oracle Fusion BI reports. We can create a standard custom template report through which we can input the values and the report or letter can be directly sent from the system.

I am creating a Standard Appointment Letter for the candidates. Here I will be having few parameters in which data will be entered, once the report is generated and verified it will be sent to the candidate email address.

Since the data is not present in the Fusion system we are using parameters.

Process flow:

Step 1:  Navigate to Tools>>Reports and Analytics>>Browse Catalog>>New>>Data Model

Here in the query we are going to bursting and all the Parameters values are shown and explained below-

·       Template name can be kept as per the requirement.

·       Locale will be English (en), output format as PDF and the delivery channel as email.

·       In the Parameter1 – Candidate email address this will consider as To Email address.

·       In the Parameter3 – From Email address.

·       In the Parameter4 – Subject, here I have given template name and candidate’s name.

·       In the Parameter5 – We can give the Message Body.

·       In the Parameter6 – Since we are attaching and attachment the value will be true.

·       Since we are using bursting it needs a distinct Key. So here I am using a active employees person number.

·       Using necessary parameters as per the requirement.

Step 2: Paste the query in the data model and select all the parameters.                    

 

Step 3: Give necessary data type and display label.

Step 4: Run the report and Save the sample data and Export it.

Step 5: Load the XML and fields in the RTF template as per the requirement.

Step 6: Upload the RTF template and create a report. As shown below.

Left side where all the values will be entered.

 

Step 7: Once values are entered select the apply button and verify the document.

Step 8: After viewing the PDF, select the Action button >> Send. As shown below –

Step 9: You will be able to see the final view of parameters in order to reconfirm.

Step 10: Select the Notification tab and you can give your official email address. In case the mail is not triggered due to any error, the reason will be shared in the given email.

Step 11: Select Submit and give Report Job Name. This Report Job Name will be used to track any error occurred while the process.

The Report Job Name can be Candidate’s name.

Finally, click on Ok.

Creds: Samarpan Das