Can we update the list_price_per_unit from the Inventory Open Interface (IOI)
Hi
I am trying to update 27K records for the list_price_per_unit from the IOI but the records are not getting updated.
The process flag remains at 2 and runs for a long time.
Here is the code I used to insert into mtl_system_items_interface.
(xx_mas_upload_item_data is a custom load table which holds the master_list_price_per_unit.)
insert into mtl_system_items_interface
(process_flag ,set_process_id,transaction_type,inventory_item_id,organization_id,list_price_per_unit)
( select 1,90708,'UPDATE',b.inventory_item_id,b.organization_id ,master_list_price_per_unit
0