就是这三个,没想法这三个栏位很重要.
INSERT INTO rcv_transactions_interface
  (interface_transaction_id
  ,header_interface_id
  ,group_id
  ,interface_source_code
  ,last_update_date
  ,last_updated_by
  ,last_update_login
  ,creation_date
  ,created_by
  ,transaction_type
  ,transaction_date
  ,transaction_status_code
  ,processing_status_code
  ,processing_mode_code
  ,quantity
  ,unit_of_measure
  ,item_id
  --,item_description
  ,auto_transact_code
  ,receipt_source_code
  ,vendor_id
  ,vendor_site_id
  ,source_document_code
  ,po_header_id
  ,po_line_id
  ,po_line_location_id
  ,po_distribution_id
  ,validation_flag
  ,ship_to_location_id
  ,to_organization_id
  --,expected_receipt_date
  ,employee_id
  ,destination_type_code
  --,deliver_to_person_id
  ,deliver_to_location_id
  ,expected_receipt_date
  ,to_organization_code
  ,DOCUMENT_NUM
)
VALUES (v_transaction_interface_id --interface_transaction_id
,v_header_interface_id --header_interface_id
,v_group_id --group_id
,v_interface_source_code
,v_sysdate --last_update_date
,V_LAST_UPDATED_BY --last_update_by
,0--,V_LAST_UPDATED_BY --last_update_login
,sysdate --creation_date
,V_CREATED_BY --created_by
,c_line_transaction_type
,v_sysdate --transaction_date
,c_transaction_status_code
,c_processing_status_code
,c_processing_mode_code
,v_quantity
,v_unit_of_measure
,v_item_id
--,v_item_description
,c_l_auto_transact_code
,c_receipt_source_code
,v_vendor_id
,v_vendor_site_id
,c_source_document_code
,v_po_header_id
,v_po_line_id
,v_po_line_location_id
,v_po_distribution_id
,c_validation_flag
,v_ship_to_location_id
,v_ship_to_ORG_id
,v_employee_id
,c_destination_type_code
,v_deliver_to_location_id
,sysdate
,v_org_code
,v_po_no
--,3547071
--,3829518
);