XML bursting interview questions
In this post , We will be discuss about XML bursting interview questions. I will share the most important XML bursting interview questions , which do frequently asked in oracle apps technical interviews. XML bursting interview questions are mostly related to the Bursting process in oracle. Here below is the detail about XML bursting interview questions.
Most Important XML bursting interview questions
1. Whats the standard Program to execute the 'XML Publisher Report Bursting Program'.
Answers : Put in the "XML Publisher Report Bursting Program" request id Parameter as below.
This will Fire the XML bursting for this Concurrent Program request Output.
2. What is Bursting Control file ?
This is the one Sample of the XML bursting control file .
Important Objects of XML bursting control file
1.<xapi:request> This tag decide in the bursting control file that concurrent request output will split based on which group.
For Example I have one RDF of Customer Invoice which have to reports Group (XX_CUSTOMER and then XX_CUST_INVOICE).
Now I only want to send only one Email for Each Customer then I will use
<xapi:request select="/XX_REPORT_NAME/XX_CUSTOMER">
But if I want to send Email for Each Invoice then I will use
<xapi:request select="/XX_REPORT_NAME/XX_CUSTOMER/XX_CUST_INVOICE">
You can also this
"/XX_REPORT_GROUP1/XX_REPORT_GROUP2/XX_REPORT_GROUP3" grouping idea from your Concurrent Program XML output. GO to Concurrent Request of the Concurrent Program and View the Output in XML. You can get the idea from there about all reports xml groups names and you can use these names in the Bursting Control File <xapi:request> tag.
3. What is <xapi:email> in Control file ?
<xapi:email> This Tag is uses for the SMTP server configuration which will be used by bursting program to sent emails. Here we store SMTP server name , SMTP port, From Email address and reply_to address etc.
4. What is <xapi:message> in Control file ?
<xapi:message> This tags decide email will go to which recipients (to and cc email addresses) and we can also design the Email body of the XML bursting email Notifications.
5. What is <xapi:template> in Control file ?
6. How to Debug the XML bursting process if bursting not sending email ?
Step 1. We need to Check First "XML Publisher Report Bursting Program". This program executes the XML bursting in Oracle Apps. We pass Request Id of the Concurrent request as parameter to this program to run bursting for that request.
8. How to use Bursting FTP to send report output to ftp server in Oracle apps r12 ?
<?xml version="1.0" encoding="UTF-8" ?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/XXGL_GLAEE_DEPT">
<xapi:delivery>
<xapi:ftp id="sftp_delivery" server="usmtnz-dzzzdb06.dev.emrsn.org" user="ecort1" password="et1817086" remote-directory="/ftpdata/elenat1/cor/ascent/error" remote-file="test.pdf" secure-ftp="TRUE"/>
</xapi:delivery>
<xapi:document output="Report Outname name V1" output-type="pdf" delivery="sftp_delivery">
<xapi:template type="rtf" location="xdo://XXGL.XXGL_GLAEE_DEPT.en.00/?getSource=true">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
3. What is <xapi:email> in Control file ?
<xapi:email> This Tag is uses for the SMTP server configuration which will be used by bursting program to sent emails. Here we store SMTP server name , SMTP port, From Email address and reply_to address etc.
4. What is <xapi:message> in Control file ?
<xapi:message> This tags decide email will go to which recipients (to and cc email addresses) and we can also design the Email body of the XML bursting email Notifications.
5. What is <xapi:template> in Control file ?
<xapi:template> This tags decide the RTF template in which XML output will loaded from Concurrent request to send as a attachment in the Busting Email notifications.
6. How to Debug the XML bursting process if bursting not sending email ?
Step 1. We need to Check First "XML Publisher Report Bursting Program". This program executes the XML bursting in Oracle Apps. We pass Request Id of the Concurrent request as parameter to this program to run bursting for that request.
We need to ensure that "XML Publisher Report Bursting Program" should be complete normal or warning but not in error for the given Concurrent request.
Step2. IF the "XML Publisher Report Bursting Program" not completed normal then we need to analyze the Log of this Program. As per oracle recommendation , We need to run this program with Debug Flag "Yes" for the same Concurrent Request Id as below.
Analyze the Log of this Program. We can easily get the status of each Email Address in the Log "Failed Or Success".
If its Status again email address is Failed , Then ensure that you are using the Valid Email address for bursting.
Step4:- Validate the Internal SMTP server details which are using in the Bursting Control File. Might be some recent changes happened in your SMTP account which you need to take care in the Busting file too as highlighted below.
7. How to send XML bursting for multiple email address ?
We need to design the XML bursting file with that syntax to accommodate multiple email addresses.
8. How to use Bursting FTP to send report output to ftp server in Oracle apps r12 ?
<?xml version="1.0" encoding="UTF-8" ?>
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
<xapi:request select="/XXGL_GLAEE_DEPT">
<xapi:delivery>
<xapi:ftp id="sftp_delivery" server="usmtnz-dzzzdb06.dev.emrsn.org" user="ecort1" password="et1817086" remote-directory="/ftpdata/elenat1/cor/ascent/error" remote-file="test.pdf" secure-ftp="TRUE"/>
</xapi:delivery>
<xapi:document output="Report Outname name V1" output-type="pdf" delivery="sftp_delivery">
<xapi:template type="rtf" location="xdo://XXGL.XXGL_GLAEE_DEPT.en.00/?getSource=true">
</xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
XML bursting interview questions
0 comments:
Post a Comment