0 Replies Latest reply on Apr 10, 2014 12:13 PM by BrianK197719781979

    Import Price Catalogs - BPA creating new line instead of updating existing

    BrianK197719781979

      Hello All!

       

      I am trying to update an existing BPA line using Import Price Catalogs

      I am passing the correct po_line_id

      But instead of updating the existing line, it is creating a new line.

       

      Does anyone know why this is happening?

      Thanks.

       

       

      INSERT INTO PO_HEADERS_INTERFACE (

        INTERFACE_HEADER_ID,

        BATCH_ID,

        ACTION,

        VENDOR_ID,

        VENDOR_SITE_ID,

        AGENT_ID, --optional as you can enter buyer duringimport run

        PO_HEADER_ID,

        ORG_ID

      )

      VALUES

      (

        apps.po_headers_interface_s.NEXTVAL,

        444,

        'UPDATE',

        62022,

        67330,

        76,

        54038, --'41000000',

        101

      );

       

      INSERT INTO PO_LINES_INTERFACE

      (

        INTERFACE_LINE_ID,

        INTERFACE_HEADER_ID,

        PO_LINE_ID,

        ACTION,

        UNIT_PRICE,

        ITEM_DESCRIPTION,

        CATEGORY,

        VENDOR_PRODUCT_NUM,

        UNIT_OF_MEASURE

      )

      VALUES

      (

        po_lines_interface_s.nextval,

        po_headers_interface_s.currval,

        51558,

        'REPLACE',

        99,

        'Awlfloc 6150FG - 25kg BagBK1',

        'Flocculants',

        'Vend Num BK',

        'Each'

      );