Description:
Profile Option values control the behavior of Oracle Apps; in other words, they determine how Oracle Apps should run. The value for a profile option can be changed at any time.
Oracle API’s are used to load custom profile options and values. The custom profile option and values parameters can be passed to the below API to insert data to Oracle standard tables fnd_profile_options and fnd_profile_option_values.
- fnd_profile_options_pkg.insert_row
- fnd_profile_option_values_pkg.insert_row
Sample script with description to upload the profile option is explained below.
fnd_profile_options_pkg.insert_row
( x_rowid => v_rowid,
x_profile_option_name => ‘TEST_PROFILE’,
x_application_id => 200,
x_profile_option_id => 1010900,
x_write_allowed_flag => ‘Y’,
x_read_allowed_flag => ‘Y’,
x_user_changeable_flag => ‘Y’,
x_user_visible_flag => ‘Y’,
x_site_enabled_flag => ‘Y’,
x_site_update_allowed_flag => ‘Y’,
x_app_enabled_flag => ‘Y’,
x_app_update_allowed_flag => ‘Y’,
x_resp_enabled_flag => ‘Y’,
x_resp_update_allowed_flag => ‘Y’,
x_user_enabled_flag => ‘Y’,
x_user_update_allowed_flag => ‘Y’,
x_start_date_active => SYSDATE,
x_sql_validation => NULL,
x_end_date_act => NULL,
x_user_profile_option_name => ‘Test Profile’,
x_description => ‘Profile for tsting’,
x_creation_date => SYSDATE,
x_created_by => -1,
x_last_update_date => SYSDATE,
x_last_updated_by => -1,
x_last_update_logi => -1,
x_hierarchy_type => ‘SECURITY’,
x_server_enabled_flag => ‘N’,
x_server_update_allowed_flag => ‘N’,
x_org_enabled_flag => ‘N’,
x_org_update_allowed_flag => ‘N’,
x_serverresp_enabled_flag => ‘N’,
x_serverresp_upd_allow_fl => ‘N’ );
fnd_profile_option_values_pkg.insert_row
(x_rowid => v_rowid,
x_application_id => 200,
x_profile_option_id => 1010900,
x_level_id => 10001,
x_level_value => 0,
x_creation_date => SYSDATE,
x_created_by => -1,
x_last_update_date => SYSDATE,
x_last_updated_by => -1,
x_last_update_login => -1,
x_profile_option_value => ‘Y’,
x_level_value_application_id => NULL,
x_level_value2 => NULL);
Profile options and values will be created in the application, as shown below.
–SUDHAN S
Summary:
profile options and values API requests for working with conditional attributes.
queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
