基于Item Template,导入Item数据

基于Item Template,导入Item数据

1.查找到TEMPLATE_ID

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

2.基于模板插入Item

  1. INSERT
  2. INTO
  3.   MTL_SYSTEM_ITEMS_INTERFACE  
  4.   (  
  5.     process_flag,  
  6.     set_process_id,  
  7.     transaction_type,  
  8.     organization_id,  
  9.     segment1,  
  10.     description,  
  11.     TEMPLATE_ID  
  12.   )  
  13. VALUES
  14.   (  
  15.     1,    --process_flag
  16.     1,     --set_process_id
  17. 'CREATE'--transaction_type
  18.     204,  --organization_id
  19. 'PTIAN1',  --Item Segment1
  20. 'Testing Item Import With Template',  --Item description
  21.     259  --Item TEMPLATE_ID
  22.   );  
  23. INSERT
  24. INTO
  25.   MTL_SYSTEM_ITEMS_INTERFACE  
  26.   (  
  27.     process_flag,  
  28.     set_process_id,  
  29.     transaction_type,  
  30.     organization_id,  
  31.     segment1,  
  32.     description,  
  33.     TEMPLATE_ID  
  34.   )  
  35. VALUES
  36.   (  
  37.     1,    --process_flag
  38.     1,     --set_process_id
  39. 'CREATE'--transaction_type
  40.     207,  --organization_id
  41. 'PTIAN1',  --Item Segment1
  42. 'Testing Item Import With Template',  --Item description
  43.     259  --Item TEMPLATE_ID
  44.   );  
  45. 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.


评论:

发表一条评论:
该日志评论功能被禁用了。
About

  • Pan Tian(田攀)
  • Search

    Categories
    Archives
    « 四月 2014
    星期日星期一星期二星期三星期四星期五星期六
      
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    今天