Application of Oracle API profile

In Oracle, user-related configuration information can be obtained through the Fnd_profile package and the FNDSQF library, which can have the following two applications:

1. Gets the value of the relevant profile for the user in the current running environment;

2. You can set the user's relevant configuration in the current operating environment.

We can get what we want by invoking the various objects in this API.

1. Put is used to specify the relevant configuration information for the user:

begin   fnd_profile.put ('profile_name'new_value ' ); End;

2.get get the profile value:

DECLARE varchar2 (+);   begin   fnd_profile.get ('profilename', profile_name); End;

3.value get the profile value:

Select fnd_profile.value ('gl_set_of_bks_id' from dual;

4. Common User Profile Name:

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

Instance of your running current program. You can have only the use of this profile option in a concurrent program. The request_id who column is the "This" option to fill.

conc_program_id

The program ID is associated with a running. You can have only the use of this profile option in a concurrent program. The program_id who column is the "This" option to fill.

conc_program_application_id

The application ID associated with a running. You can have only the use of this profile option in a concurrent program. The program_application_id who column is the "This" option to fill.

conc_login_id

The login ID associated with a running concurrent program. You can have only the use of this profile option in a concurrent program. You can use this profiles option to fill the last_update_login who column.

Conc_print_output

The value Yes or No so you enter in the Print Output field when you register a concurrentprogram. You can use the routine afpoput () fromyour concurrent programs to change the value ofthis profile option for a particular Instance of yourrunning concurrent program. This profiles optiondetermines whether the concurrent Managers printthe concurrent program's output to the printer.

Conc_print_style

The print style. of your concurrent program ' soutput, that's you enter in the Print Style. Field Whenyou register a concurrent program. You can usethe routine-afpoput () from your concurrentprograms to change the value of this profile option

Application of Oracle API profile