Descriptive Flexfields and Address Styles

Oracle HRMS supplies two predefined descriptive flexfields to hold address information in different styles for different countries. These are:

Oracle HRMS holds the addresses of people and locations separately to enable you to record different information for tax reporting.

You can use these descriptive flexfields to add new address styles or to change the styles included in Oracle HRMS.

Attention: If you change the predefined styles, your changes are overwritten when you upgrade Oracle HRMS. If you add new styles, your changes may be overwritten if new startup data contains address styles for these countries.

Address Styles

Address styles vary between countries, so Oracle HRMS provides descriptive flexfields that use context-sensitive segments to hold each line of an address. The Address Styles Flexfields table below details the title of the flexfield, its location and where it is used.

Address Style Flexfields in Oracle HRMS

Title Table Name Window Title
Personal Address Information PER_ADDRESSES Address, Applicant Entry
Location Address HR_LOCATIONS Location, Organization

The available address styles are defined as the contexts for these flexfields. There are two types of address style:

Address styles are provided as startup data in these flexfields. If you require additional address styles, you need to define a new context and segments.

International Address Style

This style provides basic validation of address data. Oracle HRMS provides international address styles for many countries. This style can be used for both location and personal addresses. International address styles are named territory_code_GLB. For example, the Australian international address style is AU_GLB.

Territory codes can be found in the FND_TERRITORIES table.

If no international address style is available for your country, you can use the generic style (GENERIC) to enter your address information. This generic structure provides no validation.

Local Address Style

This style provides full validation of address data and is set up by a localization team. Where a local address style exists, it can usually be used for both location and personal addresses. Local address styles are named territory_code. For example, the Australian local address style is AU.

Where a local address style exists and the Business Group uses the legislation code for that country, the local address style is displayed as the default in the appropriate address entry window. Where no local address exists, the international style is the default.

US and Canadian users: the local address style for the US or Canada is only available when you have Vertex geocodes data installed.