1 Reply Latest reply: Oct 2, 2011 1:53 AM by Anoop Sukumaran RSS

    javax.mail.internet.ParseException while busrting report using control file

    783200
      Hi everyone...

      I am trying to run a concurrent program that will burst emails using a control file.
      In the data definition i want to use few parameters whose values will be passed from concurrent program.In the data definition i am calling an after report trigger function which will fire the seeded email bursting program.

      My data definition file sample:
      ?xml version="1.0" encoding="UTF-8" ?>
      <dataTemplate name="dataTemplateName" description="Template description" defaultPackage="BIREPORTBURSTINGAK_PKG" version="1.0">
      <parameters>
      <parameter name="P_NAME" dataType="varchar"/>
      </parameters>
      <dataQuery>
      <sqlStatement name="Q1">
      <![CDATA[
      select
           emp_Id "EmployeeId"
           ,emp_Name "EmployeeName"
           ,emp_Dept "Department"
           ,emp_Org "Organization"
           ,emp_Email "Email"
           ,emp_salary "Salary"
           --,emp_Phone "Phone"
           from reportSample_AK
           where emp_name=:P_NAME
      ]]>
      </sqlStatement>
      </dataQuery>
      <dataTrigger name="afterReportTrigger" source="BIREPORTBURSTINGAK_PKG.afterReportTrigger(:P_NAME)" />
      <dataStructure>
      <group name="G_EMPLOYEE" source="Q1">
      <element name = "EMPID" value="EmployeeId"/>
      <element name = "ENAME" value="EmployeeName"/>
      <element name = "DEPT" value="Department"/>
      <element name = "ORG" value="Organization"/>
      <element name = "EMAIL" value="Email"/>
      <element name = "SAL" value="Salary"/>
      --<element name = "PHONE" value="Phone"/>
      </group>
      </dataStructure>
      </dataTemplate>

      my control file:

      <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">
      <xapi:request select="/DATATEMPLATENAME/LIST_G_EMPLOYEE/G_EMPLOYEE">
      <xapi:delivery>
      <xapi:email id="123" server="agni.bangalore.bedford.local" port="25" from="anupamakarote01@rediffmail.com" reply-to="anupamakarote01@rediffmail.com">
      <xapi:message id="123" to="${EMAIL}" attachment="true" subject=" Dear: ${ENAME}">
      Please review the attachment .
      Regards,Anupama karote
      </xapi:message>
      </xapi:email>
      </xapi:delivery>
      <xapi:document output-type="pdf " delivery="123">
      <xapi:template type="rtf" location="/usr/tmp/TESTMAIL_AK.rtf" filter=".//LIST_G_EMPLOYEE">
      </xapi:template>
      </xapi:document>
      </xapi:request>
      </xapi:requestset>

      my package deatils:

      create or replace package BIREPORTBURSTINGAK_PKG
      As
      P_NAME varchar2(16);
      Function Afterreporttrigger(P_NAME varchar2) Return Boolean;
      end biReportBurstingAK_pkg;

      create or replace package body BIREPORTBURSTINGAK_PKG AS
      Function Afterreporttrigger(P_NAME varchar2) Return Boolean
      is
      v_request_id NUMBER;
      BEGIN
      v_request_id := fnd_request.submit_request('XDO'
      ,'XDOBURSTREP'
      ,NULL
      ,NULL
      ,FALSE
      ,'N'
      ,TO_CHAR(fnd_global.conc_request_id)
      ,'Yes'
      );
      return true;
      End Afterreporttrigger;
      end biReportBurstingAK_pkg;

      i have created data definition and template and attched it to the concurrent program via bi publisher.

      While running the main concurrent program i am getting the following error:
      create or replace package BIREPORTBURSTINGAK_PKG
      As
      P_NAME varchar2(16);
      Function Afterreporttrigger(P_NAME varchar2) Return Boolean;
      end biReportBurstingAK_pkg;

      create or replace package body BIREPORTBURSTINGAK_PKG AS
      Function Afterreporttrigger(P_NAME varchar2) Return Boolean
      is
      v_request_id NUMBER;
      BEGIN
      v_request_id := fnd_request.submit_request('XDO'
      ,'XDOBURSTREP'
      ,NULL
      ,NULL
      ,FALSE
      ,'N'
      ,TO_CHAR(fnd_global.conc_request_id)
      ,'Yes'
      );
      return true;
      End Afterreporttrigger;
      end biReportBurstingAK_pkg;



      Any help is greatly appreciated.


      Regards,