0 Replies Latest reply on Jan 29, 2020 2:51 PM by Mary Grace Cruz

    ORA-06502 Error when migrating FND User passwords to hash mode sha-512

    Mary Grace Cruz

      Hi,

       

      I migrated our EBS user passwords using AFPASSWD and the log shows "System was successfully converted to hash mode", however there was ORA-06502 and all FND user passwords were not converted to hash mode during that time.   When the user reset their password, that's the only time their password get converted.

       

      I applied patch 28516072 as per Doc ID 2477954.1 and I wonder if I should migrate again our environment using "AFPASSWD -c apps -m SHA512 FULL" so that all our FND users gets converted?  Need your assistance please.

       

       

      Log from the first AFPASSWD password hashing migration:

      +----------------------------------------------------------------------------+

      Arguments

       

          AFPASSWD -c apps -m SHA512 FULL

      +----------------------------------------------------------------------------+

      Working...

      Oracle error -6502: ORA-06502: PL/SQL: numeric or value error: character string buffer too small has been detected in FND_WEB_SEC..Oo_GubvLLr15R.

      System was successfully converted to hash mode.

      AFPASSWD completed successfully.

       

      We are on EBS R12.2.5

      RDBMS 11.2.0.4

       

      Thank you in advance.

       

      -MaryGrace