基于Item Template,导入Item数据

最新推荐文章于 2024-07-19 15:58:27 发布

最新推荐文章于 2024-07-19 15:58:27 发布 · 101 阅读

文章标签：

#数据库

本文介绍如何使用ItemTemplate在Oracle库存管理系统中导入物品数据。主要包括查找模板ID、基于模板插入物品记录、运行导入程序等步骤。同时介绍了MTL_SYSTEM_ITEMS_INTERFACE表的作用及使用技巧。

基于Item Template,导入Item数据

1.查找到TEMPLATE_ID

SELECT * FROM MTL_ITEM_TEMPLATES_B b,MTL_ITEM_TEMPLATES_TL tl
WHERE b.TEMPLATE_ID = tl.TEMPLATE_ID
AND tl.TEMPLATE_NAME LIKE 'Purchased Item%';

2.基于模板插入Item

INSERT
INTO
  MTL_SYSTEM_ITEMS_INTERFACE
  (
    process_flag,
    set_process_id,
    transaction_type,
    organization_id,
    segment1,
    description,
    TEMPLATE_ID
  )
  VALUES
  (
    1,    --process_flag
    1,     --set_process_id
    'CREATE', --transaction_type
    204,  --organization_id
    'PTIAN1',  --Item Segment1
    'Testing Item Import With Template',  --Item description
    259  --Item TEMPLATE_ID
  );


INSERT
INTO
  MTL_SYSTEM_ITEMS_INTERFACE
  (
    process_flag,
    set_process_id,
    transaction_type,
    organization_id,
    segment1,
    description,
    TEMPLATE_ID
  )
  VALUES
  (
    1,    --process_flag
    1,     --set_process_id
    'CREATE', --transaction_type
    207,  --organization_id
    'PTIAN1',  --Item Segment1
    'Testing Item Import With Template',  --Item description
    259  --Item TEMPLATE_ID
  );

COMMIT;

3.运行"Import Items" Program

也可以通过脚本来调用"Import Item" program，参见Script to Submit Item Import (INCOIN) using FND_REQUEST in Oracle Apps R12

4.Item数据成功生成

关于Item Interface表-MTL_SYSTEM_ITEMS_INTERFACE

MTL_SYSTEM_ITEMS_INTERFACE temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory.
.
This table contains user friendly columns which allow you to easily enter your data as well as their corresponding foreign keys. Oracle Inventory will default column values you do not enter, after performing the proper validation. For example, you enter the ORGANIZATION_CODE, and Oracle Inventory will fill in the corresponding ORGANIZATION_ID for you. It is strongly recommended that users enter the segment information for the item instead of the item number.
.
You can also specifiy a TEMPLATE_ID to copy item attributes from.
.
Also, if you enter REVISION, Oracle Inventory will insert a record into MTL_ITEM_REVISIONS for your item.

转载请注明出处：http://blog.youkuaiyun.com/pan_tian/article/details/7751214

======EOF======