The Example Projects for Oracle Intelligent Advisor Series 2022 : Product Recommendation

The Product Recommendation Example Project for Oracle Intelligent Advisor has a variety of interesting features that make it a good learning opportunity. Originally designed to showcase the Web Service Connector (aka the Connector Framework) it has also a good amount of relationship and entity manipulation which can really help learners get to grips with the ideas behind the terminology. In this Example Project, you will learn about collecting reference relationships and using filters to display certain members of a relationship, for example.

There is a video code-along demonstration at the end of this article where we will look at the features mentioned below. So let’s get into the Product Recommendation Example Project:

Time needed: 20 minutes

How to use the Product Recommendation Project in Oracle Intelligent Advisor

  1. How to use the Product Recommendation Project

    The idea is a really good one that everyone will be familiar with. You are talking to someone who want to purchase a Camera, and you are giving them advice based on a series of camera features that they want (flash, etc) and the products you have to offer them. At the end of the interview hopefully you are able to recommend a camera from your product list.

    Product Recommendations Example Project

  2. What does the Product Recommendation Project demonstrate

    This project demonstrates quite a few key features of Oracle Intelligent Advisor:
    Mapped Projects using a Connector
    Reference Relationships
    Relationship Collection
    Custom HTML and Styling for layouts
    PDF Order Form generation
    These are just the key elements, the rules also leverage the relationships to showcase the functions such as ForScope or IsMemberOf that often give new starters some headaches. A great rich source of learning!

  3. Adaptation Ideas for Product Recommendation

    There are several major areas where you could extend your reach. Starting at the bottom end in terms of complexity, you could of course add another attribute to the product definitions (tripod, or extra memory for example) and use that to increase the complexity of the product recommendation matrix and use IsMemberOf to detect which products are appropriate.
    You could also remove the custom HTML and CSS to create a more modern Relationship Extension Control. Finally, you could extend your knowledge of Oracle BI Publisher Analytics Desktop and customize the Order Form. And this is just to get you started!

  4. Upsides and Downsides

    When you first look at this project it might be a little overwhelming – there is so much to read about and understand! But breaking it down into layers – the data modeling and mapping layer, the business rule and entity layers, and finally the User Experience layer, means you have a really rich learning journey ahead of you!

If you want to watch a code-along video with me to see how to make some of the changes listed, here it is. You can also subscribe to our YouTube Channel.


Author: Richard Napier

After 8 years in case management and ERP software roles, Richard Napier joined Siebel Systems in 1999 and took up the role of managing the nascent Siebel University in Southern Europe. He subsequently was Director of Business Development and Education for InFact Group (now part of Business & Decisions) for 8 years. He now runs Intelligent Advisor IT Consulting OÜ. Owner of, he also is Co-Founder of the Siebel Hub.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Intelligent Advisor IT Consulting Serving Customers Worldwide
Hide picture