Invalid or unexpected user name entered: when trying to change password with FNDCPASS

Introduction :

FNDCPASS is an utility to change passwords of database schemas within the Oracle E-Business Suite.
For example, you can change the APPS password using FNDCPASS.You can also change other schema passwords in the EBS database using FNDCPASS. FNDCPASS can also be used to change the password of an application user (like sysadmin).

Error Faced :

Invalid or unexpected user name entered: <name>

This error could come in EBS Version 12.1 to 12.2

Reason :

The value for the field read_only_code was ‘B’ (Restricted) instead of ‘A’ (Enabled) for the newly created user.
Check the field “read_only_code” in the FND_ORACLE_USERID table.

Fix for the issue :

1. Set the read_only_flag to ‘A’ (Enabled) for the user ID in the FND_ORACLE_USERID table.

2. Try to change the password now with FNDCPASS.