Oracle Apps: Profile Option

Create a new Profile Option:

1. Login as "Application Developer" Responsibility. Go to Profile and create a new profile and save.

2. Login as "System Administrator" Responsibility. Go to Profile -> System. Serch for the name entered in the "user profile field" in step 1. Enter the value and save.

Getting the Profile option value in SQL:

Value := fnd_profile.value('Profile option name');