Friday 22 November 2013

Add Responsibility For Oracle FND User

API - fnd_user_pkg.addresp
Example --
-- ----------------------------------------------------------
-- Add Responsibility to Oracle FND User
-- -----------------------------------------------------------
DECLARE
    lc_user_name                        VARCHAR2(100)    := 'ELANGO';
    lc_resp_appl_short_name   VARCHAR2(100)    := 'FND';
    lc_responsibility_key          VARCHAR2(100)    := 'APPLICATION_DEVELOPER';
    lc_security_group_key        VARCHAR2(100)    := 'STANDARD';
    ld_resp_start_date                DATE                        := TO_DATE('25-JUN-2013');
    ld_resp_end_date                 DATE                        := NULL;

BEGIN
     fnd_user_pkg.addresp
     (   username           => lc_user_name,
        resp_app             => lc_resp_appl_short_name,
        resp_key             => lc_responsibility_key,
        security_group  => lc_security_group_key,
        description         => NULL,
        start_date           => ld_resp_start_date,
        end_date            => ld_resp_end_date
    );

 COMMIT;
EXCEPTION
            WHEN OTHERS THEN
                        ROLLBACK;                         DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
/

SHOW ERR;
 


Another Way :
=================
select * from fnd_responsibility_tl
where responsibility_name like 'Payables%';

select * from fnd_user
where user_name like 'Elango%'

begin

fnd_user_resp_groups_api.insert_assignment(user_id => 1338 --26301 (11i)
,responsibility_id => 50922
,responsibility_application_id => 200
,security_group_id => 0
,start_date => SYSDATE - 1
,end_date => NULL
,description => ' ');

Commit;

end;

No comments:

Post a Comment