一批物料能否被一次性分配给一个新的库存组织?

smallworm · 发表于 2007-1-22 21:08

我用的办法是调用MTL_SYSTEM_ITEMS_PKG.INSERT_ROW 和 INVIDIT2.Table_Inserts 这两个过程，这也是在FORM里查出来的。目前还没出现问题。

镶黄旗 · 发表于 2007-1-23 16:13

最初由 smallworm 发布
[B]我用的办法是调用MTL_SYSTEM_ITEMS_PKG.INSERT_ROW 和 INVIDIT2.Table_Inserts 这两个过程，这也是在FORM里查出来的。目前还没出现问题。 [/B]

不知高手说的这个东西，界面上能不能操作？

robincao · 发表于 2007-1-23 16:17

有无SQL语句可以实现??

smallworm · 发表于 2007-1-23 16:33

当时写的仓促，在转换帐户组合的时候没有做到通用性。自己根据具体业务中的帐户包括多少段值来修改吧。

sunnly · 发表于 2007-1-23 17:03

一颗item如何进入oracle呢?
参考metalink : 115557.1
过程:IOI process.

1)验证所有oracle有效的package:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE status = 'INVALID'
2)要确保:
adrelink sample command lines to relink aiap:
'adrelink force=y ranlib=y "fnd aiap"'

3)检查system_items_b的索引注意:MTL-SYSTEM_ITEMS是_b的同义词)
Select table_name, index_name
From all_indexes
Where table_name in ('MTL-SYSTEM_ITEMS', 'MTL_SYSTEM_ITEMS_INTERFACE',
'MTL_SYSTEMS_ITEMS_B')
Order by table_name, index_name;

4)检查内部和标准的concurrent管理器是否启动.
在system administrator/concurrent/manager/administer

5)接着,可以从invetory responsibility中master items里头加载item.然后保存.这样一颗item就可以进入了.
同样的,可以自己下sql来实现,把item送到interface中:
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE TEST
(TEST.PROCESS_FLAG,
TEST.TRANSACTION_TYPE,
TEST.ORGANIZATION_ID,
TEST.SET_PROCESS_ID,
TEST.DESCRIPTION,
TEST.ITEM_NUMBER)
VALUES
(1, 'CREATE', 90, 100, 'create by joodhawk1', '05.1223.903')

6)当item要进入item interface的时候,是需要对如下的table进行冻结的:
MTL_SYSTEM_ITEMS_INTERFACE
MTL_INTERFACE_ERRORS
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE

7)为了更新一颗item ,ORACLE 说可以设置TRANSACTION_TYPE = 'UPDATE'
• Item Attribute Interdependencies
• Master - Child Attribute Dependencies
• Status Controlled Attributes
我下了这样的sql来更新,同时,注意在ap上进行run request的时候也需要更改其状态为2,否则还是没法run成功的:
INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE TEST
(TEST.PROCESS_FLAG,
TEST.TRANSACTION_TYPE,
TEST.ORGANIZATION_ID,
TEST.SET_PROCESS_ID,
TEST.DESCRIPTION,
TEST.ITEM_NUMBER)
VALUES
(1, 'UPDATE', 92, 100, 'UPDATED BY JOODHAwk', '05.1223.902')
为了更好的perfomance,oracle建议使用inventory_item_id

8) item 有2个状态3个状态active,inactive,opm状态的改变记录在mtl_pending_item_status中.

9)Master level controlled attributes are correctly propagated to the Child records when the Master Item record is updated. When launching items into the Master Item Org, the Child records are copied into MTL_SYSTEM_ITEMS_INTERFACE for validation, and are identified with a transaction_type of 'AUTO_CHILD'. These records are deleted if the parameter 'Delete Processed Rows' has been passed as 'Yes', and remain for diagnostic purposes if the parameter is passed as 'No'.

10)item的基本的function 属性定义好之后.就会给item默认的category set和category.

11)可以使用如下的定义输入null值.
• for Numeric fields: insert -999999
• for Character fields: insert '!'
• for Date fields: the above list does not include any updateable date fields.

12)
Importing Master and Child Records
==================================
Previously, IOI processed items in an order that did not recognize that Master Items were loaded before child records in MTL_SYSTEM_ITEMS. Therefore, users were advised to Import Master Records first in one run and then separately Import Child records.
The IOI code now automatically separates Master records from Children, and processes Master records first. However, as one IOI process is not aware of other IOI processes running in parallel, do not split a given item's separate Organization records into two different SET_PROCESS_IDs that are being run in parallel. Doing so may cause the Child record to be processed before the Master record.

Master level controlled attributes are correctly propagated to the Child records when the Master Item record is updated. When launching items into the Master Item Org, the Child records are copied into MTL_SYSTEM_ITEMS_INTERFACE for validation, and are identified with a transaction_type of 'AUTO_CHILD'.