SCM - Order Management | Forum profile

Can you run the program Reserve Orders and see what happens. You can infact call this program in your code rather than writing new. Also this SQL is going into exception: SELECT expiration_date INTO l_lot_expiration_date FROM mtl_lot_numbers WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id AND lot_number = p_lot_number; Check. Thanks Nagamohan Edited by: Nagamohan on Dec 17, 2009 6:03 PM

Hi, I am getting "Invalid Lot Number" error, do you have any idea? I gave correct lotnumber, sub inventory, locator and i have quantiry. i am not sure why i am getting. thanks

Hi Also, in Transact Move Order screen, we can see orders across OU.

Thanks Gandhi. I will make sure all the 6 attibutes are true, before inactivating the item. Thanks in Advance Karbi

Thank You NagaMohan, Do you have any specific document related to the same, or steps on how can i do the Qualifier be attached to Customer and Price List Regards Krishna

Thank you very much ,setup shipping tolerance as zero but not OK, for this SO have many order lines ,but only this order line can't split

Hello Everyone, Can anyone please help me to find out the Workflow Business Event name for the Order Management Price List? Thanks in advanced, Chandan

You can use the item import interface /api to do that. But make sure that 1) the item is not on any open sales order 2) not on open work order (either as parent or component) 3) not active on a bom 4) not on a open po / req 5) no onhand 6) not on any pending transactions Insert records in the item interface table with status=Inactive and transaction_type = Update Hope this answers your question Sandeep Gandhi Independent Consultant 513-325-9026

Hi Nagamohan, Can you please elaborate this ..? And sorry for late reply as I was on leave Thanks, Satyam

hi Can any one give a brief on the below statuses in OM header and Line Level. The below is the list Order Header Statuses Following is a list of all possible statuses assigned to an order header. • Active • Awaiting Invoice Interface - Incomplete Data • Awaiting Invoice Interface - On Hold • Awaiting Start Date • Booked • Cancelled • Closed • Customer Accepted • Draft • Draft - Customer Rejected • Draft - Internal...