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.

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.

      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


  1. if we want to perform the action of order autobooking ..means by fulfilling certain criteria the order shld be booked automatically will we do that ..?

  2. I am Sridevi Koduru, Senior Oracle Apps Trainer at 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 | | +91-9581017828 |

    Linkedin profile -

  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

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

  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