This chapter demonstrates how to use Address Correction utility to resolve the scenario in which multiple end user locations (EUL) have the same address in Master Street Address Guide (MSAG) and Ordering and Billing Forum (OBF) structured formats.
In this scenario, two end user locations have the same address components in different structured formats. One end user location with ID L1 has an address in MSAG structured format and the other end user location with ID L2 has that same address in OBF structured format.
By default, the end user location with ID L2 having the address in OBF structured format is selected as the primary. After you resolve, only the primary end user location with ID L2 is retained and the end user location with ID L1 having the address in MSAG structured format is merged with the primary end user location with ID L2.
Note:
In this scenario, the Address Correction utility always selects the end user location having the address in OBF structured format as the primary by default.The following preferences govern this scenario:
To resolve multiple end user locations with the same address in MSAG and OBF structured formats:
Run the Address Correction utility. See "Running the Address Correction Utility" for more information.
Click the Criteria tab.
Under the I want to find area, select the Multiple EULs having same address option.
Specify your search criteria in the Network Loc Name, End User Loc Name, or any of the address fields.
From the Country list, select United States.
United States is the only option available in the Country list for this scenario.
From the Format list, select one of the following:
North American Master Street Address Guide
OBF Service Address Location Information
The Address Correction utility searches for addresses in both the MSAG and OBF structured formats, irrespective of the format you select from the Format list.
(Optional) Click the field where you want to specify the partial name and click Set Criteria.
The Set Selection Criteria window is displayed that lets you specify partial names using wild cards if you do not know the full name to specify in your search criteria. See "Setting the Search Criteria" for more information.
In the Limit Number Found To field, specify a value. This value determines the maximum number of records to be retrieved for the search. See "Setting the Maximum Number of Records to Be Retrieved" for more information.
Click Search.
The Address Correction utility searches for all the groups of end user locations that have the same address in MSAG and OBF structured formats. The Results tab displays multiple end user locations grouped by address ID in the Available Groups area.
Consider an example where the end user locations and addresses exist with IDs as shown in Table 5-1.
Table 5-1 End User Locations and Addresses
| Address | Address ID | Location ID | Structured Formats |
|---|---|---|---|
|
23, TEST ST, TX, 23456 |
A1 |
L1 |
MSAG |
|
23, TEST ST, TX, 23456 |
A2 |
L2 |
OBF |
|
25, TEST ST, TX, 23457 |
A3 |
L3 |
MSAG |
|
24, TEST ST, TX, 23456 |
A4 |
L4 |
OBF |
If you select TX form the State list, the Address Correction utility searches for the end user locations that have matching address components. In this example, the Address Correction utility retrieves the following end user locations that have matching address components (23, TEST ST, TX, 23456) and displays them in the Available Groups area on the Results tab:
End user location with ID L1 that has address with ID A1 in MSAG structured format
End user location with ID L2 that has address with ID A2 in OBF structured format
In this example, the following end user locations are not retrieved in the search results because they do not have matching address components:
End user location with ID L3 that has address with ID A3 in MSAG structured format
End user location with ID L4 that has address with ID A4 in OBF structured format
Consider another example where the end user locations and addresses exist with IDs as shown in Table 5-2.
Table 5-2 End User Locations and Addresses
| Address | Address ID | Location ID | Structured Formats |
|---|---|---|---|
|
23, TEST ST, TX, 23456 |
A1 |
L1 |
MSAG |
|
23, TEST ST, TX, 23456 |
A2 |
L2 |
OBF |
|
25, TEST ST, TX, 23457 |
A3 |
L3 |
MSAG |
|
24, TEST ST, TX, 23456 |
A4 |
L4 |
OBF |
|
26, TEST ST, TX, 55555 |
A5 |
L1 |
OBF |
If you select TX form the State list, the Address Correction utility searches for the end user locations that have matching address components. In this example, the Address Correction utility does not display any results in the Available Groups area on the Results tab, because even though the address components (23, TEST ST, TX, 23456) of the end user locations with ID L1 and ID L2 are matching, an additional address with ID A5 exists in OBF structured format at the end user location with ID L1.
(Optional) On the secondary toolbar, click Export to export the data displayed in the Available Groups area. See "Exporting Available Groups Data" for more information.
Do one of the following:
Select the end user locations you want to resolve and click the single arrow button, which moves the selected end user locations from the Available Groups area to the Selected Groups area.
Click the double arrow button to move all the end user locations from the Available Groups area to the Selected Groups area.
In the Selected Groups area, the end user location having the address in OBF structured format is selected as the primary end user location by default.
Click Resolve.
Note:
The amount of time taken by the Address Correction utility to complete the resolution process depends on the number of rows in the Selected Groups area.A confirmation message is displayed that lists the total count of all the entities that will be impacted by the resolve action.
Click Yes.
You cannot undo this action.
A unique identifier (Job ID) is generated for the group of data in the Selected Groups area whose data inconsistencies are being resolved. This identifier is used to compile log information in the View Log window. See "Viewing Log Information" for more information.
The end user location having the address in MSAG format is merged with the end user location having the address in OBF structured format (primary).