***ERROR: File cannot be located at /domain/conf/OMSFiles/LZIP/ctystate.txt/.

Indicates that there is no file with the name and location indicated in the properties file. Use the Working with File Uploads (WUPL) menu option to copy the data file using the directory and file name indicated, and then return to the Load USPS File screen to try again. Also, make sure that you are logged onto the application server specified in the properties file.

***ERROR: File is empty.

Indicates that there is a file using the correct name in the directory indicated, but it contains no data. Use the Working with File Uploads (WUPL) menu option to copy the original data file using the directory and file name indicated, and then return to the Load USPS File screen to try again.

File has been found and is ready to be loaded. Click Accept to submit.

Indicates that you can proceed with the upload process.

Note: This message indicates that the system has located a file with the correct name and location and that it contains data. It does not indicate whether the file includes postal code data or whether it is in the correct format. See Troubleshooting the Zip/City/State Upload for possible problems and steps to correct.

Copyright detail code

D

Zip code

Bytes 2-6

City state key

Bytes 7-12

City state name

Bytes 14-39 (last 3 bytes are truncated)

City st mail name ind

Byte 56

State abbrev

Bytes 100-101

Zip

Zip code from USPS Zip/City/State work table

State

State abbrev from USPS Zip/City/State work table

City

City state name from USPS Zip/City/State work table

Company

The company number where you ran the LZPS job

Country

The Default Country for Customer Address (B17) in the company where you ran the LZPS job

How long does it take to upload postal codes?

It can take several minutes to a half hour to upload postal codes for the first time.

Where can I obtain the postal code data?

The U.S. Postal Service can provide the City State product, which includes a comprehensive list of ZIP codes and related cities and states.

Where does the LZPS job look for the City State data file I obtained from the U.S. Postal Service?

When you open the Load USPS File Screen, it checks the file name and directory specified in the CWDIRECTCP_ USPS_UPLOAD_ FILE property. An example directory is /domain/conf/OMSFiles/LZIP/ctystate.txt/, where domain is the WebLogic domain directory for Order Management System.

How can I check on whether the postal codes were uploaded successfully?

If you are uploading the information for the first time, you can select the Setting Up the Zip/City/State (Postal Code) Table (WZIP) option to see if records have been created. If you are performing a periodic update, you can check the application log, provided your logging level supports it; see below for more information.

I just ran the LZPS job. Why aren’t there any entries in the application log?

The job tracks activity in the application log only if your current logging level (as specified in the MQ_LOG_LEVEL in Logging Properties) is set to INFO or higher. See Logging Properties for information on applying a different logging level.

What do log entries look like for a successful upload?

Sample log entries indicating a successful upload:

10:41:44,267 INFO APP - LZPS total records in delivered file = 466079

10:41:44,267 INFO APP - LZPS total detail records = 80174

10:41:44,267 INFO APP - LZPS total detail records flagged as Do Not Mail = 25035

10:41:44,267 INFO APP - LZPS total detail records flagged as Mail =55139

10:41:44,267 INFO APP - LZPS total detail records written to USPS file = 55139

Note: The total number of detail records written reflects those detail records in the data file that were eligible for selection as described in the Upload Process, and were created in the USPS City/State/Zip work file. This number might not be the same as the total number of records added to the City/State/Zip table, since the job does not add a record to the City/State/Zip table if the record already exists.

What is the importance of the total number of records noted in the application log?

total records in delivered file: the total number of records in the data file located at the file name and directory specified in the CWDIRECTCP_ USPS_UPLOAD_ FILE property.

total detail records: the total number of records in the data file flagged with a D (detail).

total detail records flagged as Do Not Mail: the total number of records in the data file flagged with a D (detail) but also flagged as Do Not Mail (not mailable), and so are not eligible for selection.

total detail records flagged as Mail: the total number of records in the data file flagged as mailable and that were also flagged with a D (detail).

Note: Only records in the data file that are flagged with a D and are also flagged as mailable are eligible for selection.

total detail records written to USPS file: the total number of records in the data file that were eligible for selection and were added to the USPS City/State/Zip work table. This total may differ from the number of records added to the City/State/Zip table, since some or all of the records written to the USPS City/State/Zip work table might already exist in the City/State/Zip table.

I uploaded the ctystate.txt file from the U.S. Postal Service. Why didn’t it create any records?

Possible explanations:

• The U.S. Postal Service provides a utility to add delimiters between each record in the data file and make the file more readable. If you ran this utility against the data file, the LZPS job will not be able to read any records in the file. Re-copy the data file from the CD and start the upload process again.

• If you have recently run an upload and are attempting to upload the same data again, there will be no new records eligible to be copied to the City/State/Zip table.

How often do I need to upload new postal code data?

The U.S. Postal Service provides updated data files on a periodic basis. See their web site for more information.

Does the postal code data upload also create tax rate information?

The LZPS job does not create Zip/City/State Tax records. You can use the Setting Up the Zip/City/State (Postal Code) Table (WZIP) option to create tax records at the postal code level if needed; however, you might not need these records at the postal code level if you set tax rates at the SCF level, or if you use the generic tax integration to calculate tax.

There are still records in the USPS City/State/Zip work table. Does this indicate a problem?

This does not indicate a problem. The LZPS job does not clear the records in the work table after processing an upload; instead, it clears the records when it begins a new upload.