Oracle® Fusion Applications Customer Data Management Implementation Guide 11g Release 1 (11.1.1.5.0) Part Number E20433-01

Contents

Previous

Next

18 Common Customer Data Management Configuration: Define Data Formats

This chapter contains the following:

Creating an address style format: Worked Example

FAQs for Define Data Formats

Creating an address style format: Worked Example

This example shows how to create an address style format for a specified address style.

Specify the address style format name and address style, create the format variation layout, and assign a locale.

Creating the address style format name and specifying the address style

Create the address style format code and name, choose which address style you want to use to define this address style format, and specify if you want this address style format to be the default format for the selected address style.

1. On the Manage Address Formats page, click Actions and then click New.
2. On the Create Address Style Format page, complete the fields in the Overview section, as shown in this table:

   Field	Value
   Code	CA_POSTAL_ADDR
   Name	Canadian Postal Address Format
   Address Style	Postal Address
   Default	No

   
   
3. Click Save.

Creating the format variation layout

Specify the address lines you want in the address and the position of the lines in the address layout. You also want to specify if the address lines will be mandatory, whether the address lines will render in uppercase, and whether there will be blank lines after the address line.

1. In the Format section on the Create Address Style Format page, click on the Format Layout tab.
2. In the Format Variation section, click Actions and then click New.
3. Enter a variation number in the Variation field.
4. In the Format Variation Layout section, click Actions and then click New.
5. Complete the fields as shown in this table:

   Field	Value
   Line	1
   Position	1
   Prompt	Address line 1
   Address Element	Address line 1
   Required	Yes
   Uppercase	No

   
   
6. Click Actions, then click New to create another address line.
7. Complete the fields as shown in this table:

   Field	Value
   Line	2
   Position	2
   Prompt	City
   Address Element	City
   Required	Yes
   Uppercase	Yes

   
   
8. Click Expand on the City address line, then enter the value 1 in Blank Lines Before.
9. Continue to create as many address lines as you require. Click Expand if you want to enter blank lines and delimiters before, or after, an address line. In this section you can also create an Attribute Transform Function to change a data value into a different value.

Assigning a locale

Specify the relevant countries for this address style format.

1. In the Format section on the Create Address Style Format page, click on the Locale Assignment tab.
2. Click Actions and then click New.
3. Choose a country for the address style format.
4. Continue to add the countries that will use this address style format.
5. Click Save and Close.

FAQs for Define Data Formats

How can I create an address style format layout?

Click New in the Manage Address Formats page and add address lines in the Format Variation Layout section. If you require more than one address style format layout, then you can create a format variation and add a different address format layout.

How can I create a name style format layout?

Click New in the Manage Name Formats page and add line entries for each part of the full name in the Format Variation Layout section, within the Create Name Style Format page. If you require more than one name style format layout, then you can create a format variation and add a different name format layout.

Previous Next

Copyright ©  2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Contents Contact Us