Creating Business Group in oracle apps

Creating business group in oracle apps from Er Gurpreet singh

Defining Locations in Oracle Apps

Defing locations in Oracle Apps from Er Gurpreet singh

Reset the password of user in Oracle apps

To reset the password of a user in oracle apps run the following query:

DECLARE
X BOOLEAN ;
BEGIN
X:= FND_USER_PKG.CHANGEPASSWORD('XG63','welcome123');
IF X THEN
dbms_output.put_line('true');
COMMIT;
ELSE
dbms_output.put_line('flase');
END IF;
END;


Here XG63 is username and welcome123 is new password