Relationships – Inferred Containment Relationships

The second in our learning journey series, following on from our Containment Relationship video, concerns Inferred Containment Relationships. The first time you hear that sort of jargon, I can hardly blame people for thinking that maybe Oracle Intelligent Advisor isn’t really for business people after all! So this chapter in the series takes us into this concept. It is surprisingly simple once you get the hang of it (as are most things). But Inferred Containment Relationships do need bit of explanation.

Back to a learning scenario: Here is a project with a simple entity created to represent the purchases that you make in a supermarket. And a second entity to represent promotional messages that you might see on your receipt. I’m sure you know the sort of thing – when you look at your receipt, it is always full of messages telling you how you can save on certain products:

Our goal is to implement the promotional messages in Oracle Intelligent Advisor. According to the product(s) purchased, you will see different message(s). You will use an Inferred Containment Relationship to instance the right messages. You will start with a simple rule using InferInstance() or it’s long form version the relationship(the identifying attribute) exists.

Then you will edit the rule to impose conditions (certain pricing). Then you will extend the concept and use a special Word table to instance multiple messages according to the types of product. The video will guide you through all the steps and show you the result. The project itself is so small and easy that you can build it yourself as you follow along. The video is 20 minutes long, so you can use it to practice.

Finally if you are looking for more examples of using inferred containment relationships, you can see them in the Example Projects by filtering for Entities : inferred, or you can see the list on this page in the documentation and filter it in the browser.


The video above will help you understand Inferred Containment Relationships. If you have questions or ideas for the other videos in this series, please add a comment!

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