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!
Best answer by AshenR
Solution : If the IFSADMIN user becomes inactive or encounters issues, the following steps can be taken to resolve the problem:
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 WHEREIDENTITY = 'IFSADMIN';
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'WHEREIDENTITY = 'IFSADMIN';
Commit the Changes Save the changes to the database:
COMMIT;
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 WHEREIDENTITY = 'IFSADMIN';
By following these steps, the IFSADMIN user should be successfully reactivated and operational.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.