Endeca Integration with Oracle E-Business Suite

January 2, 2013 · Uncategorized

Oracle Endeca provides merchandisers and business users a web based tool set that manages the entire delivery of relevant customer experiences at all digital touch points. Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance.

 

Integration points are,

 

  • Registration
  • Login
  • Add to Cart
  • Shipping and billing
  • Order Creation

Login:

 

 

loginwithout.jpg

  On successful login, the custom API will fetch the user details from the FND tables and HZ tables to display information on home page.

 

loginforendeca.jpg

Home page after Login:

 login2.png

 

Add to Cart:

 

  • Items in the Endeca catalog are displayed from the Oracle inventory using  Endeca Pipeline feature. Custom API is used to add items to cart. On clicking Add to cart, items are stored in a custom table similar to ASO_QUOTE tables.

 On clicking “Add To Cart” button:

 addtocart.png

 

“Item Added Successfully” message is displayed

 

 itemadded.png

 

Shopping Cart

 

 shoppingcart.png

 

 

  • Custom API is used to display the information about shipping and billing from the HZ Tables
  • Shipping Information such as;
    Shipping Address.
    Shipping Method.
  • Billing Information such as;
    Billing Address.
    Payment Method.

Shipping and Billing Page:

 

shipping.png

 

Order Review Page:

 

orderreview.png

 

Order Creation:

 

  • Custom API along with Oracle standard order creation API is used for creating the orders.

 

Order Confirmation:

 

orderconfirm.png

 

Order in Order Management :

 

ordermanage.png

 

Order Lines in Order Management :

 

orderlines.png

 

Pro’s/Con’s Versus Endeca + iStore + EBS :

 

  Pro’s  :

 

  • All the benefits of Endeca
  •     Benefits include Guided Navigation, Fast and Easy search including product properties and Search Filter options.

        Rich UI, Search Engine friendly, easy to get SEO implemented, Search capabilities far superior, easy to categorize

        Benefits of Spring framework and MVC architecture

        Data is secure, over various pages. We cannot perform any action such as add to cart, login or place order directly         by using the url.

  • Fast Processing
  •    We can avoid various unnecessary actions during each processing of data, hence the overall system performance         will be faster

 

  Con’s  :

 

  •   For each inventory change, we need to update baseline data.