Jul 15, 2019

FND USER EBS Application Login creation with SYSTEM ADMINISTRATOR Responsibility

-------- Start of script --------------

DECLARE

  v_session_id INTEGER := userenv('sessionid');
  v_user_name  VARCHAR2(30) := upper('<FND LOGIN NAME>');

BEGIN

  --Note, can be executed only when you have apps password.
  -- Call the procedure to Create FND User

  fnd_user_pkg.createuser(
     x_user_name                  => v_user_name
    ,x_owner                         => ''
    ,x_unencrypted_password  => '<password>'
    ,x_session_number             => v_session_id
    ,x_start_date                  => SYSDATE - 10
    ,x_end_date                   => SYSDATE + 100
    ,x_last_logon_date        => SYSDATE - 10
    ,x_description                => 'Senthil Nathan'
    ,x_password_date          => SYSDATE - 10
    ,x_password_accesses_left        => 10000
    ,x_password_lifespan_accesses => 10000
    ,x_password_lifespan_days        => 10000
    ,x_employee_id                          => 53670 

/*Change this id by running below SQL*/

     /* 
     SELECT person_id
           ,full_name
     FROM   per_all_people_f
     WHERE  upper(full_name) LIKE '%' || upper('<ampersand>full_name') || '%'
     GROUP  BY person_id
              ,full_name
     */

    ,x_email_address => 'SenthilNathan.Ranganathan@orgcorp.com'
    ,x_fax                   => ''
    ,x_customer_id    => ''
    ,x_supplier_id      => '');

  fnd_user_pkg.addresp(username         => v_user_name
                                      ,resp_app          => 'SYSADMIN'
                                      ,resp_key          => 'SYSTEM_ADMINISTRATOR'
                                      ,security_group => 'STANDARD'
                                      ,description       => 'Auto Assignment'
                                      ,start_date        => SYSDATE - 10
                                      ,end_date         => SYSDATE + 1000);
END;
/

No comments:

Post a Comment

Useful Workflow Commands

  WFLOAD apps/columbus789 0 Y DOWNLOAD APEXP_FINDEV.wft APEXP Locations: $PO_TOP/patch/115/import/US/porpocha.wft $PO_TOP/patch/115/import/U...