Introduction

The last release of Oracle Fusion Applications (Release 13 19D) brings along a lot many features. One of them (particularly in the Reporting Area) is the “Mandatory Parameter” feature availability. This specific feature was being asked by consultants and customers for long and it is a delight to finally have this feature available. Prior to this consultants have to find alternatives where-in they had to display meaningful messages to achieve the same.

In this article, we will demonstrate how-to use the “Mandatory” parameter feature using a worked example.

Creating a Simple SQL Query

For this example we will use a very simple sql.

In the above SQL we have used two parameters namely Effective_Start_Date and Effective_End_Date and we would make both the parameters mandatory.

Now, we will try to run the Data Model (without providing values for “Mandatory” parameters). One important thing to observe here is that the moment we check the “Mandatory” option an ‘*’ gets placed before the parameter.

If we try to click ‘View” without entering any values for the “Mandatory” parameter we will get error.

Now if we enter values for both the parameters then data would be returned.

Conclusion

So, this is how we can make use of “Mandatory” feature of a BI Data Model parameter. This was a much needed feature and am glad that the same has been delivered now. 

Thanks all for your time and have a nice day.

Ashish Harbhajanka

Add comment