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

  • October 14, 2015 | 11 views