Order Management - EBS (MOSC)

MOSC Banner

Is there a way to put a sales order line on hold via Order Import Process?

edited Oct 16, 2019 8:28AM in Order Management - EBS (MOSC) 7 commentsAnswered ✓

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

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