Create FND USER using API in Oracle Apps

Overview:

     This document help you to create FND USER using API in Oracle Apps.

API Name:

      FND_USER_PKG.CREATEUSER

For example: Below example create FND USER --

DECLARE

     lc_user_name  VARCHAR2(90) := 'XX007MN';

     lc_password    VARCHAR2(90) := 'WELCOME123';

     ln_session_id   NUMBER    := userenv('sessionid');

BEGIN

     fnd_user_pkg.createuser( x_user_name                    => lc_user_name,

                                          x_owner                          => NULL,

                                           x_unencrypted_password  => lc_password,

                                          x_session_number           => ln_session_id,

                                          x_start_date                    => sysdate,

                                          x_end_date                      => NULL,

                                          x_email_address              => NULL

                                         );

  COMMIT;

        dbms_output.put_line('User: ' || lc_user_name || ' Created Successfully');

EXCEPTION

       WHEN OTHERS THEN

            dbms_output.put_line('Unable to create User due to' || SQLCODE || ' ' || SUBSTR(SQLERRM, 1, 100));

    ROLLBACK;

END;

/

After script completed successfully, check data in base table of User:

SELECT * FROM fnd_user WHERE user_name = 'XX007MN';