Profiles in Oracle Apps

Profile Options
OAF Profiles
FND : Diagnostics (FND_DIAGNOSTICS
FND: Personalization Region Link Enabled
FND: Personalization Document Root Path
Personalize Self-Service Defn
Disable Self-Service Personal
AP Profiles
AP: Use Invoice Batch Controls
AP: Invoice Approval Workflow User
Multi-Org Profiles
MO: Operating Unit
MO: Security Profile
MO: Default Operating Unit
HR:User Type
HR: Security Profile
GL Ledger Name
GL Ledger ID
DBA Specific
Applications Help Web Agent
Applications Servlet Agent
Applications Web Agent
Concurrent: Active Request Limit
Concurrent: Hold Requests
Concurrent: Multiple Time Zones
Concurrent: Report Access Level
Concurrent: Report Copies
Concurrent: Request priority
Database Instance
Enable Security Group
FND: Debug Log Filename
FND: Debug Log Level
Forms Runtime Parameters
Gateway User ID
ICX: Discoverer Launcher
ICX: Forms Launcher
ICX: Report Launcher
ICX: Limit Connect
ICX: Limit time
ICX: Session Timeout
Node Trust Level
RRA: Delete Temporary Files
RRA: Enabled
RRA: Service Prefix
RRA: Maximum Transfer Size
Self Service Personal Home Page Mode
Sign-On: Audit Level
Signon Password Failure Limit
Signon Password Hard to Guess
Signon Password Length
Signon Password No Reuse
Site Name
Socket Listener Port
TCF: Host
TCF: Port
TWO TASK
Viewer: Text

Query to Identify the Profile Option Values 

SELECT DISTINCT POT.PROFILE_OPTION_NAME "PROFILE_CODE"

  , POT.USER_PROFILE_OPTION_NAME "PROFILE_NAME"

       , DECODE (a.profile_option_value

             , '1', '1 (may be "Yes")'

             , '2', '2 (may be "No")'

             , a.profile_option_value

              ) "PF_VALUE"

     , DECODE (a.level_id

             , 10001, 'Site'

             , 10002, 'Application'

             , 10003, 'Responsibility'

             , 10004, 'User'

             , 10005, 'Server'

             , 10006, 'Organization'

                       , a.level_id

              ) "LEVEL_IDENTIFIER"

     , DECODE (a.level_id

             , 10002, e.application_name

             , 10003, c.responsibility_name

             , 10004, D.USER_NAME

             , 10005, F.HOST || '.' || F.DOMAIN

             , 10006, g.name

             , '-'

              ) "LEVEL_NAME"

FROM fnd_application_tl e ,

  fnd_user d ,

  fnd_responsibility_tl c ,

  fnd_profile_option_values a ,

  fnd_profile_options b ,

  fnd_profile_options_tl pot ,

  fnd_nodes f ,

  hr_all_organization_units g

WHERE 1=1

AND UPPER(pot.USER_PROFILE_OPTION_NAME) LIKE UPPER('MO: Default Operating Unit')

AND pot.profile_option_name = b.profile_option_name

AND b.application_id        = a.application_id(+)

AND b.profile_option_id     = a.profile_option_id(+)

AND a.level_value           = c.responsibility_id(+)

AND a.level_value           = d.user_id(+)

AND a.level_value           = e.application_id(+)

AND a.level_value           = f.node_id(+)

AND a.level_value           = g.organization_id(+)

AND pot.LANGUAGE            ='US'

ORDER BY PROFILE_NAME ,

  LEVEL_IDENTIFIER ,

  LEVEL_NAME ,

  PF_VALUE

  ;