Endeca Integration with Oracle E-Business Suite

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:

 

 

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

 

Home page after Login:

 

 

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:

 

 

“Item Added Successfully” message is displayed

 

 

 

Shopping Cart

 

 

 

 

• 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:

 

 

Order Review Page:

 

 

Order Creation:

 

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

 

Order Confirmation:

 

 

Order in Order Management :

 

 

Order Lines in Order Management :

 

 

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.