PL-SQL code to reset application user password
•By Amol Jadhav
PL-SQL code to reset application user password
Oracle apps Reset application user password from backend
SQL Querysql
1--
2DECLARE
3 v_user_name VARCHAR2 (30) := UPPER ('AMOL');
4 v_new_password VARCHAR2 (30) := 'welcome1';
5 v_status BOOLEAN;
6BEGIN
7 v_status :=
8 fnd_user_pkg.ChangePassword (username => v_user_name,
9 newpassword => v_new_password);
10 IF v_status = TRUE
11 THEN
12 DBMS_OUTPUT.put_line (
13 'The password reset successfully for the User:' || v_user_name);
14 COMMIT;
15 ELSE
16 DBMS_OUTPUT.put_line (
17 'Unable to reset password due to'
18 || SQLCODE
19 || ' '
20 || SUBSTR (SQLERRM, 1, 100));
21 ROLLBACK;
22 END IF;
23END;
24/
For more reusable queries, click https://lightseagreen-goldfish-206721.hostingersite.com/category/technologyblog/oracle/
Related posts:
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Form function attached to which responsibility and user
- Query to find the responsibility attached to user in oracle apps