Posts

Showing posts with the label LDAP

User Account in Suppressed Status

If you find that a worker's user account is in suppressed status, it means the username is already assigned to another user. Use following query to check the status of user account in LDAP. SELECT  PAPF.PERSON_NUMBER,         PPNF.LAST_NAME,         PPNF.FIRST_NAME,         PU.USERNAME,         PU.ACTIVE_FLAG,         LDAPU.REQUEST_STATUS,         LDAPU.USERNAME LDAP_USERNAME,         LDAPU.REQUEST_TYPE,         LDAPR.ACTIVE_FLAG LDAP_ACTIVE_FLAG,         LDAPR.REQUEST_DATE,         LDAPR.LDAP_REQUEST_ID FROM PER_ALL_PEOPLE_F PAPF,      PER_PERSON_TYPE_USAGES_M PPTUM,      PER_PERSON_NAMES_F PPNF,      PER_USERS PU,      PER_LDAP_REQUESTS LDAPR,      PER_LDAP_USERS LDAPU WHERE PAPF.PERSON...