1.首先插入数据到 interface
脚本如下:
INSERT INTO mtl_system_items_interface
(inventory_item_id, segment1, organization_id,process_flag,
transaction_type, item_type, revision_qty_control_code,
must_use_approved_vendor_flag, inventory_planning_code,
planner_code, planning_make_buy_code, fixed_days_supply,
mrp_planning_code, planning_exception_set, shrinkage_rate,
preprocessing_lead_time, fixed_lead_time, attribute2,
attribute4, attribute1, postprocessing_lead_time, buyer_id, attribute15
)
VALUES (17534,'12230006B36', 117, 1, 'INSERT',
'FG', NULL, 'N',
6, 'B-1AN2K',
1, 12, 3,
NULL, NULL, 1,
3, 'F0030', 'F0030',
NULL, 0, NULL, NULL
)
--提示插入成功
接着commit;
2.在Inventory里面运行import itemsprogram ,
没有错误信息,完成
Concurrent request completed successfully
3.接着我去查导入的料号(MASTER ITEM),结果查不到 !!
select msif.process_flag, msif.item_number, msif.segment1 , msif.*
frommtl_system_items_interface msif
where msif.segment1='12230006B36'
process flag 还是1, 看接口文档说如果导入成功应该是7 才对
可是我执行 import item 却能够完成而且没有错误信息?
大家开发过的请指点一下,thanks
|