1 Reply Latest reply on Mar 25, 2016 1:26 PM by Bashar.

    CTXSYS Not found in fnd_oracle_userid

    Ramaraju

      Hi,

      CTXSYS user not found in fnd_oracle_userid table. Please advise how to register CTXSYS in fnd_oracle_userid table.

      We upgraded EBS 11i to R12.2.4

      EBS: 12.2.4

      DB: 11.2.0.4

       

      SQL> select oracle_username from fnd_oracle_userid where oracle_username like '%CTX%';

      no rows selected

       

      And we have CTXSYS user in dba_users table

      SQL> select username from dba_users where username like '%CTX%';

      USERNAME

      ------------------------------

      CTXSYS

       

      Thanks,

      Ramaraju