Sunday, September 30, 2012

Terminologies We Should Know

As a Oracle apps Technical Consultant, These terminologies are often used by everyone.
Listing the terminologies over here

MIDDLEWARE:
Software provides services beyond those provided by OS.
It is integral modern information technology based on XML,SOAP,Web Services and SOA.
Middleware sits "in the middle" between application software . Middleware enables interoperability between applications that run on different OS.
example : EAI

EAI : Enterprise Application Integration
SCM, CRM, BI and other type of applications cannot communicate with one another in order to shared data or business rules.EAI is the process of linking such applications within single organization together in order to simplify and automate business process.
for 'N' application
N*(N-1)
------    connections are required.
  2   

EDI: Electronic Data Interchange
Structured transmission of data between organizations by electronic means. It is used to transfer electronic documents or business data from one computer system to another computer system, i.e. from one trading partner to another trading partner without human intervention.

TIBCO:
People tell TIBCO is a Software/Company name/Middleware. Which one is correct?
Everything is correct.They are leading provider of business integration solutions delivering infrastructure software that enables to seamlessly integrate business systems in real time.
They call the technology as "Information Bus" or TIB middleware.

SOAP: Simple Object Access Protocol
A better way to communicate in internet is using HTTP becoz HTTP is supported by all browsers and servers.SOAP provides a way to communicate between applications running on different operating systems, with different technologies and programming languages in distributed systems.

SOAP Message Structure
A SOAP message is an ordinary XML document containing the following elements
<?xml version="1.0"?>
<soap:Envelope
xmlns:soap="http://www.w3.org/2001/12/soap-envelope"
soap:encodingStyle="http://www.w3.org/2001/12/soap-encoding">

<soap:Header>
...
</soap:Header>

<soap:Body>
...
  <soap:Fault>
  ...
  </soap:Fault>
</soap:Body>

</soap:Envelope>

Yet to update this post.

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