Step 1: Create XML Data Template
<?xml version=”1.0″ encoding=”UTF-8″ ?>
<dataTemplate name=”AP_INVOICE_DETAILS” description=”AP_INVOICE_DETAILS” version=”1.0″>
<properties>
<property name=”xml_tag_case” value=”upper”/>
<property name=”Include_Parameters” value=”True”/>
</properties>
<parameters>
<parameter name=”P_VENDOR_ID” dataType=”NUMBER”/>
<parameter name=”P_INVOICE_NUM” dataType=”CHARACTER”/>
<parameter name=”P_ORG_ID” dataType=”NUMBER”/>
</parameters>
<dataQuery>
<sqlStatement name=”INVQ”>
<![CDATA[SELECT
aia.invoice_id,
aia.invoice_num,
aia.invoice_currency_code,
aia.invoice_amount,
aia.payment_currency_code,
ap.vendor_name,
aia.org_id,
aps.vendor_site_id,
aps.vendor_site_code
FROM
apps.ap_invoices_all aia,
apps.ap_suppliers ap,
apps.ap_supplier_sites_all aps
WHERE
aia.vendor_id = ap.vendor_id
AND aps.vendor_site_id = aia.vendor_site_id
AND ap.vendor_id = aps.vendor_id
AND aia.vendor_id =:p_vendor_id
AND aia.invoice_num = nvl(:p_invoice_num,aia.invoice_num)
AND aia.org_id = nvl(:p_org_id,aia.org_id)]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name=”G_INVQ” source=”INVQ”>
<element name=”INVOICE_ID” value=”INVOICE_ID”/>
<element name=”INVOICE_NUM” value=”INVOICE_NUM”/>
<element name=”INVOICE_CURRENCY_CODE” value=”INVOICE_CURRENCY_CODE”/>
<element name=”INVOICE_AMOUNT” value=”INVOICE_AMOUNT”/>
<element name=”PAYMENT_CURRENCY_CODE” value=”PAYMENT_CURRENCY_CODE”/>
<element name=”VENDOR_NAME” value=”VENDOR_NAME”/>
<element name=”ORG_ID” value=”ORG_ID”/>
<element name=”VENDOR_SITE_ID” value=”VENDOR_SITE_ID”/>
<element name=”VENDOR_SITE_CODE” value=”VENDOR_SITE_CODE”/>
</group>
</dataStructure>
</dataTemplate>
Step 2: XML File Structure
<?xml version=”1.0″ encoding=”UTF-8″?>
<AP_INVOICE_DETAILS>
<P_VENDOR_ID>11</P_VENDOR_ID><P_INVOICE_NUM></P_INVOICE_NUM><P_ORG_ID></P_ORG_ID>
<LIST_G_INVQ>
<G_INVQ>
<INVOICE_ID>18742</INVOICE_ID>
<INVOICE_NUM>.1/2000</INVOICE_NUM>
<INVOICE_CURRENCY_CODE>ITL</INVOICE_CURRENCY_CODE>
<INVOICE_AMOUNT>0</INVOICE_AMOUNT>
<PAYMENT_CURRENCY_CODE>EUR</PAYMENT_CURRENCY_CODE>
<VENDOR_NAME>Advantage Corp</VENDOR_NAME>
<ORG_ID>1017</ORG_ID>
<VENDOR_SITE_ID>984</VENDOR_SITE_ID>
<VENDOR_SITE_CODE>ADV. FR INTRA</VENDOR_SITE_CODE>
</G_INVQ>
Step 3: Create Bursting Control File
Bursting is defined in a separate XML file called Bursting Control File.
<?xml version=”1.0″ encoding=”UTF-8″?>
<xapi:requestset xmlns:xapi=”http://xmlns.oracle.com/oxp/xapi” type=”bursting”>
<xapi:request select=”/AP_INVOICE_DETAILS/LIST_G_INVQ/G_INVQ”>
<xapi:delivery>
<xapi:filesystem id = “FILE_DELIVERY” Output=”//u01/install/APPS/fs2/EBSapps/appl/ap/12.0.0/reports/${G_INVQ}_rep.pdf”/>
<xapi:delivery>
<xapi:document output-type=”pdf” delivery= “FILE_DELIVERY”>
<<xapi:template type=”RTF”location=”XDO://SQLAP.XXAPINVDEATILSRPT.en.US/?getSource=true”/>
</xapi:document>
</xapi:request>
</xapi:requestset>
This XAPI: requestset is default standard format we should not change anything in the file
<xapi:requestset xmlns:xapi=”http://xmlns.oracle.com/oxp/xapi” type=”bursting”>
XAPI: requestset under the tag we add the name as per the xml file
In the xml file Group name: Ap_invoice_details
List group name: List_G_INVQ
Source name: G_INVQ
<xapi:request select=”/AP_INVOICE_DETAILS/LIST_G_INVQ/G_INVQ”>
In the filesystem name tag output tag use this standard default path in the last add the source name G_INVQ it should be the same.
<xapi:delivery>
<xapi:filesystem id = “FILE_DELIVERY” Output=”//u01/install/APPS/fs2/EBSapps/appl/ap/12.0.0/reports/${G_INVQ}_rep.pdf”/>
<xapi:delivery>
XAPI: document under the delivery tag give the “file delivery” is should same name.
XAPI: template type = “RTF” location is xml publisher and use application name and SHORTCODE of Data Definition name.
Once you complete the bursting file attach in the Data Definition Using EBS Application.
<xapi:document output-type=”pdf” delivery= “FILE_DELIVERY”>
<<xapi:template type=”RTF”location=”XDO://SQLAP.XXAPINVDEATILSRPT.en.US/?getSource=true”/>
</xapi:document>
</xapi:request>
</xapi:requestset>
STEP4: Creation the folder in the WINSCP
Create the folder under the standard path /u01/install/APPS/fs2/EBSapps/appl/ap/12.0.0/reports/US
STEP5: Attach the Bursting in the Data Definition
Navigation of XML Publisher Administrator:
Go to the XML Publisher Administrator
Click the Data Definition
Attach the Bursting file under the Bursting control file folder.
Navigation of View Request:
Go to Payables Vision Operations (USA)
Select View
Click the Request
Submitting a new request.
Give Concurrent Program name: XXAP Invoice Details Report
Enter the Parameter Value click the Submit Button
Once Submit the request the program gets ends with complete normal and Output has generated.
Run the concurrent program XML Publisher Report bursting Program
Enter the Request id :7928632 and give the submit button
The Program will End with Completed normal the output file generated in the WINSCP folder respective path: /u01/install/APPS/fs2/EBSapps/appl/ap/12.0.0/reports/US
