|Validation on DFF segments [message #273545]
||Wed, 10 October 2007 19:13
Registered: October 2007
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,