Oracle Applications Login Process

The general Oracle Applications login process involves the following general steps:

1. The ENCRYPTED_FOUNDATION_PASSWORD and ENCRYPTED_USER_PASSWORD are retrieved from FND_USER if the account exists and is active. 

SELECT

  encrypted_foundation_password,

  encrypted_user_password,

  user_name

FROM

  fnd_user

WHERE

  user_name = 'OPERATIONS'

2. The APPS password is obtained from ENCRYPTED_FOUNDATION_PASSWORD by using the username and password as the decryption key. 

3. The user password is decrypted from ENCRYPTED_USER_PASSWORD by using the APPS password as the decryption key. 

4. The decrypted user password is compared to the entered user password.