Sales Order Import (SO Conversion)
Sales Order Import (SO Conversion)
(OP)
Im going to import Sales Order from legacy system to Oracle ERP. All SOs to be converted will be in BOOKED status. Based on the documents I've read, if the SOs are in BOOKED status,the BOOKED_FLAG in the OE_HEADERS_IFACE_ALL is set to 'N' and an interface table called OE_ACTIONS_IFACE_ALL will be used and populated for all BOOKED sales orders.
Is this true? And during conversion also ,if some of the SOs are on hold,either in header or in the lines, this hold needs to be applied in Oracle.How am I going to applied holds during conversion?
Thanks.
Is this true? And during conversion also ,if some of the SOs are on hold,either in header or in the lines, this hold needs to be applied in Oracle.How am I going to applied holds during conversion?
Thanks.
RE: Sales Order Import (SO Conversion)
You also have ability to put on hold order header (whole order) or a line. Just set OPERATION_CODE to 'APPLY_HOLD' in the action table.
Hope it helps.
RE: Sales Order Import (SO Conversion)
Also one more question, I've read about order import's defaulting rules(e.g. shipping method, freight carrier, accounting rule, invoicing rule, etc. etc) which are being setup under OM.Does this means that If i don't have value ,e.g. shipping method, being pass to the interface table, the order import program will get the value in the setup done under defaulting rules.
Thanks again.