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;
