My Oracle Support Banner

How to Create a Custom Username Policy (Doc ID 1057133.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle User Management - Version to 12.2.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Login Page, Registration Process


When using the "Employee Registration" Registration process to register an existing employee, the new username is created as the same as the email address defined in the HZ_PARTY table for this employee.

Oracle User Management supports customizable user name policy. A user name policy is used to determine the format for the username e.g. email or firstname.lastname or based on some business logic specific to the installation.

This Note will guide you to create and use a custom user name policy that generate the user name as the first part of the email address. for example, the user name will be extracted from the address "" as "mohamad".


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.