Oracle Apps Technical : Urgent help reqd in DFF

[lakshman.kalisetti]

Hi,

We need your expert guidence in implementing address validation in Oracle R12 HRMS form "PERACADR.fmb"
In this form person address is captured using the standard DFF "Personal Address Information".

This DFF is context sensitive. Address Type is the reference field.

In case of address types US and CAN, we need to have our customized validation on the segments like City, State, Country, Zip Code.

All the segments are attached with oracle supplied value sets.

In our case, while populating the list of values for any of the above four segments, we need to consider the remaining three segments.
Based on those three segments we need to do some validations and populate the list with valid data only.

We tried below steps to implement this...

1. Create new value sets based on our custom tables and assign them to all four segments.

2. Write Key-Listval trigger on all the four segments with following code...
a) call our custom procedures to populate the custom tables with valid values
b) populate the LOV using list_values

But after implementing the above changes, we identified that none of our triggers on DFF segments are getting executed.

We tried some other possiblities also, but could not make it.

Whenever user tries to see the list of values for any segment, data should be populated in our custom tables which are used in value set.
So this is a front-end item level action, which cannot be done using backend triggers.

Could you please provide us your expert guidence on this.

Your earliest reply would be highly appreciated.

Thanks in advance,
Lucky