Purchasing

Get Involved. Join the Conversation.

Topic

    sameer ashturkar
    How to know SOAP request mandatory fields
    Topic posted February 27, 2019 by sameer ashturkarBronze Medal: 1,250+ Points, tagged Fusion, Web Services 
    158 Views, 5 Comments
    Title:
    How to know SOAP request mandatory fields
    Summary:
    In SOAP request how to know mandatory fields if it contain many elements
    Content:

    Hello, 

    I am trying to create purchase order through soapui  tool but when I have imported the respective wsdl into soapui I have seen all request payload elements are optional. how do I find mandatory element to get response. 

    Image:

    Comment

     

    • Rajendra Rathor

      Sameer,

      Basically, there is no direct way to find out mandatory field in SOAP catalog. I would however go back to PO tables definition and enlist all mandatory fields

    • Niamath Jeddy

      Sameer,

      The below support note has sample payload for creating purchase order. It would help you get started.

      Oracle Fusion Purchasing Web Services Examples (Doc ID 2466289.1)

      Regards,

      Niamath

    • Niamath Jeddy

      Also, from within the application, you can navigate to Tools --> Developer connect and query the web service defintion.

      Here for the SDO, at attribute level, a flag 'required' is present which highlights if the attribute is mandatory or not.

      Please refer attached snap.

      Regards,

      Niamath

      • sameer ashturkar

        Thanks, But I can not see there all operation which is associated with purchasing web services and appropriate required parameter.

        Eg. To create purchase order its showing me Buyer Id is only mandatory but that is not a case. 

    • Aditya Singh

      Hi Sameer,

      Here is the sample payload for create PO:-

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
      <soap:Body xmlns:ns1="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderService/types/">
      <ns1:createPurchaseOrder>
      <ns1:createOrderEntry xmlns:ns2="http://xmlns.oracle.com/apps/prc/po/editDocument/purchaseOrderService/">
      <ns2:DocumentStyleId>1</ns2:DocumentStyleId>
      <ns2:ProcurementBUId>204</ns2:ProcurementBUId>
      <ns2:RequisitioningBUId>204</ns2:RequisitioningBUId>
      <ns2:BuyerId>100010026863783</ns2:BuyerId>
      <ns2:SupplierId>21</ns2:SupplierId>
      <ns2:SupplierSiteId>1969</ns2:SupplierSiteId>
      <ns2:DocumentDescription>NO_BPEL</ns2:DocumentDescription>
      <ns2:PurchaseOrderEntryLine>
      <ns2:LineTypeId>6</ns2:LineTypeId>
      <ns2:ItemDescription>Test Fixed Price Line</ns2:ItemDescription>
      <ns2:CategoryId>1</ns2:CategoryId>
      <ns2:Price>500001</ns2:Price>
      <ns2:PurchaseOrderEntrySchedule>
      <ns2:NeedByDate>2020-12-31</ns2:NeedByDate>
      <ns2:ShipToLocationId>207</ns2:ShipToLocationId>
      <ns2:ShipToOrganizationId>207</ns2:ShipToOrganizationId>
      <ns2:PurchaseOrderEntryDistribution>
      <ns2:RequesterId>24</ns2:RequesterId>
      <ns2:RequesterName>Green, Terry</ns2:RequesterName>
      </ns2:PurchaseOrderEntryDistribution>
      </ns2:PurchaseOrderEntrySchedule>
      </ns2:PurchaseOrderEntryLine>
      </ns1:createOrderEntry>
      </ns1:createPurchaseOrder>
      </soap:Body>
      </soap:Envelope>

      These are the mandatory fileds required to create a PO.

      also for your question that how to find mandatory field is that there is no such specific method for that although I suggest get some sample payload online for that PO 

      otherwise check whether there is any FBDI also for that operation like we are having FBDI for importing order, there you can get the Mandatory filed , oracle provide all the sample Filed in OTBI that will be needed while doing that transactions.

      Thanks

      Aditya Singh