ERPstuff - Oracle EBS Community

Dear All,

I have one problem, in inventory module, all items assigned with misc.misc.misc.misc.misc.misc ( 6 categries)by user. Now we categorized with actual category. I want to asign new category set. Anyone having idea how to remove existing category applied ag. items and attach new category?
Your help will be highly appriciated. We are having more than 20,000 part master (item master) and is there any scripts to update or remove existing set.


Thanks,

William.

Hi all,

No body interested to give solution for inventory module? I found the temporary solution.

steps 1: Inventroy - item- Category codes: define category codes

steps 2: Load category sets in Category sets field.

steps 3: Go to Item Master, query the item and attached new category set to existing misc sets.


William.

Hi,

Insert the records in MTL_ITEM_CATEGORIES_INTERFACE table and set the transaction type as 'UPDATE' and put the old category id or name into that table. then load the data into base table using standard concurrent.

example:

INSERT INTO mtl_item_categories_interface
( category_set_id, category_id, last_update_date, last_updated_by,
creation_date, created_by, last_update_login, organization_id,
process_flag, item_number, old_category_id, transaction_type, set_process_id
)
VALUES
( 1100000228, 15606, SYSDATE, 1318
,SYSDATE, 1318, 2385962, 204,
1, 'category11', 15605, 'update', 998
)

regards
Ravi

Thanks a lot Ravi.


William.