订单的导入问题，各位大侠帮忙给看看....

hphubei

最初由 ysfabm 发布
[B]

老大,有呀,在写入接口表后,我查看过接口表的数据正常.请问各位老兄,是怎么样把大批的订单导入到系统的,一个一个的录吗? [/B]

当然不可能是一个一个的录入了,不要着急,会有解决办法的

yuanlinok

灌注

hll628

幫你up

hphubei

搞定了没有？

咖啡生活

我也测试了差不多一个星期,  看订单导入的存储过程才测出来的,  下面是测试的例子, 涉及最少三张表:

--数据插入接口表
--插入头接口
insert into oe_headers_iface_all
(accounting_rule_id,booked_flag,conversion_type_code,created_by,creation_date,customer_po_number,demand_class_code,
fob_point_code,freight_carrier_code,freight_terms_code,invoice_to_contact_id,invoice_to_org_id,invoicing_rule_id,
last_updated_by,last_update_date,last_update_login,operation_code,ordered_date,order_category,order_date_type_code,
order_source_id,order_type_id,org_id,orig_sys_document_ref,payment_term_id,price_list_id,ready_flag,request_date,
salesrep_id,sales_channel_code,ship_from_org_id,ship_to_contact_id,ship_to_org_id,sold_from_org_id,sold_to_contact_id,
sold_to_org_id,tax_exempt_flag,transactional_curr_code)
values(1,'Y','1000',1055,sysdate,'','SZA',
'SHIP POINT','','自提',1054,1082,-2,
1055,sysdate,0,'INSERT',sysdate,'ORDER','SHIP',
1021,1120,6,'12',1003,6004,'',sysdate,
100000486,'商业经销',1,1054,1083,6,1054,
1056,'S','CNY');

--插入行接口
insert into oe_lines_iface_all  
(accounting_rule_id,calculate_price_flag,cancelled_flag,cancelled_quantity,closed_flag,created_by,creation_date,
delivery_lead_time,demand_class_code,inventory_item_id,invoice_to_contact_id,invoicing_rule_id,item_type_code,
last_updated_by,last_update_date,last_update_login,line_number,line_type_id,operation_code,option_flag,ordered_quantity,
order_quantity_uom,
order_source_id,org_id,orig_sys_document_ref,orig_sys_line_ref,price_list_id,pricing_quantity,pricing_quantity_uom,
promise_date,salesrep_id,schedule_arrival_date,schedule_ship_date,shipment_number,shipment_priority_code,ship_from_org_id,
ship_set_id,ship_tolerance_above,ship_tolerance_below,ship_to_contact_id,ship_to_org_id,sold_from_org_id,sold_to_org_id,
source_type_code,tax_code,tax_date,tax_exempt_flag)
values(1,'Y','','','N',1055,sysdate,
0,'SZA',250,1054,-2,'STANDARD',
1055,sysdate,0,1,1023,'INSERT','',2,'片',
1021,6,'12','1',6004,2,'片',
sysdate,100000486,sysdate,sysdate,1,'Standard',1,
'',1,1,1054,1083,6,1056,
'INTERNAL','VAT-17',sysdate,'S');

--动作接口表
insert into oe_actions_iface_all
(order_source_id,orig_sys_document_ref,ORIG_SYS_LINE_REF,org_id,operation_code)
values(1021,'12','1',6,'BOOK_ORDER');

commit;

其中的数据, 根据自己的情况, 修改一下测试看看.

huangkungan

用api简单多了.

hll628

學習

hphubei

louzhu 呢？

kenni

如何用API啊

sunnly

还没解决么