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

    XML Publisher bursting issue

    3854081

      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>

       

       

      <REQUESTID>14984696</REQUESTID>

       

       

      <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>

       

       

      <KEY>401511</KEY>

       

       

      <OUTPUT_TYPE>pdf</OUTPUT_TYPE>

       

       

      <DELIVERY>email</DELIVERY>

       

       

      <OUTPUT>/usr/tmp/D1/031220_050737873/20000003.pdf</OUTPUT>

       

       

      <STATUS>success</STATUS>

       

       

      <LOG />

       

      </DOCUMENT_STATUS>

       

      - <DOCUMENT_STATUS>

       

       

      <KEY>466477</KEY>

       

       

      <OUTPUT_TYPE>pdf</OUTPUT_TYPE>

       

       

      <DELIVERY>email</DELIVERY>

       

       

      <OUTPUT>/usr/tmp/D1/031220_050737873/20000004.pdf</OUTPUT>

       

       

      <STATUS>success</STATUS>

       

       

      <LOG />

       

      </DOCUMENT_STATUS>

       

      - <DOCUMENT_STATUS>

       

       

      <KEY>863330</KEY>

       

       

      <OUTPUT_TYPE>pdf</OUTPUT_TYPE>

       

       

      <DELIVERY>email</DELIVERY>

       

       

      <OUTPUT>/usr/tmp/D1/031220_050737873/20002781.pdf</OUTPUT>

       

       

      <STATUS>success</STATUS>

       

       

      <LOG />

       

      </DOCUMENT_STATUS>

       

      - <DOCUMENT_STATUS>

       

       

      <KEY>863366</KEY>

       

       

      <OUTPUT_TYPE>pdf</OUTPUT_TYPE>

       

       

      <DELIVERY>email</DELIVERY>

       

       

      <OUTPUT>/usr/tmp/D1/031220_050737873/30003637.pdf</OUTPUT>

       

       

      <STATUS>success</STATUS>

       

       

      <LOG />

       

      </DOCUMENT_STATUS>

       

      - <DOCUMENT_STATUS>

       

       

      <KEY>863365</KEY>

       

       

      <OUTPUT_TYPE>pdf</OUTPUT_TYPE>

       

       

      <DELIVERY>email</DELIVERY>

       

       

      <OUTPUT>/usr/tmp/D1/031220_050737873/30003644.pdf</OUTPUT>

       

       

      <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>          

      <p>

      Hi,<br><br>

      Please find your attached invoice for :<br><br>

      ${ENTITY_CODE} Salesforce Invoice generated in EBS<br><br>

      Customer: ${ALT_CUST_NAME}<br>

      Invoice Number: ${TRX_NUMBER}<br>

      Invoice Currency: ${CURRENCY_CODE}<br>

      Invoice Amount: ${TRX_AMOUNT}<br><br>

      System generated email.<br>

      </p>

      </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

          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,

          <br>

          Please find attached is Rail Invoice - ${TRX_NUMBER}

          <br><br>

          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.

          <br><br>

          Regards,<br>

          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>