Self Service Procurement

Get Involved. Join the Conversation.

Topic

    Caio Zioli
    How to populate flexfields/attachments when Creating...Answered
    Topic posted October 7, 2019 by Caio ZioliGold Trophy: 10,000+ Points, last edited October 7, 2019, tagged Create Requisition, Requisition Web Services 
    67 Views, 10 Comments
    Title:
    How to populate flexfields/attachments when Creating Requisition using Rest Web Service
    Content:

    Hi all, please, is it possible to populate flexfields and attachments when creating requisitions using rest webservices ?

    I couldn't find the flexfields attributes and attachments field on the rest web service body/payload but i do see it on the soap web service body, i would like to confirm/double-check if it's the only way

    Rest Web service : https://docs.oracle.com/en/cloud/saas/procurement/19d/fapra/op-purchaserequisitions-requisitionheaderid-child-lines-post.html

    Soap WS: https://docs.oracle.com/en/cloud/saas/procurement/19d/oeswp/business-object-services.html#purchaserequestcreaterequisitionconfigurationdetai-d17112e41225

    kind rgds

     

    Best Comment

    Mara Prieto

    You are correct; Soap WS is the only Web Service option that supports attachment and DFFs at this point.
    However, the Purchase Request Web Service only retrieves attachments from other entities, like a sales order.

    To actually attach documents to requisitions, you need to use the ERP Object Attachment Service. You can use REST to create requisitions, and then use the ERP Object Attachment Service to load attachments to the created requisition. The whitepaper is here:

    https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2261597.1%3APRC_REQATTACH01_R11&docType=WHITE%20PAPER&action=download

    For DFFs, only SOAP WS or FBDI are the available options.

    Thanks
    mara

    Comment

     

    • Mara Prieto

      You are correct; Soap WS is the only Web Service option that supports attachment and DFFs at this point.
      However, the Purchase Request Web Service only retrieves attachments from other entities, like a sales order.

      To actually attach documents to requisitions, you need to use the ERP Object Attachment Service. You can use REST to create requisitions, and then use the ERP Object Attachment Service to load attachments to the created requisition. The whitepaper is here:

      https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2261597.1%3APRC_REQATTACH01_R11&docType=WHITE%20PAPER&action=download

      For DFFs, only SOAP WS or FBDI are the available options.

      Thanks
      mara

      • Caio Zioli

        Tks a lot Mara ! 

        Just to confirm regarding the ERP Object Attachment Service , is it possible to use it combined with the SOAP WS to create the requisition ? Because i won't be able to use rest due to the DFF.

        Kind Rgds

        • Uma Seetala

          Hi Caio,

          Combining both the services are not feasible. Both (Requisition creation and add attachment) are two different services. You may combine these two one after one by using any integration tool. With attachment service, it requires requisition details to add an attachment.

          Thanks,

          Uma Seethala

    • Mara Prieto

      Uma Seethala is correct. You will need to provide the requisition number, and possibly line number, to load attachments.

      thanks
      mara

      • Caio Zioli

        Tks Mara ! 

        Regarding the GET operations on the SOAP web services, is there any other way to get DFF informations from requisitions ? 

        As per the DOC_ID : Using Web Service "PurchaseRequestService" For Requisition Details (Doc ID 2250056.1), Purchase Request WS is not intent to do that and the rest service don't have the DFF mapped. Are there any other WS/DFF to retrieve it ?

        Kind Rgds

    • Mara Prieto

      What about OTBI reports? The Requisition Real Time subject area is one way of reporting on DFFs.

      If the idea works for you, some details for this are here: https://cloudcustomerconnect.oracle.com/posts/363722cd18

      Thanks
      mara

      • Caio Zioli

        Hi Mara, for our scenario, where we are developing a legacy mobile application, consuming a report wouldn't fit.  The idea is to couple this custom application using web services.

    • Mara Prieto

      Hi Caio, currently there is no service available to retrieve DFFs from the requisition.
      I believe PO has it, so a final available option is to retrieve it from purchase orders.

      Thanks
      mara