Items Uploading to MTL_SYSTEM_ITEMS_B

Items Uploading

1.     Prepare the Flex Data

2.     Prepare the Item Data

3.     Move the csv’s into the server.

4.     Go to BRITANNIA Inventory Super User Responsibility and run the concurrent program BRITANNIA ITEM FLEX LOADER

And BRITANNIA Item Flex Conversion.

5.     Check the Flex has been created or not using the query

select 

attribute1,attribute2,attribute3,description_attribute3,attribute4,description ,status

 from xxBRITANNIA_flex_item_stg

where trunc(creation_date)=trunc(sysdate)

and attribute1 ='99'

and status='PROCESSED';

6.     Run the BRITANNIA ITEM LOADER Concurrent Program and provide the path of the file in the Parameter.

7.     Run the BRITANNIA ITEM CONVERSION Concurrent Program and after that Run the IMPORT ITEMS Concurrent Program.

This has to be run in the Master Organization using Change Organization and the items have been loaded. Check using the Query.

select * from mtl_system_items_b

where trunc(creation_date)=trunc(sysdate)

and organization_id=84

8.     After that run the concurrent Program Assign Items to the Child Organization Concurrent Program and specify the Organization Id for uploading the items.

9.     After that Apply Item Category Assignment using the program.

*********************Item Category Assignment****************

DECLARE

x NUMBER := 0;

CURSOR lcu_items

IS

Select INVENTORY_ITEM_ID, category_id

from MTL_SYSTEM_ITEMS_B MSIB

,MTL_CATEGORIES MC

WHERE TRUNC(MSIB.CREATION_DATE) = TRUNC(SYSDATE)

AND ORGANIZATION_ID = 84

AND MC.segment1 = MSIB.segment1

AND MC.segment2 = MSIB.segment2;

BEGIN

FOR i IN lcu_items LOOP

x := x+1;

UPDATE inv.mtl_item_categories

set category_id = i.category_id

where inventory_item_id = i.inventory_item_id;

end loop;

dbms_output.put_line('Total Update: '||x);

--COMMIT;

END;