Create Responsibility API

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