Previous | Next | Contents | Index | Navigation | Glossary | Library |
:$FLEX$. value_set_name | Retrieves a value (the hidden ID value, if a hidden ID value is defined) in a prior segment. |
:$PROFILES$. profile_option | Retrieves the current value of a profile option. You must specify the option name of the profile option, such as GL_SET_OF_BKS_ID (which does not contain the Accounting Flexfield structure number). |
Note that your profile option must be set wherever you use this value set (including the View Requests form if this value set is used as a report parameter and the user tries to view the status of the report after submission), or your user will see error messages. | |
:block.field | Gets the current value in a field. You must ensure that this value set is only used for forms that have the same block.field. |
Warning: The :block.field mechanism is present for backward compatibility only. Value sets that use this mechanism will not be compatible with a future release of Oracle Applications.
For example, the following user exit on a Validate event obtains the Structure (NUM) of the key flexfield from a profile option:
FND VALID APPL_SHORT_NAME=SQLGL CODE="GL#" NUM=:$PROFILES$.MY_STRUCTURE_ID REQUIRED=Y VALIDATE=FULL ID=:!ID SEG=:!VALUE DESC=:!MEANING DINSERT=N
Previous | Next | Contents | Index | Navigation | Glossary | Library |