Monday, September 24, 2012

Orders Autobook

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
   );


5 comments:

  1. 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 ..?

    ReplyDelete
  2. I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

    Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91-9581017828 | http://www.oracleappstechnical.com

    Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

    ReplyDelete
  3. your 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.
    Oracle Fusion HCM Technical Coaching

    ReplyDelete
  4. Hi,
    This is very nice blog.
    Thanks for sharing such a blog.
    oracle fusion SCM online training

    ReplyDelete
  5. 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
    training every day.


    Oracle fusion HCM Online Training

    Oracle Fusion HCM Training

    ReplyDelete