Update The Item Average Cost From Transaction Open Interface

Update The Item Average Cost From Transaction Open Interface

INSERT
INTO mtl_transactions_interface
(
source_code ,
source_line_id ,
source_header_id ,
process_flag ,
transaction_mode ,
creation_date ,
last_update_date ,
created_by ,
last_updated_by ,
inventory_item_id ,
organization_id ,
transaction_date ,
transaction_quantity ,
transaction_uom ,
transaction_type_id ,
transaction_interface_id ,
material_overhead_account ,
material_account ,
resource_account ,
overhead_account ,
outside_processing_account,
cost_group_id
)
SELECT ‘AvgCostUpdate’ ,
1 ,
1 ,
1 ,
3 ,
SYSDATE ,
SYSDATE ,
1010026 ,
1010026 ,
1137465 ,
606 ,
sysdate ,
0 ,
‘Ea’ ,
80 ,
mtl_material_transactions_s.nextval ,
17347 ,
17347 ,
17347 ,
17347 ,
17347 ,
1327
FROM dual;

INSERT
INTO mtl_txn_cost_det_interface
(
cost_element_id ,
level_Type ,
Organization_id ,
new_average_cost ,
transaction_interface_id,
last_update_date ,
creation_date ,
last_updated_by ,
created_by
)
VALUES
(
1 ,
1 ,
606 ,
20 ,
16032545,
sysdate ,
sysdate ,
1010026 ,
1010026
);

COMMIT;

Next step, Please query and submit these transactions from:
Inventory -> Transactions -> Transaction Open Interface, submit by selecting Tools -> Resubmit All.

Note: Ensure that you have the transaction managers (Inventory -> Setup -> Interface Managers – Material Transaction Manager) up and running.