Oracle EBS R12: Grey out Descriptive Flexfield Segment (DFF)

The purpose of this article is to demonstrate on the technique to grey out a Descriptive flexfield (DFF) segment.

You may require to Grey out / Restrict entry in a DFF segment to serve any possible purpose in your business process mapping in any form of Oracle.

In order to grey out a descriptive flexfield segment, a special value set has to be setup and attached to the relevant DFF segment (which you want to grey out). The value set will be so set up that no data can be entered in it.

The setup of the Value set should be as follows:

grey-out-dff

Set the Validation type as Special and click on Edit Information button.

Setup the special validation routines as follows in the window that will open:

grey-out-dff2

The syntax shown in the screenshot above is as follows:

FND SQL “BEGIN NULL; END;”

Save the Value Set and attach it to any DFF segment that you want to grey out. The value set segment will be greyed out as follows:

Grey Out DFF.jpg

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s