1 Reply Latest reply on Feb 14, 2012 8:35 AM by user9525262

    Purchasing Document Open Interface Error - Blanket Purchase Agreement

    user9525262
      Hi all.

      I have a problem creating a blanket purchase agreement through the interface. What i did was this:

      INSERT INTO po_headers_interface (interface_transaction_id,
      batch_id,
      interface_source_code,
      process_code,
      action,
      group_code,
      org_id,
      document_type_code,
      document_num,
      currency_code,
      agent_id,
      vendor_id,
      vendor_site_id,
      ship_to_location_id,
      bill_to_location_id,
      approval_status,
      amount_agreed,
      effective_date,
      expiration_date)
      VALUES
      (...)

      INSERT INTO po_lines_interface (interface_line_id,
      interface_header_id,
      action,
      line_num,
      line_type,
      line_type_id,
      item_id,
      category_id,
      quantity,
      unit_price,
      taxable_flag,
      tax_code)
      VALUES
      (...)


      Then i run from the application "Import Price Catalogs" to import the BPA.

      I get this error in po_interface_errors: "No corresponding Blanket Agreement line available for this Price Break record. (COLUMN_NAME=SHIPMENT_NUM)"


      I mention I don't want to create a price break for the BPA i just want to create the line for the BPA. Anyone knows what I am doing wrong????
      I also got other errors b4 but I could resolve them.

      Thanks for any help on this.

      Edited by: user9525262 on Feb 14, 2012 12:08 AM