Skip to main content
Solved

IFS Cloud 24R2 - IFSADMIN Account Disable

  • December 27, 2024
  • 1 reply
  • 142 views

AshenR
Hero (Partner)
Forum|alt.badge.img+9
  • Hero (Partner)
  • 101 replies

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:

  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.

View original
Did this topic help you find an answer to your question?

1 reply

AshenR
Hero (Partner)
Forum|alt.badge.img+9
  • Author
  • Hero (Partner)
  • 101 replies
  • Answer
  • December 27, 2024

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings