sqlplus / as sysdba
select owner, table_name from dba_tables where table_name = upper('wwv_flow_fnd_user');
-- Change schema name to whatever you want
ALTER SESSION SET CURRENT_SCHEMA = APEX_050100;
set lines 100
COLUMN user_id Format 99999999999999999
COLUMN user_name FORMAT A20
COLUMN default_schema FORMAT A30
-- Change user name to whatever you want
SELECT user_id,
user_name,
default_schema
FROM wwv_flow_fnd_user
WHERE user_name = 'ADMIN'
ORDER BY last_update_date DESC;
-- Change user name and user Id and <password> to whatever you want
UPDATE wwv_flow_fnd_user
SET web_password = '<password>'
WHERE user_name = 'ADMIN'
AND user_id = 1814258022160324;
COMMIT;
exit;
BEGIN
WWV_FLOW_SECURITY.g_security_group_id := 10;
WWV_FLOW_FND_USER_API.unlock_account('ADMIN');
COMMIT;
END;
/