Tuesday, November 27, 2018

How to Unlock EBS apps user in R12

Hiya Buddies!!!
We would like to share a simple and easy topic as how to unlock EBS apps user in R12.1.3

There are two methods, we can do it either from front-end or back-end.
Here, we would like to share the code which we have done in Production and worked fine. So, there is no doubt.

But we need to change the user and password as per our request username and password.

Here, for example in our case username is ora-data which status is as LOCKED.
If you want to change it from back-end then you can run the below command from apps user.

SQL> select name from v$database;
NAME
---------
ORA-DATA

SQL> show user
USER is "APPS"
SQL>

SQL>
DECLARE
    status BOOLEAN;
BEGIN
    status := FND_USER_PKG.CHANGEPASSWORD(username => 'ora-data', newpassword => 'welcome1234');
    IF status
    THEN
                   DBMS_OUTPUT.PUT_LINE('Password changed and user unlocked');
    commit;
    ELSE
        DBMS_OUTPUT.PUT_LINE('Error while setting password');
    END IF;
END;
/
PL/SQL procedure successfully completed.
SQL>

This type of request is usually used to come from the either application team or developer team. So, this is a type of daily DBA task activities.
And this is very easy way to change because as we know that changing from front-end , it is like headache because front-end always takes time to load and sometimes java issue doesn't support etc...

Hope this may useful and helpful. For any concerns please let us know either in comment box or Contact Us above.

Some more useful links:

No comments:

Post a Comment