O'Reilly logo

Oracle E-Business Suite R12 Core Development and Extension Cookbook by Andy Penver

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing complex validation

We are now going to perform some more advanced validation. The scenario is that we need to check that the e-mail address entered for the employee belongs to a specific domain. We are going to validate this by checking the domain of an e-mail address to ensure that it contains a specified string. First we are going to create a lookup that will contain valid strings that we will check for in our personalization. Then we will create a database function that will check the e-mail address on a WHEN-VALIDATE-RECORD trigger. If the string does not exist in the e-mail address, then a warning message will be displayed. So we are going to perform the following tasks:

  • Create a lookup
  • Call a database function from a condition ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required