Inventory Management - EBS (MOSC)

MOSC Banner

inv_move_order_pub.process_move_order not update mtl_material_transactions_temp

edited Mar 31, 2016 5:05AM in Inventory Management - EBS (MOSC) 2 commentsAnswered

after pick release, we would like to modify the staging subinventory for some of the lines

so we use the inv_move_order_pub.process_move_order to modify the line, but we found that the data at move order line (mtl_txn_request_lines) has been modified, but NOT the line during allocation (mtl_material_transactions_temp).

select * from mtl_txn_request_lines where line_id=100000000;

select t.transfer_subinventory, t.* from mtl_material_transactions_temp t where t.move_order_line_id=100000000;

   li_trohdr_rec.header_id := 10000;

   li_trohdr_rec.operation := inv_globals.g_opr_update;

   li_trohdr_rec.organization_id := 80;

Tagged:

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