Query to get long(current) Running SQL statement of Request in Oracle Applications:

 Query to get long(current) Running SQL statement of  Concurrent Request in Oracle Applications:

You need to pass request id for below SQL

SELECT sql_text, sql_fulltext
  FROM v$sqlarea
 WHERE sql_id =
          (SELECT b.sql_id
             FROM v$process a, v$session b
            WHERE     a.addr = b.paddr
                  AND a.spid = (SELECT oracle_process_id
                                  FROM fnd_concurrent_requests
                                 WHERE request_id = &concurrent_request_id));

How to Change Password in Oracle Apps

How change apps password from front end?

Once you login into Oracle Goto--> Preferences.

In that you page you should be able to see the option to change the password.

How change apps password from back end?

Use the following anonymous block

declare


v_user_name varchar2(30):=upper('USER123');
v_new_password varchar2(30):='Pass55word';
v_status boolean;

begin

v_status:= fnd_user_pkg.ChangePassword (username => v_user_name,
                    newpassword => v_new_password);

if

v_status =true then
dbms_output.put_line('The password reset successfully for the User:'||v_user_name);

commit;

else

DBMS_OUTPUT.put_line('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));

rollback;

END

if;

end;