Validation on DFF segments

[lucky.kalisetti]

Hi All,

I 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, I 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 all 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.

I 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.

Could you please provide us your expert guidence on this.

Your earliest reply would be highly appreciated.

Thanks in advance,
Lakshman K

[rtagarra]

u can use the dependent lov for the segment...like u need to filter the other 3 segment values based on the 1st segment....so in the lov for other 3 segments u get valid values to choose and there is no need to do validation...if u still further assistance post all the details of ur requirement