Creating / Updating costs by Interface

In this article I will show how to create cost records by Interface.

Many companies need to replicate their costs to other organizations. This is due to the fact that its components or assemblies are manufactured in more than one organization. Oracle provides a request that copies costs to other organizations. 

Sem título

But sometimes the company needs more details, the option of using the interface allows you to copy your costs in another way. The example below shows how to use the interface. 

INSERT INTO cst_item_cst_dtls_interface (inventory_item_id,
 organization_id,
 cost_type_id,
 cost_element_id,
 item_cost,
 process_flag,
 transaction_type,
 basis_factor,
 basis_type,
 net_yield_or_shrinkage_factor,
 last_update_date,
 usage_rate_or_amount,
 resource_id,
 group_id)
 VALUES (pi_inventory_item_id,
 pi_org_dest,
 pi_cost_tp,
 pi_cost_element_id,
 pi_item_cost,
 1,
 'CREATE',  -- CREATE/UPDATE
 1,
 1,
 1,
 SYSDATE,
 pi_item_cost,
 pi_resource_id,
 pi_grupo_id);

After that you need to launch the request below. 

Sem título1

The Group ID information is important to import only the records specified in the interface. 

I Holp this help.

Deixe uma resposta

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

Acima ↑

%d blogueiros gostam disto: