What is '$flex$ and '$profile$, What is the use of '$flex$'?

The syntax for both is,$flex$.value set name- It is used to retrieve the value used in previous value set and generally used in Table type value set.

$profile$.profile option name- It is used to retrive value for that profile option

$Flex$ is used when we need to return the Flex value contained by any AOL Vlauset or AOL object .

For Ex . $Flex$.<Valueset name> would return the value held by that valueset .

$profiles$. are used to get the values of environment variables like org_id or mfg_Organization_id etc which are related to the current apps environment.

Ex. $profiles$.org_id would return the operating unit which is active at that time for the user.

Why does Help->Tools->Examine ask for a password?

The profile option Utilities:Diagnostics is set to NO This profile option controls whether users can use the Examine utility. The password should be the APPS password.  

Latest Answer : Navigate to the Update System Profile Screen. (\ navigate profile system) - Select Level: Site - Query up Utilities:Diagnostics in the User Profile Options Zone. If the profile option Utilities:Diagnostics is set to NO, people with access to the Utilities ...