0 Replies Latest reply on Apr 17, 2015 4:35 PM by 807548

    Can we update attribute value through import price catalog program PDOI?

    807548

      I have created a Quotation through Import Price catalog as shown below.

       

      INSERT INTO PO_HEADERS_INTERFACE (

      INTERFACE_HEADER_ID,

      BATCH_ID,

      ACTION,

      VENDOR_ID,

      VENDOR_SITE_CODE,

      VENDOR_SITE_ID,

      AGENT_ID,

      EFFECTIVE_DATE,

      expiration_date)

      VALUES (

      po_headers_interface_s.NEXTVAL,

      po_headers_interface_s.CURRVAL,

      'ORIGINAL',

      5912,

      'KNOX',

      null,

      51926,

      '07-APR-12',

      '08-APR-12')

       

      INSERT INTO PO_LINES_INTERFACE

      (INTERFACE_LINE_ID,

      INTERFACE_HEADER_ID,

      ITEM,

      ITEM_ID,

      ITEM_DESCRIPTION,

      LINE_NUM,

      UNIT_PRICE,

      UNIT_OF_MEASURE,

      PRICE_BREAK_LOOKUP_CODE,

      ship_to_organization_id,

      ship_to_location_id,

      line_loc_populated_flag,

      line_attribute1

      )

      VALUES

      (po_lines_interface_s.nextval,

      po_headers_interface_s.currval,

      '84D737348P1',

      1083259,

      null,

      1,

      128,

      'Each',

      'NON CUMULATIVE',

      103,

      97806,

      null,

      60);

       

      Quote created successfully with item price as 128 and po_lines.attribute 1 value as 60. but when i try to update both price and line attribute1, it only updates the price and not attribute1 value?

       

       

       

      INSERT INTO po_headers_interface

      (interface_header_id,

      batch_id,

      action,

      org_id,

      document_type_code,

      document_num,

      vendor_id,

      vendor_site_code,

      vendor_site_id,

      po_header_id)

      values

      (po_headers_interface_s.nextval,

      po_headers_interface_s.currval,

      'UPDATE',

      102,

      'QUOTATION',

      '134659',

      5912,

      'KNOX',

      null,

      null);

       

       

      insert into PO_LINES_INTERFACE

      (

      INTERFACE_HEADER_ID

      ,INTERFACE_LINE_ID

      ,ACTION

      ,LINE_NUM

      ,DOCUMENT_NUM

      ,LINE_TYPE_ID

      ,ITEM

      ,ITEM_ID

      ,uom_code

      ,UNIT_PRICE

      ,po_line_id

      ,line_attribute1

      )

      values(

      PO_HEADERS_INTERFACE_S.CURRVAL

      ,PO_LINES_INTERFACE_S.NEXTVAL

      ,'UPDATE'

      ,'1'

      ,'134519'

      ,'1'

      ,'84D737348P1'

      ,1083259

      ,'EA'

      ,150

      ,null --2565810

      ,50

      );