Interface: Item

Oracle物品更新流程

最新推荐文章于 2025-07-09 15:42:45 发布

原创最新推荐文章于 2025-07-09 15:42:45 发布 · 286 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 同时被 2 个专栏收录

3 篇文章

订阅专栏

EBS INV

1 篇文章

订阅专栏

本文介绍了一个具体的Oracle系统中物品及类别更新的过程，包括插入物品数据到inv.mtl_system_items_interface表，更新物品类别数据到inv.mtl_item_categories_interface表，并运行了相应的导入程序。

Metalink Doc# 268968.1

1. Insert data into inv.mtl_system_items_interface

INSERT INTO inv.mtl_system_items_interface 
            (process_flag, set_process_id, transaction_type,organization_id, item_type,segment1) 
     VALUES (1,731,’UPDATE',4605,'User_Item_Type','Test_Item_Number');

2. Insert Data into

insert into inv.mtl_item_categories_interface
(process_flag, set_process_id, transaction_type, organization_id,category_set_id, item_number, old_category_id, category_id)
values(1,731,'UPDATE',4605,1,'<span style="font-family: Arial, Helvetica, sans-serif;">Test_Item_Number</span>',5456,5457);

3. Run Conc. Prog.

Import Items