Inventory Management - EBS (MOSC)

MOSC Banner

Can we update the list_price_per_unit from the Inventory Open Interface (IOI)

edited Dec 29, 2009 8:11PM in Inventory Management - EBS (MOSC) 1 commentAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center