0 Replies Latest reply on Feb 25, 2014 9:06 AM by Madonna

    XML Bursting Concurrent fails to submit for Standard Receivables Report

    Madonna

      Hi All,

       

           I am trying to implement XML Bursting for the Standard Receivables report- Aging  - 7 Buckets Report . I have created a custom RTF for the report and the report generates the output perfectly.

      When I tried to implement bursting by attaching the Bursting Control file in the Data Definition and by calling Bursting Concurrent in the after report trigger of the rdf the bursting concurrent fails to submit and only the report concurrent completes perfectly.

       

      Here is my Bursting Control file:

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

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

       

      <xapi:request select="/ARXAGMW/LIST_G_SETUP/G_SETUP">

       

      <xapi:delivery>

       

      <xapi:email id="123" server="mail.xyz.com" port="25" from="abc@xyz.com">

      <xapi:message id="123" to="abc@xyz.com"  attachment="true" subject="XX Aging 7 Bucket Report - Test mail">

      Hi,

       

        XX Aging 7 Bucket Report - Test mail

       

      Regards,

      xyz

      </xapi:message>

      </xapi:email>

      </xapi:delivery>

       

      <xapi:document output="XX_Aging_7_Bucket_Report" output-type="pdf" delivery="123">

      <xapi:template type="rtf" location="xdo://XX.XXBDHLARXAGMW.en.00/?getSource=true">

      </xapi:template>

      </xapi:document>

      </xapi:request>

      </xapi:requestset>


      Here is what I have in the after report trigger in my rdf:

      FUNCTION AfterReport

        RETURN BOOLEAN

      IS

        v_req_id NUMBER;

        err    VARCHAR2(4000);

      BEGIN

        BEGIN

        v_req_id := fnd_request.submit_request (application => 'XDO',

                                                                                        program => 'XDOBURSTREP',

                                                                                            description => NULL,

                                                                                         start_time => NULL,

                                                                                      sub_request => FALSE,

                                                                                       argument1 => 'N',

                                                                                       argument2 => :p_conc_request_id,

                                                                                       argument3 => 'Y' -- CHR(0),

                                                                                        );

       

      EXCEPTION

        WHEN OTHERS THEN

          err:= sqlerrm;

          srw.message(100,'exception'|| err);

        END ;

        IF v_req_id = 0 THEN

          srw.message(101,'Failed To submit bursting program ');

        ELSE

          srw.message(102,'request id For Bursting Program is'||v_req_id);

        END IF;

       

       

      SRW.USER_EXIT('FND SRWEXIT');

        RETURN (TRUE);

      END;

       

      I have checked the path  in the Administration->General->Properties  which is /tmp in the xml publisher responsibilty.

       

      When I run the report concurrent this is what it shows in the log file:

      +-----------------------------

      | Starting concurrent program execution...

      +-----------------------------

       

      Arguments

      ------------

      P_REPORTING_LEVEL='1000'

      P_REPORTING_ENTITY_ID='1'

      P_REP_TYPE='ARXAGS'

      p_coaid='50195'

      p_in_sortoption='Customer'

      p_in_summary_option_low='C'

      p_in_format_option_low='D'

      p_in_as_of_date_low='2014/02/25 00:00:00'

      p_in_bucket_type_low='Collections'

      p_credit_option='DETAIL'

      p_risk_option='NONE'

      ------------

       

      Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

       

      APPLLCSP Environment Variable set to :

       

      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

      AMERICAN_INDIA.AL32UTF8

       

      '.,'

       

      Enter Password:

      MSG-00100: will select from ar_system_parameters

      MSG-00100: will call XLA_MO_REPORTING_API

      MSG-00100: Get_Predicate calls complete

      MSG-00103: Done setting Customer Name and Number

      MSG-00100: :p_in_Invoice_type_low

      MSG-00100: :p_in_Invoice_type_high

      MSG-00100: :lp_bal_low

      MSG-00100: :lp_bal_high

      MSG-00100: :LP_ACCT_FLEX_BAL_SEG c.SEGMENT1

      MSG-00100: :p_bal_label Customer Balance:

      MSG-00100: :p_sort_on Customer

      MSG-00100: :p_grand_total All Customers

      MSG-00100: :lp_agfs_where1  and ps.customer_id = cust_acct.cust_account_id  and ps.customer_trx_id = gld.customer_trx_id

      MSG-00100: :lp_agfs_where2  and ps.customer_id = cust_acct.cust_account_id  and ps.customer_trx_id = gld.customer_trx_id

      MSG-00100: :lp_agfs_where3 and ps.customer_id=cust_acct.cust_account_id and ps.customer_trx_id = th.customer_trx_id

      MSG-00100: :lp_agfs_where4  and ps.customer_id = cust_acct.cust_account_id  and ps.customer_trx_id = th.customer_trx_id

      MSG-00100: :lp_aglr_where1

      MSG-00100: :lp_aglr_where3

      MSG-00100: :lp_aglr_where4

      MSG-00100: :lp_aglr_where5

      MSG-00100: :lp_aglr_where6

      MSG-00100: :lp_aglr_where7

      MSG-00100: :lp_aglr_where8

      MSG-00100: :p_org_where_ps  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   ps.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_gld  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   gld.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_SALES AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   sales.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_CT2  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   ct2.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_ADJ  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   adj.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_APP  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   app.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_CRH  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   crh.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_CR  AND ( EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   cr.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_org_where_ADDR AND (acct_site.org_id IS NULL OR EXISTS ( SELECT  /*+ push_subq */ 1 FROM    hr_organization_information org_info WHERE   acct_site.org_id = org_info.organization_id AND     org_info.org_information_context = 'Operating Unit Information' AND org_info.org_information3 = TO_CHAR(1)))

      MSG-00100: :p_short_unid_phrase Unidentified Payme

      MSG-00100: :lp_payment_meaning Payment

      MSG-00100: :lp_risk_meaningRisk

      MSG-01001: will call build_customer_select

      MSG-01001: end call build_invoice_select,common_query_cus=

      MSG-01004: asofdate : 25-FEB-14

      MSG-00101: Failed To submit bursting program

       

       

      kindly guide me in resolving this issue

       

      Thanks and Regards,

      Madonna