In this article I will demonstrate how to import a structure via Interface.
Many companies face the difficulty of creating structures because of the volume of data. In this case there is possibility of using the oracle interface to give this help, with a little knowledge in sql and pl / sql you can do data manipulation safely. The important thing is that Oracle interfaces undergo the same validation as when entering data via the system screen.
First insert must be made in the header table of the components.
INSERT INTO bom_bill_of_mtls_interface ( alternate_bom_designator, last_update_date, last_updated_by, creation_date, created_by, assembly_type, item_number, process_flag, transaction_type, organization_id, common_organization_id, batch_id, common_item_number) VALUES ( NULL, -- alternativa SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id, 1, 'ITEM_AA', 1, 'CREATE', -- CREATE -- UPDATE v_organization_id, v_organization_id, 2, -- grupo de importação 'ITEM_AA');
After inserting the header you must import the components.
INSERT INTO bom_inventory_comps_interface ( last_update_date, last_updated_by, creation_date, created_by, effectivity_date, implementation_date, organization_id, component_item_number, assembly_item_number, component_quantity, process_flag, transaction_type, batch_id) VALUES (SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, SYSDATE, v_organization_id, ITEM BB, 'ITEM_AA', 6, 1, 'CREATE',-- CREATE -- UPDATE 2) -- GRUPO DE IMPORTAÇAO
Após essas duas inserções, roda-se o processo abaixo
Bills of Materials -> Bills -> Import Bills and Routings
After this, make sure about the data
See you next time.