f Get Oracle Apps Traning Here: Advanced Oracle Apps Training Index

This work is licensed under a Creative Commons -NonCommercial 2.5 License.



Thursday, November 02, 2006

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

Comments on "Advanced Oracle Apps Training Index"

 

Blogger Prabhu said ... (3:09 AM) : 

Hi 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

 

post a comment