Is there a way to put a sales order line on hold via Order Import Process?
I have tried populating the data in oe_headers_iface_all, oe_lines_iface_all and oe_actions_iface_all but it won't put the sales order line on hold? Can it not be done this way?
Sample inserts, One Order, one line, one hold on that line.
insert into oe_headers_iface_all (order_source_id,orig_sys_document_ref,operation_code,org_id,order_type_id,created_by,creation_date,last_updated_by,last_update_date,force_apply_flag) -- need to test the force_apply_flag
Values (1022,'34309','UPDATE',2,1110,4214,sysdate,4214,sysdate,'Y');
INSERT INTO OE_LINES_IFACE_ALL (order_source_id,orig_sys_document_ref,orig_sys_line_ref,org_id, line_type_id,created_by,creation_date,last_updated_by,last_update_date,operation_code) --removed promise date