Creating Inventory Items and Bills of material

interface tables for creating inventory and category.

MTL_SYSTEM_ITEMS_INTERFACE

MTL_ITEM_CATEGORIES_INTERFACE

apply below insert query to get your item details in to interface tables.

INSERT INTO inv.mtl_system_items_interface (TRANSACTION_TYPE,

                                            SEGMENT1,

                                            DESCRIPTION,

                                            TEMPLATE_NAME,

                                            CUSTOMER_ORDER_ENABLED_FLAG,

                                            ITEM_TYPE,

                                            CONFIG_MODEL_TYPE,

                                            COMMS_NL_TRACKABLE_FLAG,

                                            SERVICEABLE_PRODUCT_FLAG,

                                            SERV_REQ_ENABLED_CODE,

                                            SERIAL_NUMBER_CONTROL_CODE,

                                            ATTRIBUTE1,

                                            ATTRIBUTE2,

                                            ATTRIBUTE3,

                                            ATTRIBUTE4,

                                            ATTRIBUTE5,

                                            ATTRIBUTE6,

                                            ATTRIBUTE7,

                                            ATTRIBUTE8,

                                            ATTRIBUTE9,

                                            ATTRIBUTE10,

                                            ATTRIBUTE11,

                                            ATTRIBUTE12,

                                            ATTRIBUTE13,

                                            ATTRIBUTE14,

                                            ATTRIBUTE15,

                                            PROCESS_FLAG,

                                            CREATED_BY,

                                            ORGANIZATION_ID,

                                            SET_PROCESS_ID)

     VALUES ('CREATE',

             'your item name',

            'your item desc',

             'your template name',

             'Y',

             'PTO',

             '',

             'Y',

             'Y',

             'E',

             1,

             'N',

             'N',

             'name',

             '',

             '',

             'N',

             'IP',

             'Y',

             'Y',

             'Y',

             'code',

             'value',

             'value',

             '',

             'item_name',

             1,

             1052,

             value,

             1);

for creating category apply below query

INSERT INTO inv.MTL_ITEM_CATEGORIES_INTERFACE (TRANSACTION_TYPE,

                                               CATEGORY_SET_NAME,

                                               CATEGORY_NAME,

                                               ITEM_NUMBER,

                                               ORGANIZATION_ID,

                                               SET_PROCESS_ID,

                                               PROCESS_FLAG)

     VALUES ('CREATE',

             'set name',

             'name',

             'cat name',

             value,

             6,

             1);

Run Import Items concurrent program with the parameters

provide set_process_id as per your query.

inventory items and category should be created now.

Creating BOM

interface table

BOM_BILL_OF_MTLS_INTERFACE 

BOM_INVENTORY_COMPS_INTERFACE 

INSERT INTO BOM_BILL_OF_MTLS_INTERFACE (transaction_type,

                                        item_number,

                                        organization_code,

                                        process_flag)

     VALUES ('CREATE',

             'item name',

             'value',

             1);

create BOM component.

INSERT INTO bom_inventory_comps_interface (transaction_type,

                                           ASSEMBLY_ITEM_NUMBER,

                                           component_item_number,

                                           component_quantity,

                                           optional,

                                           effectivity_date,

                                           operation_seq_num,

                                           organization_code,

                                           process_flag)

     VALUES ('CREATE',

             'comp name',

             'item name',

             1,

             1,

             SYSDATE,

             1,

             'value',

             1);

run the concurrent programs for Bills.

it will create bills of material for your items.