Hi Seniors,

I have created an ADMIN form through which i can create a userS using the PL/SQL CATRIDGES.

The Problem is...

i want to set the password_date as NULL in FND_USER when i am Updating the password in the custom admin form.
so how would i compare the current password and Updated password for asking the USER to enter the NEW PASWORD(Your password has expired).

DECLARE
   v_user_pass_current  varchar2(510);
   v_user_pass_updated  varchar2(510);
BEGIN

   /* current password */
   
   SELECT ENCRYPTED_USER_PASSWORD INTO v_user_pass_current
   FROM FND_USER 
   WHERE USER_NAME = 'SEENU';
   
   /* Updated Password */
   
   SELECT ENCRYPTED_USER_PASSWORD INTO v_user_pass_updated
   FROM FND_USER 
   WHERE USER_NAME = 'SEENU';
   
   IF   v_user_pass_current = v_user_pass_updated THEN
     NULL;
   ELSE
     NULL;
   END IF;
END;

    OR ( If i DECRYPTING THE PASSWORD )

DECLARE
   v_user_pass_decrypt_current  varchar2(510);
   v_user_pass_decrypt_updated  varchar2(510);

BEGIN

   SELECT(
   SELECT fnd_web_sec.decrypt(
   UPPER((SELECT upper(fnd_profile.value('GUEST_USER_PWD')) FROM dual))
   ,usertable.encrypted_foundation_password)
   FROM dual ) AS apps_password
   FROM    fnd_user usertable
   WHERE   usertable.user_name LIKE upper(
       (SELECT    substr(fnd_profile.value('GUEST_USER_PWD'),1,instr(fnd_profile.value('GUEST_USER_PWD'),'/')-1)
   FROM dual)  )
   
   IF   v_user_pass_decrypt_current = v_user_pass_decrypt_updated THEN
       NULL;
   ELSE
       NULL;
   END IF;
END;

But i am getting the problem when i execute this function

SQL> select fnd_web_sec.decrypt('GUEST','ZGF1234ABBF8CCB6886106A8FFD5354414798E3394AF94986D7350D255D
1E6CF79EBBF0ED27FE0265213CE0BA47EF8D657D7') from dual
  2  /
select fnd_web_sec.decrypt('GUEST','ZGF1234ABBF8CCB6886106A8FFD5354414798E3394AF94986D7350D255D1E6CF
       *
ERROR at line 1:
ORA-00904: "FND_WEB_SEC"."DECRYPT": invalid identifier

    Thanks in Advance

    Regards
    Seenu

 Hi seniors,

  Would u pls tell that how would i change for PASSWORD_DATE  as NULL in FND_USER_PKG(UpdateUser Procedure).
  
  I just tried  but it is not Updating the Column ... 

  Thanks in Advance.

  Regards
  Seenu