Create New User from Beckend

Sometimes when a Development Instance is Cloned from Production Instance, and if some Users is not available in Production Instance will not be available in Development instance after cloning. User can be generated through

 

API :fnd_user_pkg.createuser

DECLARE

   l_user_name         VARCHAR2 (100) := 'USER_NAME'; -- 'USER_NAME';

   l_pwd               VARCHAR2 (100) := 'password123';

BEGIN

   fnd_user_pkg.createuser (x_user_name         => l_user_name

                           ,x_owner             => 'FND'

                           ,x_unencrypted_password => l_pwd

                           );

   --commit;

   fnd_user_pkg.addresp (username            => l_user_name

                        ,resp_app            => 'SYSADMIN'

                        ,resp_key            => 'SYSTEM_ADMINISTRATOR'

                        ,security_group      => 'STANDARD'

                        ,description         => NULL

                        ,start_date          => SYSDATE

                        ,end_date            => NULL

                        );

   COMMIT;

END;