
Oracle EBS INV module
文章平均质量分 77
Monday
开朗,真实
展开
-
物料目录导入 Item catalog upload
1. 制作数据模板,包含基本属性:item_number, catalog group name, descriotive elements name, value2. 上传数据模板至相应服务器目录下3. 跑upload程序将数据插入至临时表4. 跑import程序将临时表里的数据直接通过程序插入至基本表 注意:catalog 的属性维护职能去master items 下进行维原创 2012-06-21 18:30:36 · 558 阅读 · 0 评论 -
物料导入 Inventory Item Migration
--INV Items--Concurrent programs:Import Items N: INV/Items/Import/Import ItemsSELECT * FROM mtl_system_items_interface WHERE TRUNC (creation_date) = TRUNC (SYSDATE);SELECT * FROM mtl_it原创 2012-06-18 13:25:31 · 943 阅读 · 0 评论 -
物料类别导入 Inventory Item Categories Migration
--INV Item Categories--Concurrent programs:N: INV/Items/Import/Item Category Assignment Open InterfaceSELECT * FROM mtl_item_categories_interface mici WHERE TRUNC (creation_date) = TRUNC (SYS原创 2012-06-20 14:16:58 · 684 阅读 · 0 评论 -
杂收数量导入on hand
--Concurrent programs:--Process transaction interface N: INV/Setup/Transactions/Interface Managers/Process transaction interface/Tools/Launch ManagerSELECT*FROM mtl_transactions_interface m原创 2012-07-03 11:00:53 · 567 阅读 · 0 评论