[SYS] Default Type: Profile

We have different value in Default Type in concurrent program parameter, Constant, Current Date, etc. I want to share about "Profile" in this post.

For Default Type Profile, the Default Value indicates Profile Name (In Application Developer responsiblity, Name field in Profile). Note that the User Profile Name is what we see in the System Administrator responsibility.

The value which returns to the concurrent program is the value for the Profile Name, either user, responsibility, or other levels.

SQL:

SELECT profile_option_name, user_profile_option_name
FROM apps.fnd_profile_options_vl
WHERE profile_option_name = 'MY_CUSTOM_PROFILE_NAME'

profile_option_name is referring to Profile Name, user_profile_option_name is referring to User Profile Name.