Use wfdirchk.sql to check for the following conditions in your directory service data model:

• Invalid internal names that contain the characters '#', ':', or '/' in WF_USERS.

• Invalid compound names in WF_USERS or WF_ROLES.

• Duplicate names in WF_USERS or WF_ROLES.

• Multiple names in WF_USERS or WF_ROLES linked to the same row in the original repository.

• Missing display names in WF_USERS or WF_ROLES.

• Invalid notification preference or null e-mail address if the notification preference is set in WF_USERS or WF_ROLES to receive e-mail.

• Invalid status in WF_USERS.

• Rows in WF_USERS that do not have a corresponding row in WF_ROLES.

• Invalid internal names in WF_ROLES that contain the characters '#' or '/' or have a length greater than 30 characters.

• Invalid user/role foreign key in WF_USER_ROLES.

• Missing user/role in WF_USER_ROLES. Every user must participate in its own role.

• Duplicate rows in WF_USER_ROLES.

Wfdirchk.sql should return no rows to ensure that your directory service data model is correct.

Use the script as follows:

sqlplus <user> @wfdirchk 
Enter password: <password>