Oracle AR : Customer Form, Address –> Design and assign new address styles

Many a time , we like to change address style , like making some field mandatory or non-mandatory , or assign value set , adding extra fields etc. Oracle provide lot many seeded style. We can either modify them or add new one for country’s style need. here using example for Mexico but steps are same applicable if you want to define new

To implement the solution, please execute the following steps:

1. Create an Address Style for Mexico

   Responsibility: Application Developer
   Navigation: Application > Lookups > Application Object Library

   Query for ADDRESS_STYLE
   Insert a record for the Mexico Address Style:

   Code = Mexico
   Meaning = Mexico
   Description= Mexico Address Style

2. Define the descriptive flexfield (DFF) and segments for ‘Address’

   Responsibility: Receivables Manager
   Navigation: Setup > Financials > Flexfields > Descriptive > Segments

   Query for Title = Address
   Unfreeze the flexfield.
   Insert an additional Context Field Value record to include the Address Style for Mexico:
   Code = Mexico
   Name = Mexico
   Description = Mexican Address Style

   Define segments as you want, you can review other styles to see how those got define.

   Save.
   Freeze and compile the flexfield.

3. Assign the address style that was just created to the Country of Mexico in the Countries form in AR

   Responsibility: Receivables Manager
   Navigation: Setup > System > Countries

   In the Country/Territory field, query for Mexico
   For the Address Style field, click on the LOV and select the Address Style = Mexico (created in Step 2).

4. Test the issue

Responsibility: Receivables Manager
Navigation: Customers > Standard

Query for a customer
In the Match Results window, click New button to enter a new address
In Customer Addresses window, select Country ‘Mexico’.
Mexico address style appears. Click in the Address window.
The Customer Address window appears with Context Value.
Select context value ‘Mexico’ from the list of values
The ‘Customer Addres’ window now appears with the following address fields:
Context Value = Mexico
Address1
Address2
City
State
Click to open the State list of values, it is showing all the Mexican states.