Sun. Oct 24th, 2021

Requirement: Let us assume, we have got an Oracle APEX page with an Interactive Grid in it.

The Interactive Grid will have data about the Employees.

In the Interactive Grid we have a column called Employment Type and the value of this column can either be Contractual or Permanent.

We have got another column called Variable Salary.

Now, when the value of the Employment Type column is Contractual, then the corresponding value in the Variable Salary is optional.

When the value of the Employment Type column is Permanent, then the corresponding value in the Variable Salary column is mandatory. In case the user has not provided any value of the Variable Salary column, immediately it should throw validation error for that particular row.

Sample output screen in shown below:

Solution: For solution of the above requirement follow the steps as shown below:

Step 1: Go to the Interactive Grid (Employee reports) > Right click on the VARIABLE_SALARY > Click Create Validation

Step 2: Set the following properties for the validation

  • Name: conditional_mandatory_validation
  • Validation Type: Column is NOT NULL
  • Validation Column: VARIABLE_SALARY
  • Type: Item = Value
  • Item: EMPLOYMENT_TYPE
  • Value: Permanent
  • Execute Condition: For Each Row

Save all and run the application. And with that we can see the screen is working as per our expected requirement.

Hence, the solution to our requirement.

If you like the post please comment, share, and do join me on Facebook. Please subscribe to my YouTube Channel for video tutorials.

Thanks & Regards,
Susanto Paul

 813 total views,  10 views today

By Susanto Paul

Susanto is an Oracle ACE, a qualified MCA, MBA, and a highly-skilled Senior Oracle Specialist. He is an enthusiastic Blogger and YouTuber who helps learners to solve their complex problems more efficiently. He has 9+ years of experience in multiple technologies like AWS, Oracle ADF, Oracle APEX, Oracle JET, Oracle VBCS, Oracle IDCS, Oracle PL/SQL, Oracle Integration Cloud, Java, JDBC, Servlets, JSP, Spring, Hibernate, HTML5, CSS3, JavaScript, TypeScript, NodesJS, Angular, MySQL, Oracle WebLogic Server, JUnit, JMeter, Selenium Web Driver, etc. He is a certified: Oracle Certified Professional Java SE 6 Programmer, Oracle ADF 11g Certified Implementation Specialist, Oracle Cloud Platform Application Integration 2020 Certified Specialist, Oracle Cloud Infrastructure Foundations 2020 Certified Associate, and Oracle Cloud Infrastructure Developer 2020 Certified Associate

Leave a Reply

Your email address will not be published. Required fields are marked *