Announcement

Collapse
No announcement yet.

Auto Plan Release From XML

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Auto Plan Release From XML

    I am trying to send in an Order Release, via xml integration, and I want the OR to automatically Plan.

    I know this is possible From sending in an OB with a Processing Code of PLN..

    Is there a way to Plan the OR Automatically?

    Thanks
    Gary
    Regards
    Gary Cunningham
    www.cbmc.co.uk
    www.mavenwire.com

  • #2
    Re: Auto Plan Release From XML

    Gray ,

    An agent can help you out .

    You can create an agent which creates a Buy shipment or sell shipment once the OR is created .

    Rgd
    kishore

    Comment


    • #3
      Re: Auto Plan Release From XML

      Thanks for the suggestion - I already knew about the Agent Workflow solution though.

      I was looking for something that is put into the XML

      For those interested... I now have the solution..

      Just add the following element to the bottom of your OR xml..

      <GLogXMLElement>
      <Topic>
      <TopicAliasName>BuildBuySideShipments</TopicAliasName>
      <TopicArg>
      <TopicArgName>savedQuery</TopicArgName>
      <TopicArgValue>NEWORDERRELEASE</TopicArgValue>
      </TopicArg>
      </Topic>
      </GLogXMLElement>

      Gary
      Regards
      Gary Cunningham
      www.cbmc.co.uk
      www.mavenwire.com

      Comment


      • #4
        Re: Auto Plan Release From XML

        Hi,

        I understand that NEWORDERRELEASE is a SAVED QUERY'S name.
        Can you kindly share the SQL query which you have written for NEWORDERRELEASE.

        Regards,
        njoyotm

        Comment


        • #5
          Re: Auto Plan Release From XML

          The saved query we used is..

          SELECT ORL.ORDER_RELEASE_GID
          FROM ORDER_RELEASE ORL,
          ORDER_RELEASE_STATUS ORLS
          WHERE ORL.ORDER_RELEASE_GID = ORLS.ORDER_RELEASE_GID
          AND ORLS.STATUS_TYPE_GID = '<DOMAIN_NAME>.PLANNING'
          AND ORLS.STATUS_VALUE_GID = '<DOMAIN_NAME>.PLANNING_NEW'
          AND TRUNC(ORL.INSERT_DATE)=TRUNC(SYSDATE)

          You may wish to extend this to remove the necessity of specifying a Domain Name

          Gary
          Regards
          Gary Cunningham
          www.cbmc.co.uk
          www.mavenwire.com

          Comment


          • #6
            Re: Auto Plan Release From XML

            Hi Gary,

            Thank you very sincerely.
            The XML works as expected.
            Can you suggest me other possible TopicAliasName other than BuildBuySideShipments,
            BuildSellSideShipments?

            Regards,
            njoyotm

            Comment


            • #7
              Re: Auto Plan Release From XML

              Hi all,

              The below are the inbuilt TOPIC ALIAS NAME:

              CreatBufferOrder
              TenderResponse
              PlannedShipmentCreated
              ShipmentReadyForRetender
              TenderWithdrawn
              ShipmentReadyForExecution
              ShipmentReadyForExecutionAndTransport
              ShipmentReadyForTransport
              ShipmentStatus
              ShipmentTracking
              TimerTick
              Mail
              Fax
              BulkRating

              Thanks and Regards,
              njoyotm

              Comment


              • #8
                Can somebody tell me possible <TopicArgName> that we configure in the XML? We are currently raising an custom order release agent from this xml, I want to know if we can specify somewhere on this xml to raise the process on specific server on the OTM( For e.g On FAILOVER/BULKPLAN Server instead of DEFAULT Server). This is the xml we currently using -

                <Topic>
                <TopicAliasName>glog.server.workflow.lifetime.orde r.CustomOrderReleaseEvent</TopicAliasName>
                <TopicArg>
                <TopicArgName>release</TopicArgName>
                <TopicArgValue>1033363689-SMS</TopicArgValue>
                </TopicArg>
                <TopicArg>
                <TopicArgName>dataSource</TopicArgName>
                <TopicArgValue>INTEGRATION</TopicArgValue>
                </TopicArg>
                <TopicArg>
                <TopicArgName>agentEvent</TopicArgName>
                <TopicArgValue>GJTEST_EV</TopicArgValue>
                </TopicArg>
                </Topic>

                Comment

                Working...
                X