Friday, August 5, 2011

Add Responsibility using Sqlplus

BEGIN
FND_USER_RESP_GROUPS_API.LOAD_ROW (
X_USER_NAME => 'ANATESH',
X_RESP_KEY => 'APPLICATION_DEVELOPER',
X_APP_SHORT_NAME => 'FND',
X_SECURITY_GROUP => 'STANDARD',
X_OWNER => 'SYSADMIN',
X_START_DATE => TRUNC (SYSDATE),
X_END_DATE => NULL,
X_DESCRIPTION => NULL,
X_LAST_UPDATE_DATE => TRUNC (SYSDATE));
COMMIT;
END;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect