Running the Initial Load of Address Book Geo Code (R01120) Report
Select A/B Advanced & Technical Operations (G0131), Initial Load of Address Book GeoCode.
To run the Initial load of Address Book Geo Code report, you must perform data selection on any column in the Address Book Master (F0101) table.
When you run the R01120 report, create, or update an address book record, the system uses a business service to communicate with the Oracle Location Services to convert the mailing address to latitude and longitude coordinates. These coordinates are stored in the Address Book Geo Code (F0119) table. If the service cannot convert the given address, it will find the coordinates for the city, state, or postal code. If no part of the address is valid, the F0119 record will be updated with an error flag. For example, if the street name is incorrect but a valid postal code is specified, then the system retrieves a location in the postal code.