Home » Applications » Oracle Fusion Apps & E-Business Suite » Validation on DFF segments (Validation on DFF segments)
Validation on DFF segments [message #273545] Wed, 10 October 2007 19:13
lakshman.kalisetti
Messages: 1
Registered: October 2007
Junior Member
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
Previous Topic: Material required for Repots and Forms
Next Topic: Question about Report Export
Goto Forum:
  


Current Time: Tue Dec 06 00:27:09 CST 2016

Total time taken to generate the page: 0.12863 seconds