Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, August 13, 2015

EBS 11i Add resposibility api

Find the necessary details for a particular responsibility:

 SELECT fa.application_short_name,
    FROM apps.fnd_responsibility fr,
                apps.fnd_application fa,
                apps.fnd_security_groups frg,
                apps.fnd_responsibility_tl frt
   WHERE fr.application_id = fa.application_id
     AND    fr.data_group_id = frg.security_group_id
     AND    fr.responsibility_id = frt.responsibility_id
     AND    frt.responsibility_name = 'RESP_NAME_HERE'

  fnd_user_pkg.addresp (username          => v_user_name,
                                             resp_app           => v_application_name,
                                             resp_key            => v_responsibility_key,
                                             security_group => v_security_group,
                                             description        => v_description,
                                             start_date          => SYSDATE,
                                             end_date            => NULL

SQL> exec fnd_user_pkg.addresp('SHAIKS','XXSSHAIK','RESP_NAME_HERE,'STANDARD',null,sysdate,NULL);

PL/SQL procedure successfully completed.


Commit complete.

No comments: