BI Publisher (MOSC)

MOSC Banner

Bursting Job is not kicking off

edited Aug 28, 2019 10:33AM in BI Publisher (MOSC) 17 commentsAnswered

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 *

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center