The Example Projects for Oracle Intelligent Advisor Series 2022 : My Store App

We’re over half way through our guided tour of the sample projects! And after a short break we are able to return to our ongoing series of walkthroughs, videos and hints and tips to get the most out of these projects. Whether you be a consultant, an employee or just a curious individual, these articles hopefully let you understand what each example does, and also hopefully helps you identify areas to skill up in! Let’s talk about the My Store App.

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 My Store App Example Project:

Time needed: 20 minutes.

How to use the My Store App Project in Oracle Intelligent Advisor

  1. How to use the My Store App Project

    The concept behind the My Store App Example Project probably does not need much in the way of introduction – if you have ever had to return an item you purchased online, or wanted to know whether a particular store was near to you, then the four scenarios in this example project for Oracle Intelligent Advisor will certainly ring a bell:

  2. What does the My Store App Project demonstrate

    The project showcases three major Oracle Intelligent Advisor functionalities – location grabbing from the browser and associated calculations using Great Circle method (which are a great demonstration of using operators and functions in rules), entity functions like InstanceMinimum and InstanceMinimumIf, and interview goals. There is also a Form that can be generated to complete the returns process although we have spoken at length about Forms before, and it includes a signature captured during the interview.

    What looked like a very simple 6 Screen project actually has some very cool concepts in it, and they give us the ability to understand how to implement formulas (like the Great Circle Distance Calculation). To put it simply, how to calculate the distance between two points such as your current GPS location and the GPS coordinates of some other place (for example, a branch of the store).

    Any project that demonstrates Entity Functions is welcome in our book, so the examples here – to find the closest store to your location, for example – are great learning opportunities and we have covered them in our Relationships series. Finally the project uses a synthetic goal “the interview is complete” which is something you will see quite a lot when there are multiple options for a user to follow.

  3. Adaptation Ideas for My Store App

    The most obvious examples of adaptation are around the replacement of the Great Circle calculation by an external API. Whilst the rule-based version is very useful, there will come situations where it is more appropriate to use an external API, for example if the user can enter an address rather than simply using the current browser location, or where the user actually requires a travel time that is not “as the crow flies” but reflects some degree of knowledge about the road. For example, if you want to go to the park, Great Circle says it is 2 miles from here. But you know there is a railway line in the way, so you would have to walk to the railway crossing and then on to the park – totalling 2.3 miles.

    Regular readers of this site will remember that we have already used the Great Circle mapping to calculate distances between two airports thanks to another external API, as seen in another of our customized Travel Compensation projects. So we will add a call to Google and get the real distance and time to the branch, using the Distance Matrix API. Compare the two values obtained to see what we mean.

  4. Upsides and Downsides

    This is a fantastic project to learn about entities, entity functions and also some pretty cool rules to implement a calculation. The business scenario is about as well-known as they come, and it could quickly be converted to something different just with a little cosmetic work – for example “I need to visit my local library” or “I need to return a book” for example. If you are interested in the Google Distance Matrix example, please reach out and we can send you a Zip.

So what do we have for you in this video? We’ve got the walkthrough of the project, the explanation of the functions and rules, and we also convert the distance into a real-life estimation of distance and time based on traffic. 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