Monday, March 14, 2016

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;

No comments:

Post a Comment

Clear BNE Cache for WebADI Changes

It Sometime happens that WebAdi Changes doesn't reflect once migrated in controlled instances. Here are the quick steps(Generally perfor...