1 Reply Latest reply on Mar 12, 2020 6:10 PM by RameshPatel

XML Publisher bursting issue

3854081 Mar 12, 2020 9:27 AM

Hi Gurus,

I'm trying to do the email bursting in EBS 12.1.3 using XML publisher per each AR invoice to the same email, but no of emails received not the same as number of invoice in the output file.

When i reviewed XML Publisher Report Bursting Program output, refer to the .zip file and get the it from server all the .pdf files are generated.

Following are the details :

1. XML Output

<?xml version="1.0" encoding="UTF-8" ?>

- <XXAR_INV_SEND_MAIL>

<P_TRX_NUMBER />

<P_TRX_DATE_FROM />

<P_TRX_DATE_TO />

<DATA_COUNT>0</DATA_COUNT>

- <LIST_G_PARAMETER>

- <G_PARAMETER>

<REPORT_TITLE>AR Invoice PDF Send Email</REPORT_TITLE>

<REQUEST_ID>14984695</REQUEST_ID>

<REPORT_GENERATION_DATE>2020/03/12</REPORT_GENERATION_DATE>

<REPORT_GENERATION_TIME>17:07:18</REPORT_GENERATION_TIME>

<INVOICE_NUMBER />

<TRX_DATE_FROM />

<TRX_DATE_TO />

</G_PARAMETER>

</LIST_G_PARAMETER>

- <LIST_G_TRX_NUMBER>

- <G_TRX_NUMBER>

<CUSTOMER_TRX_ID>401511</CUSTOMER_TRX_ID>

<TRX_NUMBER>20000003</TRX_NUMBER>

<ENTITY_CODE>SPEID</ENTITY_CODE>

<ALT_CUST_NAME>Tiki Jalur Nugraha Ekakurir, PT</ALT_CUST_NAME>

<CURRENCY_CODE>IDR</CURRENCY_CODE>

<SALES_FORCE_ID />

<TRX_AMOUNT>3852640486</TRX_AMOUNT>

<UPDATE_FLAG>Y</UPDATE_FLAG>

<INSTANCE_NAME>D1</INSTANCE_NAME>

<SMTP_HOST>mysmtp.abc.com</SMTP_HOST>

<SMTP_PORT>25</SMTP_PORT>

<MAIL_FROM>support@abc.com</MAIL_FROM>

<MAIL_TO>salesf@abc.com</MAIL_TO>

<MAIL_CC />

<TEMPLATE_LOC>XXCUS.XXAR_INV_SEND_MAIL.en.00</TEMPLATE_LOC>

</G_TRX_NUMBER>

- <G_TRX_NUMBER>

<CUSTOMER_TRX_ID>466477</CUSTOMER_TRX_ID>

<TRX_NUMBER>20000004</TRX_NUMBER>

<ENTITY_CODE>SPEID</ENTITY_CODE>

<ALT_CUST_NAME>Tiki Jalur Nugraha Ekakurir, PT</ALT_CUST_NAME>

<CURRENCY_CODE>IDR</CURRENCY_CODE>

<SALES_FORCE_ID />

<TRX_AMOUNT>4307322482</TRX_AMOUNT>

<UPDATE_FLAG>Y</UPDATE_FLAG>

<INSTANCE_NAME>D1</INSTANCE_NAME>

<SMTP_HOST>mysmtp.abc.com</SMTP_HOST>

<SMTP_PORT>25</SMTP_PORT>

<MAIL_FROM>support@abc.com</MAIL_FROM>

<MAIL_TO>salesf@abc.com</MAIL_TO>

<MAIL_CC />

<TEMPLATE_LOC>XXCUS.XXAR_INV_SEND_MAIL.en.00</TEMPLATE_LOC>

</G_TRX_NUMBER>

- <G_TRX_NUMBER>

<CUSTOMER_TRX_ID>863330</CUSTOMER_TRX_ID>

<TRX_NUMBER>20002781</TRX_NUMBER>

<ENTITY_CODE>SPEID</ENTITY_CODE>

<ALT_CUST_NAME>SOLUSI PENGIRIMAN INDONESIA, PT</ALT_CUST_NAME>

<CURRENCY_CODE>IDR</CURRENCY_CODE>

