How To Import A Sales Order With One Line In Booked Status

Applies to:

Oracle Purchasing - Version: 11.5.10 to 12.0.6 - Release: 11.5 to 12
Information in this document applies to any platform.

Goal:

How to Import the Requisition ordered by Line Number ?

Solution:

Please use the script. below to insert the header and lines by populating the order import interface:

-- Insert a Sales Order Header
INSERT INTO OE_HEADERS_IFACE_ALL (
order_source_id
,orig_sys_document_ref
,creation_date
,created_by
,last_update_date
,last_updated_by
,operation_code
,sold_to_org_id
)
VALUES (
1227 --order_source_id
,'12345' --orig_sys_document_ref
,sysdate --creation_date
,-1 --created_by
,sysdate --last_update_date
,-1 --last_updated_by
,'INSERT' --operation_code
,1005 --sold_to_org_id
);

-- Insert a Sales Order Line
INSERT INTO OE_LINES_IFACE_ALL (
order_source_id
,orig_sys_document_ref
,orig_sys_line_ref
,inventory_item_id
,ordered_quantity
,operation_code
,created_by
,creation_date
,last_updated_by
,last_update_date
)
VALUES (
1227 --order_source_id
,'12345' --orig_sys_document_ref
,'1' --orig_sys_line_ref
,249 --inventory_item_id
, 10 --ordered_quantity
, 'INSERT' --operation_code
, -1 --created_by
, sysdate --creation_date
, -1 --last_updated_by
, sysdate --last_update_date
);

-- To make the Order's Status is Booked.
INSERT INTO OE_ACTIONS_IFACE_ALL (
order_source_id
,orig_sys_document_ref
,operation_code
)
VALUES (
1227 --order_source_id
,'12345' --orig_sys_document_ref
,'BOOK_ORDER' --operation_code
);
commit;


Alternately, to book the order you can pass BOOKED_FLAG as 'Y' in OE_HEADERS_IFACE_ALL instead of passing data in the OE_ACTIONS_IFACE_ALL table.

-- Insert a Sales Order Header and make the Order's Status is Booked.
INSERT INTO OE_HEADERS_IFACE_ALL (
order_source_id
,orig_sys_document_ref
,creation_date
,created_by
,last_update_date
,last_updated_by
,operation_code
,sold_to_org_id
,booked_flag
)
VALUES (
1227 --order_source_id
,'12345' --orig_sys_document_ref
,sysdate --creation_date
,-1 --created_by
,sysdate --last_update_date
,-1 --last_updated_by
,'INSERT' --operation_code
,1005 --sold_to_org_id
,'Y' --booked_flag
);

-- Insert a Sales Order Line
INSERT INTO OE_LINES_IFACE_ALL (
order_source_id
,orig_sys_document_ref
,orig_sys_line_ref
,inventory_item_id
,ordered_quantity
,operation_code
,created_by
,creation_date
,last_updated_by
,last_update_date
)
VALUES (
1227 --order_source_id
,'12345' --orig_sys_document_ref
,'1' --orig_sys_line_ref
,249 --inventory_item_id
, 10 --ordered_quantity
, 'INSERT' --operation_code
, -1 --created_by
, sysdate --creation_date
, -1 --last_updated_by
, sysdate --last_update_date
);
commit;



Now run the Order Import Concurrent program.
 - Navigate to Orders, Returns -> Import Orders -> Order Import Request 
 - Select your Order Source from the LOV in the parameters form. 
 - Submit the concurrent request.

Note:
In a Vision Environment, this sample creates an order from the customer AT&T Universal Card (sold_to_org_id 1005) for Qty 10 of the item CM13139 (inventory_item_id 249). This is a very simple script. that assumes there are defaulting rules set up that will populate other required fields during Order Import, such as Order Type, Price List, Salesrep, etc, which are not passed to the interface table in this script.
* Add other columns or modify the insert script. as appropriate for testcase attempted, referring to the API Guide and eTRM.
* Set the value of order_source_id in all tables to your own order_source_id.
* Set the value of orig_sys_document_ref in all tables to a unique value for each order.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23739124/viewspace-662502/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23739124/viewspace-662502/