Organization Assignment of an Item thru Interface

We can assign items to an organization thru interface by below steps:

1. Insert selected items in mtl_system_item_interface table.
Select items from some existing organization or from your own custom table.
insert into mtl_system_items_interface(
inventory_item_id,organization_id,set_process_id,process_flag,transaction_type)
select inventory_item_id, organization_id,786000,3, 'CREATE' from mtl_system_items a
where organization_id = 149 and segment1 = '90-02' and segment3 = 'DM'

2. Change organization_id and Organization code as per the new organization
update mtl_system_items_interface
set organization_id = 331,organization_code = 'RPT' where set_process_id = 786000

3. You can change the lot control status or shelf life if it is different than the souce organization
update mtl_system_items_interface
set lot_control_code =2, shelf_life_code =4 where set_process_id = 786000

4. Now change the process code
update mtl_system_items_interface
set process_flag=1

5. Run the item import progamme with create or update items (last parameter in request) 1 (create).
Note: If there is a need to change some attribute after organization assignment you need to enter records again in mtl_system_item interface with updated attributes and then submit the item import program with create or update items (last parameter in request) 2 (Update existing items).

How to Allow to Retry Item Types to a User in the Workflow Monitor

A. Create a permission set
1. Functional Administrator responsibility
2. Permissions Set tab
3. Click on Create permission set
4. Enter the permission set name
ie: WF Retry Permission
5. Enter the code
ie: WF_RETRY_PERMISSION
6. In the Permission Set Builder section, CLick on add another row
7. Open the list of values for Permission column
8. Look for the Retry Activity
9. Click on the Apply button

B. Assign the permission set you just created to the responsibility that your user will use
a. User Management responsibility
b. Roles & Role Inheritance subtab
c. Enter the responsibility that your user will use to retry PO's
d. Click on Go
e. Click on the update icon (pencil)
f. Click the Permissions subtab and the click Create Grant button.
g. Enter the grant name
h. Click on next button
i. In the permission set enter the permission you created in Step# A.5
ie: WF Retry Permission
j. CLick on next
k. Click on Finish


C. Verify if the user has the retry option available.

If the user doesn't have the workflow monitor in the menu options under the Workflow responsibility then complete the following:
Navigation path:
1. Look for the Menu name associated to the responsibility which will be used to retry the workflows
2. Query the menu in the Define menu form using system administrator responsibility
3. Add the following option:
Prompt = Status monitor
Funciton = Workflow Status Monitor
Make sure the grant option is not checked.

References
Bug 6417672 - ATG RUP5: CANNOT FIND THE WF_RETRY PERMISSION SET
Note 412709.1 - Oracle Workflow Documentation Updates for 11i.ATG_PF.H.delta.5 (RUP 5)