<SALES_FORCE_ID />

<TRX_AMOUNT>3351100</TRX_AMOUNT>

<UPDATE_FLAG>Y</UPDATE_FLAG>

<INSTANCE_NAME>D1</INSTANCE_NAME>

<SMTP_HOST>mysmtp.abc.com</SMTP_HOST>

<SMTP_PORT>25</SMTP_PORT>

<MAIL_FROM>support@abc.com</MAIL_FROM>

<MAIL_TO>salesf@abc.com</MAIL_TO>

<MAIL_CC />

<TEMPLATE_LOC>XXCUS.XXAR_INV_SEND_MAIL.en.00</TEMPLATE_LOC>

</G_TRX_NUMBER>

- <G_TRX_NUMBER>

<CUSTOMER_TRX_ID>863366</CUSTOMER_TRX_ID>

<TRX_NUMBER>30003637</TRX_NUMBER>

<ENTITY_CODE>SPEID</ENTITY_CODE>

<ALT_CUST_NAME>DANY DERMAWAN (delcell.id_sbs)</ALT_CUST_NAME>

<CURRENCY_CODE>IDR</CURRENCY_CODE>

<SALES_FORCE_ID />

<TRX_AMOUNT>17054400</TRX_AMOUNT>

<UPDATE_FLAG>Y</UPDATE_FLAG>

<INSTANCE_NAME>D1</INSTANCE_NAME>

<SMTP_HOST>mysmtp.abc.com</SMTP_HOST>

<SMTP_PORT>25</SMTP_PORT>

<MAIL_FROM>support@abc.com</MAIL_FROM>

<MAIL_TO>salesf@abc.com</MAIL_TO>

<MAIL_CC />

<TEMPLATE_LOC>XXCUS.XXAR_INV_SEND_MAIL.en.00</TEMPLATE_LOC>

</G_TRX_NUMBER>

- <G_TRX_NUMBER>

<CUSTOMER_TRX_ID>863365</CUSTOMER_TRX_ID>

<TRX_NUMBER>30003644</TRX_NUMBER>

<ENTITY_CODE>SPEID</ENTITY_CODE>

<ALT_CUST_NAME>Garland Cantik Indonesia, PT</ALT_CUST_NAME>

<CURRENCY_CODE>IDR</CURRENCY_CODE>

<SALES_FORCE_ID />

<TRX_AMOUNT>17796800</TRX_AMOUNT>

<UPDATE_FLAG>Y</UPDATE_FLAG>

<INSTANCE_NAME>D1</INSTANCE_NAME>

<SMTP_HOST>mysmtp.abc.com</SMTP_HOST>

<SMTP_PORT>25</SMTP_PORT>

<MAIL_FROM>support@abc.com</MAIL_FROM>

<MAIL_TO>salesf@abc.com</MAIL_TO>

<MAIL_CC />

<TEMPLATE_LOC>XXCUS.XXAR_INV_SEND_MAIL.en.00</TEMPLATE_LOC>

</G_TRX_NUMBER>

</LIST_G_TRX_NUMBER>

</XXAR_INV_SEND_MAIL>

2. Bursting Output

<?xml version="1.0" encoding="UTF-8" ?>

- <BURS_REPORT>

<PARENT_REQUESTID>14984695</PARENT_REQUESTID>

<REPORT_DESC>SEA AR Invoice PDF Send Email</REPORT_DESC>

<OUTPUT_FILE>/ebs/D1/inst/apps/D1_fn-testap/logs/appl/conc/out/o14984696.zip</OUTPUT_FILE>

- <DOCUMENT_STATUS>

<OUTPUT_TYPE>pdf</OUTPUT_TYPE>

<DELIVERY>email</DELIVERY>

<STATUS>success</STATUS>

<LOG />

</DOCUMENT_STATUS>

- <DOCUMENT_STATUS>

<OUTPUT_TYPE>pdf</OUTPUT_TYPE>

<DELIVERY>email</DELIVERY>

<STATUS>success</STATUS>

<LOG />

</DOCUMENT_STATUS>

- <DOCUMENT_STATUS>

<OUTPUT_TYPE>pdf</OUTPUT_TYPE>

