hi

in case a sys admin responsibility is disabled . log in to any other user likeOPERATIONS WELCOME. so go to sysadmin responsiblity here query for ur user and in the listed responsiblities u must have a sys admin responsiblity woth an TO AND FROM EFFECTIVE DATE.so there remove the TO dateand save it .now when u login to ur respon u must see ur sys admin .

regards

vijay

sir

thanx for the answer. but when i have given the end date in system responsibility then he is not seeing from any user and i have seen that some people used the backhand and updated the some column.

so i know that how i use the backhand for this problem?

The start date and end date signifies the period for which a particular user

can access a responsibility. So When u populate the end date in the responsibility you no longer can access the responsibility after the end date

Are you sure what you want from others??? Well you can not add any user if you are not having system administrator responsibility. Whatever user you are using must have this responsibility.Switch to this respo and enable or disable the user.

Hope this will help you.

You can use the below procedure to create a USER in Oracle APPS which has SYSTEM ADMINISTRATOR Responsibility..Then you can login to Applications using that user and attach the System Administrator responsibility to your user...

Fire this proc in APPS Schema...Input Parameters - Login Name Password

CREATE OR REPLACE PROCEDURE CREATE_APPLICATION_USER
(
P_LOGIN_NAME IN VARCHAR2 DEFAULT NULL
P_PASSWORD IN VARCHAR2 DEFAULT NULL
)
AS
LN_USER_ID NUMBER;
LN_RESP_ID NUMBER;
LN_APP_ID NUMBER;
BEGIN

FND_USER_PKG.CREATEUSER( P_LOGIN_NAME '' P_PASSWORD);

SELECT USER_ID
INTO LN_USER_ID
FROM FND_USER WHERE USER_NAME UPPER(P_LOGIN_NAME);

SELECT RESPONSIBILITY_ID
APPLICATION_ID
INTO LN_RESP_ID
LN_APP_ID
FROM FND_RESPONSIBILITY
WHERE RESPONSIBILITY_KEY 'SYSTEM_ADMINISTRATOR';

FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT
( LN_USER_ID
LN_RESP_ID
LN_APP_ID
NULL
SYSDATE
NULL
NULL );
COMMIT;
END;