Profiles are used to determine the behavior of Oracle Application Forms and Programs. The registration information of all the users will be stored in FND_PROFILES_OPTION table. The dictionary of all the Profile Options is maintained by AOL module. To set the values of the Profile Options, we use System Administrator Module. Profile Options are used to pass the values to the variables declared in our forms and programs, by which we can determine the behavior of Oracle Application Forms.
Note: There are 5316 types of profiles options are going to come with the package.
Each Profile Option has access at 3 levels.
1 User Access Level.
2 Program Access Level.
3 System Administrator Level