Bursting Job is not kicking off
Hi All,
I'm working on creating a XML publisher report. The main xml program is completing normal but the bursting is kicking off and more over when we click the "View Output" tab the excel which is supposed to burst and come as email is opening in Output tab.
<?xml version="1.0" encoding="UTF-8"?><!-- Begin Data Template --><dataTemplate version="1.0" description="Primary Source PAL Balance" defaultpackage="XXPQ_PRM_SOURCE_PAL_BAL" name="XXPQ_PRM_SOURCE_PAL_BAL"><properties><property name="xml_tag_class" value="upper"/><property name="include_parameters" value="true"/></properties><!-- Enter Parameters --><parameters><parameter name="P_END_DATE" dataType="date"/></parameters><!-- Enter Lexicals --><lexicals> </lexicals><!-- Enter SQL Query --><dataQuery><sqlStatement name="PAL_BALANCE_DETAIL"><![CDATA[ select account_number, account_name, contract_no, start_date, end_date, plan, sum(sub_amount) sub_amount, sum(original_pal_amount) original_pal_amount, sum(used_pal_amount) used_pal_amount, sum(original_pal_amount + used_pal_amount) balancefrom (select invoice_no, invoice_date, account_number, account_name, contract_no, start_date, end_date, item, ps_type, plan, round(decode(ps_type,'SUB',accounted_value,0),2) sub_amount, round(decode(ps_type,'PAL SHELL',accounted_value,0),2) original_pal_amount, round(decode(ps_type,'PAL OFFSET',accounted_value,0),2) used_pal_amountfrom (select trx.trx_number invoice_no, trx.trx_date invoice_date, trxln.creation_date, trxln.interface_line_attribute1 contract_no, to_char(to_date(trxln.interface_line_attribute4,'YYYY/MM/DD')) start_date, to_char(to_date(trxln.interface_line_attribute5,'YYYY/MM/DD')) end_date, stca.account_number, stca.account_name, psi.item, psi.primary_source_type ps_type, decode(substr(psi.primary_source_category,1,3),'PSA','PLAN A','PSB','PLAN B','OTHER PLAN') plan, (trxln.extended_amount *