Purchasing

Get Involved. Join the Conversation.

Topic

    Harshal Agrawal
    Need to Update PO lines using FBDI or ADFDi
    Topic posted September 7, 2019 by Harshal AgrawalRed Ribbon: 250+ Points, tagged Fusion, Setup 
    61 Views, 2 Comments
    Title:
    Need to Update PO lines using FBDI or ADFDi
    Summary:
    Updating PO Lines using FBDI and ADFDi
    Content:

    HI All,

    There is one requirement such that client is having 1 PO with 150 lines and they want to update PO lines using FBDI or ADFDI as manual update of PO lines takes more time and in a day there are about 5 such PO which client need to update.

    Can you please let me know how to achieve that ? I have checked Oracle metalink PO update is there only at headers level and not at line level. So in this case how to achieve this ?

    Thanks,
    Harshal

    Version:
    19c

    Comment

     

    • Piyush Bihany

      Hi Harshal

      It is not possible to use FBDI for updating few columns on Purchase Orders, you can only add new Lines to Purchase Orders using Update Action in FBDI

      For updating few columns on the PO you have to use Change Order Webservice, using this change order webservice you can update

      - PO Header Columns (Even DFF attributes) without updating any lines

       

      Currently Oracle doesn't offer 'Update' action on the Lines in Purchase Orders Import FBDI.

      Only Headers has 'Add' and 'Update' actions, the Lines just has Action 'Add'

      Enh: 18066076 - PURCHASE ORDER UPDATE/CANCEL VIA FBDI FOR IMPORT ORDERS ESS JOB

      Bug 18494839 : UNABLE TO UPDATE PURCHASE ORDER USING IMPORT ORDER ESS JOB

      This Enh is currently at status: "22 - Approved for Future Release", however the specific release is not yet identified.
       

      --

      PB

       

      • Harshal Agrawal

        Hi Piyush,

        Thank you for the reply. Need to ask one thing, do you have sample example of web services how to be used for updating PO lines.
        As I am much aware of functional side and not on technical side, can you please help me on web services ?

        Thanks,
        Harshal