Description:
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
Summary:
Using the above query, you can create a User in Oracle application. Just pass username, password and email id as parameters and it will create a user.
queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
