Skip to main content

Hi All,
I recently performed an upgrade installation for a customer using version 24R2, and the installation was completed successfully. However, when attempting to log in to the application for the first time, it displays the message: "Account is disabled. Contact your administrator."

 

 

I have checked the account status from the database, and the account is not active. I updated the status to active by modifying the FND_USER_TAB table. However, I still cannot log in to the application.

 

I’d appreciate any guidance, best practices, or documentation links you could share on this topic.

Thanks in advance for your help!

Solution : If the IFSADMIN user becomes inactive or encounters issues, the following steps can be taken to resolve the problem:

  1. Check the Status of the IFSADMIN User Log in to the PDB as the SYS user and verify the status of the IFSADMIN user:

    SELECT * FROM FND_USER_TAB WHERE IDENTITY = 'IFSADMIN';

  2. Update the User's Status Execute the following query to set the ACTIVE column to TRUE for the IFSADMIN user:

    UPDATE FND_USER_TAB
    SET ACTIVE = 'TRUE'
    WHERE IDENTITY = 'IFSADMIN';

  3. Commit the Changes Save the changes to the database:

    COMMIT;

  4. Verification Re-run the SELECT query to confirm that the ACTIVE status for the IFSADMIN user has been updated to TRUE:

    SELECT * FROM FND_USER_TAB WHERE IDENTITY = 'IFSADMIN';

By following these steps, the IFSADMIN user should be successfully reactivated and operational.

Reply


Terms & ConditionsCookie settings