There could be certain case where client require to book the orders in bulk just by running single concurrent program. There's a public API provided by oracle to perform various operations in the sales order in the order management system.
Public API Name is : OE_ORDER_PUB
There are record type to hold the order header, line level informations.
Header_Rec_Type
Header_Tbl_Type
Header_Val_Rec_Type
Header_Val_Tbl_Type
Header_Adj_Rec_Type
Header_Adj_Tbl_Type
Line_Rec_Type
Line_Tbl_Type
Line_Val_Rec_Type
Line_Val_Tbl_Typ
Procedure Name : PROCESS_ORDER
Process Order supports action requests that allow users to execute a variety
of actions such as booking, hold application and removal.
OE_ORDER_PUB.PROCESS_ORDER
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_action_commit => FND_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data,
p_header_rec => p_header_rec,
p_header_val_rec => p_header_val_rec,
p_header_scredit_tbl => p_header_scredit_tbl,
p_line_tbl => p_line_tbl,
p_line_adj_tbl => p_line_adj_tbl,
p_line_scredit_tbl => p_line_scredit_tbl,
p_action_request_tbl => p_action_request_tbl,
x_header_rec => x_header_rec,
x_header_val_rec => v_header_val_rec,
x_header_adj_tbl => v_header_adj_tbl,
x_header_adj_val_tbl => v_header_adj_val_tbl,
x_header_price_att_tbl => v_header_price_att_tbl,
x_header_adj_att_tbl => v_header_adj_att_tbl,
x_header_adj_assoc_tbl => v_header_adj_assoc_tbl,
x_header_scredit_tbl => v_header_scredit_tbl,
x_header_scredit_val_tbl => v_header_scredit_val_tbl,
x_line_tbl => x_line_tbl,
x_line_val_tbl => v_line_val_tbl,
x_line_adj_tbl => v_line_adj_tbl,
x_line_adj_val_tbl => v_line_adj_val_tbl,
x_line_price_att_tbl => v_line_price_att_tbl,
x_line_adj_att_tbl => v_line_adj_att_tbl,
x_line_adj_assoc_tbl => v_line_adj_assoc_tbl,
x_line_scredit_tbl => v_line_scredit_tbl,
x_line_scredit_val_tbl => v_line_scredit_val_tbl,
x_lot_serial_tbl => v_lot_serial_tbl,
x_lot_serial_val_tbl => v_lot_serial_val_tbl,
x_action_request_tbl => v_action_request_tbl
);
Public API Name is : OE_ORDER_PUB
There are record type to hold the order header, line level informations.
Header_Rec_Type
Header_Tbl_Type
Header_Val_Rec_Type
Header_Val_Tbl_Type
Header_Adj_Rec_Type
Header_Adj_Tbl_Type
Line_Rec_Type
Line_Tbl_Type
Line_Val_Rec_Type
Line_Val_Tbl_Typ
Procedure Name : PROCESS_ORDER
Process Order supports action requests that allow users to execute a variety
of actions such as booking, hold application and removal.
OE_ORDER_PUB.PROCESS_ORDER
(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_action_commit => FND_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => v_msg_count,
x_msg_data => v_msg_data,
p_header_rec => p_header_rec,
p_header_val_rec => p_header_val_rec,
p_header_scredit_tbl => p_header_scredit_tbl,
p_line_tbl => p_line_tbl,
p_line_adj_tbl => p_line_adj_tbl,
p_line_scredit_tbl => p_line_scredit_tbl,
p_action_request_tbl => p_action_request_tbl,
x_header_rec => x_header_rec,
x_header_val_rec => v_header_val_rec,
x_header_adj_tbl => v_header_adj_tbl,
x_header_adj_val_tbl => v_header_adj_val_tbl,
x_header_price_att_tbl => v_header_price_att_tbl,
x_header_adj_att_tbl => v_header_adj_att_tbl,
x_header_adj_assoc_tbl => v_header_adj_assoc_tbl,
x_header_scredit_tbl => v_header_scredit_tbl,
x_header_scredit_val_tbl => v_header_scredit_val_tbl,
x_line_tbl => x_line_tbl,
x_line_val_tbl => v_line_val_tbl,
x_line_adj_tbl => v_line_adj_tbl,
x_line_adj_val_tbl => v_line_adj_val_tbl,
x_line_price_att_tbl => v_line_price_att_tbl,
x_line_adj_att_tbl => v_line_adj_att_tbl,
x_line_adj_assoc_tbl => v_line_adj_assoc_tbl,
x_line_scredit_tbl => v_line_scredit_tbl,
x_line_scredit_val_tbl => v_line_scredit_val_tbl,
x_lot_serial_tbl => v_lot_serial_tbl,
x_lot_serial_val_tbl => v_lot_serial_val_tbl,
x_action_request_tbl => v_action_request_tbl
);
if we want to perform the action of order autobooking ..means by fulfilling certain criteria the order shld be booked automatically ...how will we do that ..?
ReplyDeleteyour website gives the best and the most interesting information. This is just the kind of information that I had been looking from long time Thank you for sharing this blog.
ReplyDeleteOracle Fusion HCM Technical Coaching
Hi,
ReplyDeleteThis is very nice blog.
Thanks for sharing such a blog.
oracle fusion SCM online training
Oracle fusion HCM Training from ERPTREE gives you the best results to learn your dream course and maintains sufficient knowledge on oracle. It provides training by self-paced videos which are very helpful for the users to watch at any time according to their schedule. It is globally accepted and having many users undergoing
ReplyDeletetraining every day.
Oracle fusion HCM Online Training
Oracle Fusion HCM Training