2 Replies Latest reply: Mar 28, 2011 7:24 PM by 775773 RSS

    at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.jav

    733009
      Hi ,

      I have the following xml file

      *********
      <dataTemplate name="INTDOMHOLD" defaultPackage="" description="INTDOMHOLD">
      <parameters>
      <parameter name="p_hold" dataType="VARCHAR2" defaultValue=""/>
      </parameters>
      <dataQuery>
      <sqlStatement name="Q1" dataSourceRef=""><![CDATA[SELECT ooh.order_number
                  ,ooh.flow_status_code header_status
                  ,hp.party_name customer_name
                  , ool.line_number ||
                    '.' ||
                    ool.shipment_number line
                  ,ott.NAME line_type
                  ,ool.unit_selling_price expected_price
                  ,ool.flow_status_code line_status
                  ,ool.ordered_item
                  ,'Yes' "Invoiceable Item"
                  ,DECODE( oh.released_flag, 'N', 'Yes', 'No' ) hold_active
                  ,ohd.NAME hold_name
                  ,TO_CHAR( ohs.hold_until_date, 'DD-Mon-YYYY' ) hold_until_date
                  ,TO_CHAR( ohs.hold_until_date, 'DD-Mon-YYYY' ) hold_release_date
                  ,( SELECT rct.trx_number
                      FROM ra_customer_trx_lines_all rcl, ra_customer_trx_all rct
                     WHERE rct.customer_trx_id = rcl.customer_trx_id
                       AND rcl.interface_line_context = 'ORDER ENTRY'
                       AND rcl.sales_order_line = ool.line_number
                       AND rcl.sales_order = ooh.order_number
                       AND rcl.interface_line_attribute2 = 'OKS Billing Order' )invoice
                  ,( SELECT TO_CHAR( rct.trx_date, 'DD-Mon-YYYY' )
                      FROM ra_customer_trx_lines_all rcl, ra_customer_trx_all rct
                     WHERE rct.customer_trx_id = rcl.customer_trx_id
                       AND rcl.interface_line_context = 'ORDER ENTRY'
                       AND rcl.sales_order_line = ool.line_number
                       AND rcl.sales_order = ooh.order_number
                       AND rcl.interface_line_attribute2 = 'OKS Billing Order' ) invoice_date
              FROM oe_order_lines_all ool
                  ,oe_order_headers_all ooh
                  ,oe_order_holds_all oh
                  ,mtl_system_items_b msi
                  ,apps.hz_parties hp
                  ,apps.hz_cust_accounts hca
                  ,apps.hz_cust_acct_sites_all hcas
                  ,apps.hz_cust_site_uses_all hcsu
                  ,oe_transaction_types_tl ott
                  ,oe_hold_sources_all ohs
                  ,oe_hold_definitions ohd
             WHERE ooh.header_id = ool.header_id
               AND ool.org_id = msi.organization_id
               AND ool.ordered_item = msi.segment1
               AND msi.invoiceable_item_flag = 'Y'
               AND ool.flow_status_code IN( 'CLOSED', 'INVOICE_HOLD' )
               AND ool.line_type_id = ott.transaction_type_id
               AND ott.NAME = 'OKS Billing Line'
               AND ool.header_id = 11878
               AND ool.line_id = oh.line_id
               AND ooh.header_id = oh.header_id
               AND oh.hold_source_id = ohs.hold_source_id
               AND ohs.hold_id = ohd.hold_id
               AND oh.released_flag = 'N'
               AND ool.invoice_to_org_id = hcsu.site_use_id(+)
               AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+)
               AND hca.party_id = hp.party_id(+)
               AND hcas.cust_account_id = hca.cust_account_id(+)
               AND hcsu.site_use_code(+) = 'BILL_TO'
               AND ohd.NAME = NVL( :p_hold, ohd.NAME )
      --   AND ohs.hold_until_date = NVL( :p_to_release, ohs.hold_until_date )
               AND NOT EXISTS(
                      SELECT 1
                        FROM ra_customer_trx_lines_all
                       WHERE interface_line_context = 'ORDER ENTRY'
                         AND sales_order_line = ool.line_number
                         AND sales_order = ooh.order_number
                         AND interface_line_attribute2 = 'OKS Billing Line' )
            UNION
            SELECT ooh.order_number
                  ,ooh.flow_status_code header_status
                  ,hp.party_name customer_name
                  , ool.line_number ||
                    '.' ||
                    ool.shipment_number line
                  ,ott.NAME line_type
                  ,ool.unit_selling_price expected_price
                  ,ool.flow_status_code line_status
                  ,ool.ordered_item
                  ,'Yes' "Invoiceable Item"
                  ,DECODE( oh.released_flag, 'N', 'Yes', 'No' ) hold_active
                  ,ohd.NAME hold_name
                  ,TO_CHAR( ohs.hold_until_date, 'DD-Mon-YYYY' ) hold_until_date
                  ,TO_CHAR( ohr.creation_date, 'DD-Mon-YYYY' ) hold_release_date
                  ,( SELECT rct.trx_number
                      FROM ra_customer_trx_lines_all rcl, ra_customer_trx_all rct
                     WHERE rct.customer_trx_id = rcl.customer_trx_id
                       AND rcl.interface_line_context = 'ORDER ENTRY'
                       AND rcl.sales_order_line = ool.line_number
                       AND rcl.sales_order = ooh.order_number
                       AND rcl.interface_line_attribute2 = 'OKS Billing Order' ) invoice
                  ,( SELECT TO_CHAR( rct.trx_date, 'DD-Mon-YYYY' )
                      FROM ra_customer_trx_lines_all rcl, ra_customer_trx_all rct
                     WHERE rct.customer_trx_id = rcl.customer_trx_id
                       AND rcl.interface_line_context = 'ORDER ENTRY'
                       AND rcl.sales_order_line = ool.line_number
                       AND rcl.sales_order = ooh.order_number
                       AND rcl.interface_line_attribute2 = 'OKS Billing Order' ) invoice_date
              FROM oe_order_lines_all ool
                  ,oe_order_headers_all ooh
                  ,oe_order_holds_all oh
                  ,mtl_system_items_b msi
                  ,apps.hz_parties hp
                  ,apps.hz_cust_accounts hca
                  ,apps.hz_cust_acct_sites_all hcas
                  ,apps.hz_cust_site_uses_all hcsu
                  ,oe_transaction_types_tl ott
                  ,oe_hold_sources_all ohs
                  ,oe_hold_definitions ohd
                  ,oe_hold_releases ohr
             WHERE ooh.header_id = ool.header_id
               AND ool.org_id = msi.organization_id
               AND ool.ordered_item = msi.segment1
               AND msi.invoiceable_item_flag = 'Y'
               AND ool.flow_status_code IN( 'CLOSED', 'INVOICE_HOLD' )
               AND ool.line_type_id = ott.transaction_type_id
               AND ott.NAME = 'OKS Billing Line'
               AND ool.header_id = 11878
               AND ool.line_id = oh.line_id
               AND ooh.header_id = oh.header_id
               AND oh.hold_source_id = ohs.hold_source_id
               AND ohs.hold_id = ohd.hold_id
               AND oh.released_flag = 'Y'
               AND ohr.hold_release_id = oh.hold_release_id
               AND ool.invoice_to_org_id = hcsu.site_use_id(+)
               AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+)
               AND hca.party_id = hp.party_id(+)
               AND hcas.cust_account_id = hca.cust_account_id(+)
               AND hcsu.site_use_code(+) = 'BILL_TO'
               AND ohd.NAME = NVL( :p_hold, ohd.NAME )
      --   AND ohr.creation_date = NVL( :p_to_release, ohr.creation_date )
               AND NOT EXISTS(
                      SELECT 1
                        FROM ra_customer_trx_lines_all
                       WHERE interface_line_context = 'ORDER ENTRY'
                         AND sales_order_line = ool.line_number
                         AND sales_order = ooh.order_number
                         AND interface_line_attribute2 = 'OKS Billing Line')]]>
      </sqlStatement>
      </dataQuery>
      <dataStructure>
      <group name="G_ORDER" source="Q1" groupFilter="">
      <element name="ORDER" value="ORDER" function=""/>
      <element name="HEADER_STATUS" value="HEADER_STATUS" function=""/>
      <element name="CUSTOMER" value="CUSTOMER" function=""/>
      <element name="LINE" value="LINE" function=""/>
      <element name="LINE_TYPE" value="LINE_TYPE" function=""/>
      <element name="EXPECTED_PRICE" value="EXPECTED_PRICE" function=""/>
      <element name="LINE_STATUS" value="LINE_STATUS" function=""/>
      <element name="ORDERED_ITEM" value="ORDERED_ITEM" function=""/>
      <element name="HOLD_ACTIVE" value="HOLD_ACTIVE" function=""/>
      <element name="HOLD_NAME" value="HOLD_NAME" function=""/>
      <element name="HOLD_UNTIL_DATE" value="HOLD_UNTIL_DATE" function=""/>
      <element name="HOLD_RELEASE_DATE" value="HOLD_RELEASE_DATE" function=""/>
      <element name="INVOICE" value="INVOICE" function=""/>
      <element name="INVOICE_DATE" value="INVOICE_DATE" function=""/>
      </group>
      </dataStructure>
      </dataTemplate>
      ********

      I am getting the following error

      XDO Data Engine Version No: 5.6.3
      Exception in thread "main" java.lang.NullPointerException
           at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:190)
           at oracle.apps.fnd.cp.request.Run.main(Run.java:161)
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------

      oracle.apps.xdo.oa.cp.JCP4XDODataEngine
      Program exited with status 1

      Please let me know.

      Thanks