A
responsibility is an important configuration which allows the user to navigate
to the various menus and form functions within that responsibility.Oracle API
is used to load responsibility from one instance to another instance.
The custom responsibility
parameters can be passed to the below API to insert data to Oracle standard
tables fnd_responsibility and fnd_responsibility_tl
*fnd_responsibility_pkg.insert_row
Sample script with description to upload the responsibility is explained below.
fnd_responsibility_pkg.insert_row
( x_rowid => v_rowid,
x_responsibility_id => fnd_responsibility_s.NEXTVAL,
x_application_id => 260, -- Cash
Management
x_web_host_name => NULL,
x_web_agent_name => NULL,
x_data_group_application_id => 260, -- Cash
Management
x_data_group_id => 0, --
Standard
x_menu_id => 1012396, -- CE_CASH_MANAGER
x_start_date => SYSDATE,
x_end_date => NULL,
x_group_application_id => NULL,
x_request_group_id => NULL,
x_version => 4,
x_responsibility_key => 'TEST_RESPONSIBILITY',
x_responsibility_name => 'Test Responsibility',
x_description => 'Responsibility for testing',
x_creation_date => SYSDATE,
x_created_by => -1,
x_last_update_date => SYSDATE,
x_last_updated_by => -1,
x_last_update_login => -1
);
--SUDHAN S
