Previous | Next | Contents | Index | Navigation | Glossary | Library |
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. |
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:
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:
Descriptive Flexfield Segments Window
Defining Key Flexfield Structures
Defining Descriptive Flexfield Structures
Previous | Next | Contents | Index | Navigation | Glossary | Library |