Predefined Value Sets (User, System Administrator, and Flexfields Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Predefined Value Sets

Many Oracle Applications reports use predefined value sets that you may also use with your flexfield segments. If your flexfield segment uses a value set associated with a Standard Request Submission report parameter, any changes you make to its value set also affect any reports that use the same value set. Also, your changes to Oracle Applications value sets may be overwritten by a future upgrade.

For backwards compatibility, Oracle Applications provides some predefined value sets, FND_DATE and FND_DATE4 that you can choose for your date segments. These special value sets ensure that you enter a properly-formatted date, instead of any set of characters, in your flexfield segment. FND_DATE provides a date format of DD-MON-YY, and FND_DATE4 provides a date format of DD-MON-YYYY. Both of these value sets have a validation type of None, so they accept any date value in the correct format. If your flexfield segment or report parameter uses FND_DATE or FND_DATE4, it must have a length of 9 or 11 characters (respectively) to avoid truncation of the dates. However, we recommend that you create your own date value sets for any new flexfield segments.

For backwards compatibility, Oracle Applications provides another predefined value set, NUMBER15, that you can choose for your numeric segments. This special value set ensures that you enter a positive or negative number, instead of any set of characters, in your flexfield segment. This value set has a validation type of None, so it accepts any positive or negative number value up to fifteen characters long (including the minus sign). If you use this value set, your flexfield strips any leading zeros from the values you enter and ensures that your numbers have only one decimal point ( . ). However, we recommend that you create your own number value sets for any new flexfield segments.

Predefined Value Sets

See Also