Importing bills at Interface

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

Sem título

After this, make sure about the data

Sem título

See you next time.

Um comentário em “Importing bills at Interface

Adicione o seu

Deixe uma resposta

Powered by WordPress.com. Tema: Baskerville 2 por Anders Noren

Acima ↑

%d blogueiros gostam disto: