XML BURSTING STEPS:
- Create a table
- CREATE TABLE xx_managers ( manager_no INTEGER
, manager_name VARCHAR2(200)
, manager_email VARCHAR2(100) ) ;
- SELECT *
FROM xx_managers;
- Create Data Model in Report
.
- Create parameter P_CONC_REQUEST_ID
- Initialize Apps Environment in BeforeReport and AfterReport trigger.
Before Report Trigger:
After Report Trigger:
Fnd_request.submit_request is called from After Report Trigger to submit the Standard Program
(XML Publisher Report Bursting Program)
which is used for sending mails by accessing Busting Control File.
- Save the Report with .rdf(XXAC_BURSTING_TEST.rdf) and move it to custom_top.
6)Create Executable
- Create Concurrent Program.
- Attach Concurrent Program to Request Group
- Run the Concurrent Program and save the XML tags with .xml extension.
- Create Data Definition
- Create the Busting File and save it with “.xml” only
The .rtf Path mentioned in the bursting file should be registered in the temporary Directory of XML Publisher. For the Registered path:
/u02/oracle/IGDEV/apps/apps_st/appl/xbol/12.0.0/datafile
- Move the .rtf to the above mentioned path as shown below.
- Upload the Bursting File in the Bursting Control File section of Data Definition
- Create Template and upload dummy .rtf to it.
- Submit the Report Concurrent Program.
- Mails will be forwarded to the respective person mail ids.
- As we are submitting the program XML Publisher Report Bursting Program through Fnd_request.submit_request
in After Report Trigger,
XML Publisher Report Bursting Program is submitted by taking the report Request_Id as Parameter.
If we don’t submit/Call the Program in After Report Trigger then User has to manually submit the
XML Publisher Report Bursting Program by passing the Request_Id of the Report.
Mails will be forwarded to the respective person mail ids.
LDT’S FOR THE ABOVE REPORT:
XML TEMPLATE
FNDLOAD apps/touchmenot 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct
XXACS_KPI_CLINSERV_TP.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=XBOL DATA_SOURCE_CODE
=XXACS_KPI_CLINSERV
-----------------------------------------------------END of XML BURSTING-----------------------------------------------------------
Standard Program Executable & Conc Prgm (XML Publisher Report Bursting Program):
Different Scenarios in sending mail using XML BURSTING File: Above attached bursting File is used for sending mail
only for single recipient.
- Sending mail to Multiple Recipients:
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/XXAC_BURSTING_TEST/LIST_G_MANAGER_NO/G_MANAGER_NO">
<xapi:delivery>
<xapi:email id="emailToMgrID" server="localhost" port="25" from="vanis@intelligroup.com"
reply-to="vanis@intelligroup.com">
<xapi:message id="emailToMgrID" to="vanis@intelligroup.com, manveshv@intelligroup.com,
Please review the attached list of managers </xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:document output-type="pdf" delivery="emailToMgrID">
<xapi:template type="rtf" location="/u02/oracle/IGDEV/apps/apps_st/appl/xbol/12.0.0/datafile/XXAC_BURSTING_TEST.rtf">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
- Sending Mail using Multiple Templates to Multiple Recipients:
- <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
- <xapi:email id="emailToMgrID" server="localhost" port="25" from="manu@oracle.com" reply-to="manu@microsoft.com">
<xapi:message id="emailToMgrID" to="vanis@intelligroup.com; manveshv@intelligroup.com" attachment="true"
subject="Employee Information">Dear ${ENAME}, Please find your salary details as an attachment. Regards,
Manvesh</xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:template type="rtf" location="/u02/oracle/IGDEV/apps/apps_st/appl/xconv/12.0.0/temp/XXXX_EMPLOYEES1.rtf" />
</xapi:document>
</xapi:request>
- <xapi:email id="emailToMgrID" server="localhost" port="25" from="manu@oracle.com" reply-to="manu@microsoft.com">
<xapi:message id="emailToMgrID" to="vanis@intelligroup.com" attachment="true" subject="Department Summary
for ${DEPTNO1}">Please review the attached Department Summary for department ${DEPTNO1} </xapi:message>
</xapi:email>
</xapi:delivery>
<xapi:template type="rtf" location="/u02/oracle/IGDEV/apps/apps_st/appl/xconv/12.0.0/temp/XXXX_MANAGERS.rtf" />
</xapi:document>
</xapi:request>
</xapi:requestset>
No comments :
Post a Comment