Defaulting Segment Values (User, System Administrator, and Flexfields Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Defaulting Segment Values

To set a default segment value:

1. If you want to set a default value for this segment, identify the type of value you need.

Your list contains only the default types that have formats that match your value set format type.

Valid types include:

Constant	The default value can be any literal value.
Current Date	The default value is the current date in the format DD-MON-YY or DD-MON-YYYY, depending on the length of the segment.
	`Maximum Date Size Format 9 DD-MON-YY 11 DD-MON-YYYY`
Current Time	The default value is the current time or the current date and time, depending on the length of the segment.
	`Maximum Time Size Format 5 HH24:MI 8 HH24:MI:SS 15 DD-MON-YY HH24:MI 17 DD-MON-YYYY HH24:MI 18 DD-MON-YY HH24:MI:SS 20 DD-MON-YYYY HH24:MI:SS`
Field	The default value is the current value in the field you designate in the Default Value field. The field must be in the same form as the flexfield.
Profile	The default value is the current value of the user profile option defined in the Default Value field.
Segment	The default value is the value entered in a prior segment of the same flexfield window.
SQL Statement	The default value is determined by the SQL statement you define in the Default Value field.

If you choose Current Date or Current Time, you skip the next field.

Attention: If you are using flexfields server-side validation, you cannot use form field references (:block.field). You must either remove your field references or turn off flexfields server-side validation using the profile option Flexfields:Validate on Server.

See:

Flexfields:Validate on Server

2. Enter a default value for the segment. Your flexfield automatically displays this default value in your segment when you enter your key flexfield window. You determine whether the default value is a constant or a context-dependent value by choosing the default type.

Your default value should be a valid value for your value set. Otherwise, when you use your flexfield for data entry, your flexfield displays an error message and does not use your invalid default value in your flexfield segment.

For each default type chosen in the Default Type field, the valid values for the Default Value field are:

Constant	Enter any literal value for the default value.
Field	The default value is the current value in the field you specify here. The field must be in the same form as the flexfield. Use the format :block.field.
Profile	The default value is the current value of the user profile option you specify here. Enter the profile option name, not the end-user name.
Segment	The default value is the value entered in a prior segment of the same flexfield window. Enter the name of the segment whose value you want to copy.
SQL Statement	The default value is determined by the SQL statement you enter here. Your SQL statement must return exactly one row and one column in all cases.

Attention: If you are using flexfields server-side validation, you cannot use form field references (:block.field). You must either remove your field references or turn off flexfields server-side validation using the profile option Flexfields:Validate on Server.

See:

Flexfields:Validate on Server

Defaulting Segment Values

To set a default segment value:

See Also