Monday, July 11, 2011

JDev/ADF sample - Unique Key Validation for LOV Based on Reference Attribute

  • Unique Key Validation for LOV Based on Reference Attribute. While ago I was blogging how to Define LOV on a Reference Attribute in Oracle ADF 11g. Such type of LOV's are defined on description text, not on key. This approach works well, however there are some limitations when applying Unique Key business rule for such type of LOV's. Because LOV is based on read-only reference attribute, and Unique Key business rule is applied for LOV key, updated in the background - Unique Key business rule is not fired correctly for LOV based on reference attribute. I have tested this with JDev PS3, PS4 and R2 releases - same behavior is reproduced - Unique Key business rule is not working for such type of LOV's. User requirement is a must, and I will describe today how to implement Unique Key validation for LOV based on reference attribute, may be not exactly following ADF best practices.
    Download - UniqueKeyADFSample.zip

2 comments:

Senthil Nathan said...

Thanks for the wonderful info. I downloaded the code but while running it throws the error logon denied. Should I need to do anything ?

Andrejus Baranovskis said...

This sample is not using any security, should run fine without login.

Andrejus