We have an inbuilt function IS_NUMERIC in BI Publisher template builder. This function is mainly used to validate whether a given value is a numeric value or not. Based on that, this function will return either TRUE or FALSE.
We can format dates in BI Publishes in the following three different ways,
1. Formatting Date using Microsoft Word’s native date format mask.
2. Formatting Date using Oracle’s format-date function.
3. Formatting Date using Oracle’s abstract date format masks.
4. Format with Calendar. Lets me now explain little details about the above three ways, and below is the XML I am going to use in the below examples,
Conditional formatting can be used in the layout builder for various scenarios. Some of the scenario I could think of is,
1. Display/hide layout regions based on condition.
2. Display/hide boilerplate text based on condition.
3. Apply visual attributes based on condition.
4. Hide table row or column based on condition.
In the below paragraphs we will see how above scenarios can he achieved in BI Publisher.
I am an oracle EBS technical enthusiastic. I have hands full of experience on Oracle forms, reports, BI Publisher and also familiar with the Techno Functional aspects of Order 2 Cash and Manufacturing modules. The views expressed on this blog are my own and do not reflect the position of Oracle or any other corporation.