4 Replies Latest reply: May 29, 2012 4:19 PM by Viktor.Jarolim-Oracle RSS

    How to find orders in timer delay.

    SrinivasK
      Hi,
      How to find the orders which are in timer delay.
      Is it from Find Order/Get Order combination. Appreciate your help.
        • 1. Re: How to find orders in timer delay.
          882807
          Srinivas,

          If your intension is to just list down orders(basically reporting), which are in "timer delay" you can simply use FindOrder(here is the xml for you). For more information, please have a look at the wsdl.

          <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ord="http://xmlns.oracle.com/communications/ordermanagement">
               <soapenv:Header/>
               <soapenv:Body>
                    <ord:FindOrder>
                         <ord:SelectBy>
          <!--Zero or more repetitions:-->
                              <ord:Field>
                                   <!--Optional:-->
                                   <ord:Cartridge>
                                        <ord:Name>?</ord:Name>
                                        <!--Optional:-->
                                        <ord:Version>?</ord:Version>
                                   </ord:Cartridge>
                                   <ord:Path>?</ord:Path>
                                   <!--You have a CHOICE of the next 2 items at this level-->
                                   <ord:EqualTo>?</ord:EqualTo>
                                   <ord:From>?</ord:From>
                                   <ord:To>?</ord:To>
                              </ord:Field>
                         </ord:SelectBy>
                    </ord:FindOrder>
               </soapenv:Body>
          </soapenv:Envelope>

          If you want to perform some operations, then u need to use combination of Find & GetOrders. As GetOrder returns Order Data when a "View" input is provided in the xml.

          Thanks
          Naveen Jabade
          • 2. Re: How to find orders in timer delay.
            SrinivasK
            Hi Naveen,
            Thanks for quick response.
            Yes you are correct, i am trying to find list of orders which are in timer delay.
            Here is where i was confused.

            FindOrder WS allows below search fields only in selectBy element.

            "OrderState"
            "TargetOrderState"
            "Reference"
            "Cartridge"
            "OrderType"
            "OrderSource"
            "CreatedDate"
            "CompletedDate"
            "ExpectedStartDate"
            "ExpectedOrderCompletionDate"
            "RequestedDeliveryDate"
            "ExpectedDuration"
            "Priority"

            Out of which, what can i pass as input to list out the orders which are in TimerDelay.

            Edited by: SrinivasK on May 23, 2012 5:28 AM
            • 3. Re: How to find orders in timer delay.
              882807
              Hi Srinivas,

              I have actually pasted the optimized version of FindOrder, here is the full xml. As you know, whichever says optional you can remove the below tags.

              <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ord="http://xmlns.oracle.com/communications/ordermanagement">
              <soapenv:Header/>
              <soapenv:Body>
              <ord:FindOrder>
              <!--Optional:-->
              <ord:ViewBy>
              <!--Zero or more repetitions:-->
              <ord:View>?</ord:View>
              <!--Optional:-->
              <ord:RemarkFilter>
              <!--Optional:-->
              <ord:RetrieveRemarks>false</ord:RetrieveRemarks>
              <!--Zero or more repetitions:-->
              <ord:AttachmentFilter>
              <!--Optional:-->
              <ord:FileNameMatch>.*</ord:FileNameMatch>
              <!--Optional:-->
              <ord:MinSize>0</ord:MinSize>
              <!--Optional:-->
              <ord:MaxSize>4</ord:MaxSize>
              <!--Optional:-->
              <ord:Format>inlineBase64Binary</ord:Format>
              </ord:AttachmentFilter>
              </ord:RemarkFilter>
              <!--Optional:-->
              <ord:AmendmentFilter>
              <ord:LevelOfDetail>?</ord:LevelOfDetail>
              </ord:AmendmentFilter>
              <!--Optional:-->
              <ord:LifecycleEventFilter>
              <!--Optional:-->
              <ord:RetrieveLifecycleEvents>false</ord:RetrieveLifecycleEvents>
              </ord:LifecycleEventFilter>
              </ord:ViewBy>
              <!--Optional:-->
              *<ord:SelectBy>*
              *<!--Optional:-->*
              *<ord:OrderId>?</ord:OrderId>*
              *<!--Optional:-->*
              *<ord:OrderState>?</ord:OrderState>*
              *<!--Optional:-->*
              *<ord:TargetOrderState>?</ord:TargetOrderState>*
              *<!--Optional:-->*
              *<ord:Reference>?</ord:Reference>*
              *<!--Optional:-->*
              *<ord:Cartridge>*
              *<ord:Name>?</ord:Name>*
              *<!--Optional:-->*
              *<ord:Version>?</ord:Version>*
              *</ord:Cartridge>*
              *<!--Optional:-->*
              *<ord:OrderType>?</ord:OrderType>*
              *<!--Optional:-->*
              *<ord:OrderSource>?</ord:OrderSource>*
              *<!--Optional:-->*
              *<ord:CreatedDate>*
              *<!--Optional:-->*
              *<ord:FromDate>?</ord:FromDate>*
              *<!--Optional:-->*
              *<ord:ToDate>?</ord:ToDate>*
              *</ord:CreatedDate>*
              *<!--Optional:-->*
              *<ord:CompletedDate>*
              *<!--Optional:-->*
              *<ord:FromDate>?</ord:FromDate>*
              *<!--Optional:-->*
              *<ord:ToDate>?</ord:ToDate>*
              *</ord:CompletedDate>*
              *<!--Optional:-->*
              *<ord:Priority>?</ord:Priority>*
              *<!--Zero or more repetitions:-->*
              *<ord:Field>*
              *<!--Optional:-->*
              *<ord:Cartridge>*
              *<ord:Name>?</ord:Name>*
              *<!--Optional:-->*
              *<ord:Version>?</ord:Version>*
              *</ord:Cartridge>*
              *<ord:Path>?</ord:Path>*
              *<!--You have a CHOICE of the next 2 items at this level-->*
              *<ord:EqualTo>?</ord:EqualTo>*
              *<ord:From>?</ord:From>*
              *<ord:To>?</ord:To>*
              *</ord:Field>*
              *<!--Optional:-->*
              *<ord:MaxOrders>?</ord:MaxOrders>*
              *</ord:SelectBy>*
              <!--Optional:-->
              <ord:OrderBy>
              <!--1 or more repetitions:-->
              <ord:OrderField>
              <!--Optional:-->
              <ord:SortBy>?</ord:SortBy>
              <ord:Header>?</ord:Header>
              </ord:OrderField>
              </ord:OrderBy>
              </ord:FindOrder>
              </soapenv:Body>
              </soapenv:Envelope>


              Thanks
              Naveen Jabade
              • 4. Re: How to find orders in timer delay.
                Viktor.Jarolim-Oracle
                There does not seem to be this ability with the find order WS operation.
                Before, on the xml api, the query operation had the capcability to query by task (the timer delay is a task), but it was not implemented on the ws api.
                Anyway, you would have to submit a particular delay task, not sure if the xml api query.request can take multiple as its input.
                In the DB, the way to find orders in a delay task is

                select * from om_order flow
                where task_type = 'D'

                regards
                Viktor