Purchasing

Get Involved. Join the Conversation.

Topic

    Shravan Kumar Chelika
    REST/SOAP Webservice for getting PO Receiving Quantity
    Topic posted July 11, 2018 by Shravan Kumar ChelikaRed Ribbon: 250+ Points, tagged Financials 
    77 Views, 3 Comments
    Title:
    REST/SOAP Webservice for getting PO Receiving Quantity
    Summary:
    Looking for REST Webservice which would return the remaining Receiving Quantity for a Purchase Order.
    Content:

    Hello All,

    Is there any webservice(SOAP/REST) which would give the Remaining quantity to Receive on a Purchase Order? I have looked into Release 13 18A/18B procurement/SCM services and did not find any.

    To elaborate, lets say I have a PO Number 10 with a quantity of 300, there is webservice out there to get this PO Line quantity.

    But, if I receive around quantity of 100, is there a webservice which would give ME the remaining quantity that needs to be received is 200?

    Thanks,

    Shravan

    Comment

     

    • Ivan Pena

      Hi Shravan,

      Currently the PO SOAP/Rest services only return the ordered quantity. You might want to post under the inventory forum if there is  service to get the quantity received for a purchase order and then do the subtraction to get the remaining quantity.

      Ivan

       

       

    • Suman Guha

      Hi Shravan,

      If you can construct a query either in BI Publisher or OTBI that retrieves the information you are looking for, you can use a SOAP service wrapper to invoke the report and get the report output as service response.

      Please check this whitepaper out for details.

      Regards,

      Suman.

    • Shravan Kumar Chelika

      Thank you all for your responses..

      There is a REST webservice to get the PO Remaining Qty..

      https://docs.oracle.com/en/cloud/saas/supply-chain-management/r13-update18a/fasrp/op-linestoreceive-get.html

      /fscmRestApi/resources/11.13.18.02/linesToReceive

      this would return - 'Available Quantity'