You should define user profile options whenever you want your application to react in different ways for different users, depending on specific user attributes.
To provide maximum flexibility, user profiles exist at Site, Application, Responsibility and User levels. When you define a profile option you decide whether your system administrator can set values for your option at each of these levels. You also decide whether your end users can view and update options you define at the User level. For example, you could define a VIEW_SECURE_INFORMATION option to be visible and updatable at all levels, so a system administrator could set values at any level, including values for individual users. You would also define the option such that your end users could not see or change its value.
Oracle Application Object Library provides many options that your users can set according to their needs. You can use these options, and profile options you define, in your application forms and concurrent programs.
Oracle Application Object Library provides many user profile options that the Oracle System Administrator or the users can see and update. The Oracle System Administration Reference Manual contains a complete list of predefined profile options.
Oracle Application Object Library also provides a set of profile options that you can access via the user profile routines. You can retrieve values for these profile options in your forms and programs; however, except for the profiles CONC_PRINT_OUTPUT and CONC_PRINT_STYLE, you cannot change their values. System administrators and end users cannot see the values for, nor change the values of, these profile options.
| USERNAME | Your user's current Oracle Application Object Library username. |
| USER_ID | Your user's current Oracle Application Object Library user ID. |
| RESP_ID | Your user's current responsibility ID. |
| APPL_SHRT_ NAME | The short name of the application connected to your user's current responsibility. |
| RESP_APPL_ID | The application ID of the application connected to your user's current responsibility. |
| FORM_NAME | The name of the current form. Not available for concurrent programs. |
| FORM_ID | The form ID of the current form. Not available for concurrent programs. |
| FORM_APPL_ NAME | The name of the application for which the current form is registered. Not available for concurrent programs. |
| FORM_APPL_ID | The application ID of the application for which the current form is registered. Not available for concurrent programs. |
| LOGON_DATE | Your user's logon date for the current session. |
| LAST_LOGON_ DATE | Your user's logon date for the previous session. |
| LOGIN_ID | Your user's Sign-On Audit login ID in Oracle Application Object Library. |
| CONC_ REQUEST_ID | The request ID associated with a particular instance of your running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the REQUEST_ID Who column. |
| CONC_ PROGRAM_ID | The program ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_ID Who column. |
| CONC_ PROGRAM_ APPLICATION_ ID | The application ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_APPLICATION_ID Who column. |
| CONC_LOGIN_ ID | The login ID associated with a running concurrent program. You can only use this profile option in a concurrent program. You can use this profile option to fill the LAST_UPDATE_LOGIN Who column. |
| CONC_PRINT_ OUTPUT | The value Yes or No that you enter in the Print Output field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option for a particular instance of your running concurrent program. This profile option determines whether the concurrent managers print the concurrent program's output to the printer. |
| CONC_PRINT_ STYLE | The print style of your concurrent program's output that you enter in the Print Style field when you register a concurrent program. You can use the routine afpoput() from your concurrent programs to change the value of this profile option for a particular instance of your running concurrent program. |