1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Application users can't login into oracle ebusiness suite11i except sysadmin can log

Discussion in 'Oracle Apps Technical' started by mramadhani, Feb 7, 2013.

  1. mramadhani

    mramadhani Active Member

    Messages:
    27
    Likes Received:
    3
    Trophy Points:
    185
    Location:
    Dar Es Salaam
    Dear all

    we have experienced login problem on our e-business suite11i.

    i have managed to clone prod to test instance, after being able to finish my end-users could not be able to login into test instance except sysadmin can login.

    please can anyone help me.....

    thanks in advanced

    Rama.
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: Application users can't login into oracle ebusiness suite11i except sysadmin can

    Have you checked the logs? Are the user accounts in the table? Are the accounts end dated? This could literally be almost anything...
     
  3. mramadhani

    mramadhani Active Member

    Messages:
    27
    Likes Received:
    3
    Trophy Points:
    185
    Location:
    Dar Es Salaam
    Re: Application users can't login into oracle ebusiness suite11i except sysadmin can

    Hi

    I have check all user accounts are in the table, but the issue is that, the user status is inactive.........
     
  4. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Re: Application users can't login into oracle ebusiness suite11i except sysadmin can

    Hi,

    Make the users Active and you can able to work it out.

    Check Select * from Fnd_user table and check end_date column is null...

    Cheers
    Kamal (kamal.love@gmail.com)

    Cheers
    Kamal
     
  5. mramadhani

    mramadhani Active Member

    Messages:
    27
    Likes Received:
    3
    Trophy Points:
    185
    Location:
    Dar Es Salaam
    Re: Application users can't login into oracle ebusiness suite11i except sysadmin can

    Hi Kamal
    Greetings!

    I have checked end_date column is surely null, but i wonder why users status is inactive state.
    i have also checked all concurrent is up....
    why my end-user can't login....?
    please help me
    Thanks
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Re: Application users can't login into oracle ebusiness suite11i except sysadmin can

    May be user has expired. Please check it from application end by querying with that particular user and we can check whether password expired or not
     
  7. mramadhani

    mramadhani Active Member

    Messages:
    27
    Likes Received:
    3
    Trophy Points:
    185
    Location:
    Dar Es Salaam
    Re: Application users can't login into oracle ebusiness suite11i except sysadmin can

    i have resolved the issue.....we had a problem in system date on Linux system
     
    Bharat likes this.