Integration

Get Involved. Join the Conversation.

Topic

    Arvind Mathivanan
    Using Dynamic Payloads for SOA Cloud ESS Job Set
    Topic posted September 11, 2019 by Arvind MathivananBronze Medal: 1,250+ Points, tagged Cloud, Integration, PaaS, SOACS 
    30 Views, 3 Comments
    Title:
    Using Dynamic Payloads for SOA Cloud ESS Job Set
    Content:

    We use ESS as part of our SOA Cloud implementation. We have a case where we need to pass dynamic values for one of the field for an ESS Job that is part of a Job Set. Say Order Number is a parameter that I need to dynamically pass for the Job. In the Job Set creation, this field will be null for the Job as it can pull all orders during the schedule. The issue I see is  If I call the Job individually, it allows dynamic values but If I call the Job Set through ESS Web-Service, Even if I pass an order number for the Job, it's ignoring the dynamic value for Order number and only passes the default payload (order number as null) in Job Set. Am I missing something? If this is the expected behavior of Job Set, how would I be able to achieve this scenario?

    Comment

     

    • Kanchankumar Khedkar

      You should be able to pass parameters dynamically to ESS job even if you are executing jobs via web service. 

      <element name="submitESSJobRequest">
      <complexType>
      <sequence>
      <element name="jobPackageName" type="string"/>
      <element name="jobDefinitionName" type="string"/>
      <element maxOccurs="unbounded" minOccurs="0" name="paramList" type="string"/>
      </sequence>
      </complexType>
      </element>

      You should be able to pass the parameters in paramList 

      <paramList>param1</paramList>

      <paramList>param2</paramList>

      <paramList>param3</paramList>

      You should send the parameters in exact the same sequence as defined on job. 

      Hope this helps.

       

       

      • Arvind Mathivanan

        Hi Kanchan,

        Thanks for your reply. Your answer is more for sending dynamic values for an ESS Job. That works perfectly fine through the web-service. But this doesn't work for a Job-Set. The request for Job Set would be as below:

           <EssJobDetailsRequest>
          <description/>
          <application>EssNativeHostingApp</application>
          <requestedStartTime>2019-09-12T21:05:46.991Z</requestedStartTime>
          <jobDefinitionId>
            <name>ARJobSet</name>
            <packageName>/oracle/apps/ess/custom</packageName>
            <type>JOB_SET</type>
          </jobDefinitionId>
          <requestParameters>
            <parameter>
              <dataType>STRING</dataType>
              <name>OMJob.SYS_EXT_invokeMessage</name>
              <scope/>
              <value>
                <![CDATA[<ns1:processRequest xmlns:ns1="http://xmlns.oracle.com/OMApplication/OMProject/XXOM"> 
                       <ns1:BUName>XX</ns1:BUName> 
                       <ns1:InvoiceNumber></ns1:InvoiceNumber> 
                       <ns1:OrderNumber>1234</ns1:OrderNumber> 
                       </ns1:processRequest>]]>
              </value>
            </parameter>
            <parameter>
              <dataType>STRING</dataType>
              <name>ARInvoiceJob.SYS_EXT_invokeMessage</name>
              <scope/>
              <value>
                <![CDATA[<ns1:process xmlns:ns1="http://xmlns.oracle.com/ARApplication/ARProject/BPELProcess1">
          <ns1:BU>XX</ns1:BU>
          <ns1:invoiceNumber></ns1:invoiceNumber>
          <ns1:orderNumber>1234</ns1:orderNumber>
        </ns1:process>]]>
              </value>
            </parameter>
          </requestParameters>
          <EbsRequestID/>
        </EssJobDetailsRequest>

    • Arvind Mathivanan

      I see currently the payload field is getting automatically substituted by the server during execution. Below Doc has details but that should be rectified i feel.

      https://docs.oracle.com/middleware/1221/ess/develop-scheduler/GUID-039FAEE1-2C2C-40B3-9F41-9F343A31C761.htm#ESSDG99987