Making a DFF Segment read only through ‘Special’ type of Value Set

By | April 7, 2014 | 4,709 views | Category: AOL and SYSADMIN

We can make a DFF segment read only by restricting the segment with a valuset of ‘Special’ type.

Steps to create ‘Special’ type of value set:

Create a value set with name “XX_READ_ONLY_VS” and Validation Type as “Special”. Click on “Edit Information’ button and enter the below block of code in under ‘Edit’ and ‘Validate’ event

FND SQL "BEGIN NULL; END;"

ReadOnly_Value_Set

Configure the DFF Segment with this value set to make then DFF segment as read only from application.
Here in this example I have configured two segments of “Additional Person Details” DFF with “XX_READ_ONLY_VS” value set and you can see in the below screen shot that the segments are now read only.

ReadOnly_DFF_Segments

Alternatively, you can also make the entire DFF segments read only through CUSTOM.PLL

WOW! Did you like this post? We'll send more interesting posts like Making a DFF Segment read only through ‘Special’ type of Value Set to you!
Enter your Email Address: