Create Product/Business Partner category

8. Create Product category
9. Create BusinessPartner Category

• Short description:Create a product category to import the data from the temporal tables to the final tables.

• Steps:
  • Login as userA
  • Go to Master data management->Product Setup->Product Category
  • Click New and fill value=RM; Name=Raw materials and save
  • Create Product categories for BOM (Bill of Materials) and FG (Finished Goods) with this Oracle script or this postgreSQL script

• Additional data: Please create these categories with the values RM, BOM and FG respectively in order to import the products that belong to that category.

Raw Material 以外は　Script が用意されているので、これを実行。

DECLARE
v_client_id number(10);
v_product_category_id number(10);

BEGIN
SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
SELECT MAX(M_PRODUCT_CATEGORY_ID)+1 INTO v_product_category_id FROM  M_PRODUCT_CATEGORY;
INSERT INTO M_PRODUCT_CATEGORY (M_PRODUCT_CATEGORY_ID, AD_CLIENT_ID, AD_ORG_ID,
ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, VALUE, NAME, PLANNEDMARGIN)
VALUES (v_product_category_id, v_client_id, 0 , 'Y', sysdate , 100, sysdate, 100, 'BOM', 'BOMs', 0);
v_product_category_id:=v_product_category_id + 1;
INSERT INTO M_PRODUCT_CATEGORY (M_PRODUCT_CATEGORY_ID, AD_CLIENT_ID, AD_ORG_ID,
ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, VALUE, NAME, PLANNEDMARGIN)
VALUES (v_product_category_id, v_client_id, 0 , 'Y', sysdate , 100, sysdate, 100, 'FG', 'Final goods',0);
AD_UPDATE_SEQUENCE();
commit;
end;