Advanced Oracle Apps Training Index
| Dear All, In response to a query that I received asking "Once all the training index topics have been covered, will this blog be stopped?" Other readers might have had a similar question in mind. Just so that you know, once these topics have been exhausted, we will then work upon an "Advanced Apps Training" index, one that will have articles influenced by real life problems faced during implementation and their resolutions. Thanks |
posted by Anil Passi at 4:03 PM
Comments on "Advanced Oracle Apps Training Index"
-
Unknown said ... (3:09 AM) :
post a commentHi Anil,
I am running a Sales order cancellation program using oe_order_pub.process_order API. The flow status code changes to 'CANCELLED' where as the cancelled_flag still remains as 'N' I am passing the following values into the API. Please let me know where I am missing
l_header_rec := oe_order_pub.g_miss_header_rec;
t_header_adj_tbl.DELETE;
t_header_adj_val_tbl.DELETE;
t_header_price_att_tbl.DELETE;
t_header_adj_att_tbl.DELETE;
t_header_adj_assoc_tbl.DELETE;
t_header_scredit_tbl.DELETE;
t_header_scredit_val_tbl.DELETE;
t_out_line_tbl.DELETE;
t_line_val_tbl.DELETE;
t_line_adj_tbl.DELETE;
t_line_adj_val_tbl.DELETE;
t_line_price_att_tbl.DELETE;
t_line_adj_att_tbl.DELETE;
t_line_adj_assoc_tbl.DELETE;
t_line_scredit_tbl.DELETE;
t_line_scredit_val_tbl.DELETE;
t_lot_serial_tbl.DELETE;
t_lot_serial_val_tbl.DELETE;
t_action_request_tbl.DELETE;
l_index := 0;
FOR rec IN cur_header
LOOP
t_hdr_tbl := oe_order_pub.g_miss_header_rec;
t_hdr_tbl.flow_status_code := 'CANCELLED';
t_hdr_tbl.cancelled_flag := 'Y';
t_hdr_tbl.open_flag = 'N';
t_hdr_tbl.booked_flag = 'N';
t_hdr_tbl.change_reason := 'MISC';
t_hdr_tbl.operation := oe_globals.g_opr_update;
t_hdr_tbl.header_id := rec.header_id;
t_line_tbl (l_index) := oe_order_pub.g_miss_line_rec;
t_line_tbl (l_index).ordered_quantity := 0;
t_line_tbl (l_index).cancelled_quantity := rec.cancelled_quantity;
t_line_tbl (l_index).line_id := rec.line_id;
t_line_tbl (l_index).header_id := rec.header_id;
t_line_tbl (l_index).flow_status_code := 'CANCELLED';
t_line_tbl (l_index).change_reason := 'MISC';
t_line_tbl (l_index).operation := oe_globals.g_opr_update;
oe_order_pub.process_order
(p_api_version_number => 1,
p_init_msg_list => fnd_api.g_true,
p_header_rec => t_hdr_tbl,
p_line_tbl => t_line_tbl,
x_return_status => l_return_status,
x_msg_data => l_msg_data,
x_msg_count => l_msg_count,
x_header_rec => l_header_rec,
x_header_val_rec => l_header_val_rec,
x_header_adj_tbl => t_header_adj_tbl,
x_header_adj_val_tbl => t_header_adj_val_tbl,
x_header_price_att_tbl => t_header_price_att_tbl,
x_header_adj_att_tbl => t_header_adj_att_tbl,
x_header_adj_assoc_tbl => t_header_adj_assoc_tbl,
x_header_scredit_tbl => t_header_scredit_tbl,
x_header_scredit_val_tbl => t_header_scredit_val_tbl,
x_line_tbl => t_out_line_tbl,
x_line_val_tbl => t_line_val_tbl,
x_line_adj_tbl => t_line_adj_tbl,
x_line_adj_val_tbl => t_line_adj_val_tbl,
x_line_price_att_tbl => t_line_price_att_tbl,
x_line_adj_att_tbl => t_line_adj_att_tbl,
x_line_adj_assoc_tbl => t_line_adj_assoc_tbl,
x_line_scredit_tbl => t_line_scredit_tbl,
x_line_scredit_val_tbl => t_line_scredit_val_tbl,
x_lot_serial_tbl => t_lot_serial_tbl,
x_lot_serial_val_tbl => t_lot_serial_val_tbl,
x_action_request_tbl => t_action_request_tbl
);
Thanks and regards,
dass
dass.prabhu@gmail.com