Script to change the oracle apps front end password.

Script to change the oracle apps front end password.

set serveroutput on;

DECLARE

   v_pwd                         VARCHAR2 (40);

BEGIN

   v_pwd := fnd_web_sec.change_password (p_user =>         'SANGU'

                                                                       ,p_new_pwd =>      'welcome123'

                                                                       );

   DBMS_OUTPUT.put_line ('pwd ' || v_pwd);

   IF (v_pwd = 'N') THEN

      DBMS_OUTPUT.put_line ('New Password Change' || ': ' || fnd_message.get

                                                                             ());

   END IF;

END;

/

How to Get the Active sessions of database in SQL Developer

How to Get the Active sessions of database in SQL Developer

Steps to get the active sessions.

1) Connect to the server through SQL Developer.

2) Click on ‘View’ menu.

3) Select Reports.

4) Open Data Dictionary Reports.

5) Open Database Administration.

6) Open Session.

7) Double-Click on Active Sessions.

Now you will get the list of all active sessions.