<DELIVERY>email</DELIVERY>

<STATUS>success</STATUS>

<LOG />

</DOCUMENT_STATUS>

- <DOCUMENT_STATUS>

<OUTPUT_TYPE>pdf</OUTPUT_TYPE>

<DELIVERY>email</DELIVERY>

<STATUS>success</STATUS>

<LOG />

</DOCUMENT_STATUS>

- <DOCUMENT_STATUS>

<OUTPUT_TYPE>pdf</OUTPUT_TYPE>

<DELIVERY>email</DELIVERY>

<STATUS>success</STATUS>

<LOG />

</DOCUMENT_STATUS>

</BURS_REPORT>

3. Bursting control file

<?xml version="1.0" encoding="UTF-8"?>

<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">

<xapi:globalData location="stream">

</xapi:globalData >

<xapi:request select="/XXAR_INV_SEND_MAIL/LIST_G_TRX_NUMBER/G_TRX_NUMBER">

<xapi:delivery>

<xapi:email server="${SMTP_HOST}" port="${SMTP_PORT}" from="${MAIL_FROM}" reply-to ="">

<xapi:message id="${CUSTOMER_TRX_ID}" to="${MAIL_TO}" cc="${MAIL_CC}"

attachment="true" content-type="text/html"

subject="EBS ${INSTANCE_NAME} ${ENTITY_CODE} AR INVOICE ${TRX_NUMBER} - ${SALES_FORCE_ID}">

<![CDATA[

<html><head><style type="text/css"> body {font-family:Arial}</style></head>

<body>

Hi,

Please find your attached invoice for :

${ENTITY_CODE} Salesforce Invoice generated in EBS

Customer: ${ALT_CUST_NAME}

Invoice Number: ${TRX_NUMBER}

Invoice Currency: ${CURRENCY_CODE}

Invoice Amount: ${TRX_AMOUNT}

System generated email.

</body></html>]]>

</xapi:message>

</xapi:email>

</xapi:delivery>

<xapi:document key="${CUSTOMER_TRX_ID}" output-type="pdf" delivery="${CUSTOMER_TRX_ID}" output="${TRX_NUMBER}.pdf">

<xapi:template type="rtf" location="xdo://${TEMPLATE_LOC}/?getSource=true" translation=""></xapi:template>

</xapi:document>

</xapi:request>

</xapi:requestset>

Is there anything i missed out here.

Many thanks in advance

Fendy

1. Re: XML Publisher bursting issue

RameshPatel Mar 12, 2020 6:10 PM (in response to 3854081)

here is the bursting file that work for us. check against this to see what you are missing.
<?xml version="1.0" encoding="UTF-8"?>
-<xapi:requestset type="bursting" xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">
-<xapi:request select="/TMP/LIST_G_ORDER_BY/G_ORDER_BY/LIST_G_INVOICE/G_INVOICE">
-<xapi:delivery>
-<xapi:email reply-to="dummy@rail.com" from="dummy@railinc.com" port="25" server="mail.rail.com" id="123">
-<xapi:message id="123" subject="Invoice ${TRX_NUMBER} - ${TRX_DATE} - ${BILL_CUST_NAME}" content-type="text/html" attachment="true" to="${EMAIL}">
-<![CDATA[
<html>
<head>
<style type="text/css">
body {font-family:Georgia}
</style>
</head>
<body>
Dear Sir/Madam,
 
Please find attached is Rail Invoice - ${TRX_NUMBER}
 
Note: The contents of this email are proprietary and confidential.
If you are not the intended recipient, any use of the contents or any copying, distribution or other dissemination is strictly prohibited.
If you received this transmission in error, please immediately email and completely destroy all copies received.
 
Regards, 
Rail
</body>
</html>]]>
</xapi:message>
</xapi:email>
</xapi:delivery>
-<xapi:document delivery="123" output-type="pdf" output="${TRX_NUMBER}_${TRX_DATE}">
<xapi:template type="rtf" location="/oracle/Appl/apps/apps_st/comn/java/classes/Rail_Print_Invoice_Cover_Letter_en_US.rtf"> </xapi:template>
</xapi:document>
</xapi:request>
</xapi:requestset>
Like Show 0 Likes(0)

Actions