Importing Store Cross Reference Locations through Oracle Retail Order Brokers Discovery Web Service | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Store Update Errors Report |
Purpose: The Store Upload allows you to upload store information from an external system to create or update records the Store Cross Reference table.
Note: You cannot use the Store Upload process to delete a record from the Store Cross Reference table.
In this chapter:
For more information: See Work with Store Cross Reference (WSCR) for more information on creating, updating, and deleting store cross references in Order Management System.
The setup required to use the store upload includes:
• Work with File Upload (WUPL)
• STRUPLD Upload Store Periodic Function
Create a Store flat file for the store information you wish to create or update.
• The fields in this flat file are fixed length, each record separated by a carriage return.
• The name of the file must start with ST and have a .TXT file extension; for example: ST99999.txt, where 99999 is a unique value for each Store file.
• Include only one record for each store you wish to upload. However, if multiple records exist for the same store number, the system creates or updates the record in the Store Cross Reference table using the information in the last record processed.
• If you wish to leave any field in the upload file blank, pass a space in the field so that the file can be processed without errors. Leaving a field with no space is interpreted as null in the database and causes errors.
File contents:
Field |
Description |
Updates Store# in the Store Cross Reference table. Alphanumeric, 10 positions; Required. |
|
Updates Description in the Store Cross Reference table. Alphanumeric, 40 positions; Required. |
|
Updates Active? in the Store Cross Reference table. Valid values are: • Y = The store is active. • N = The store is not active. Alphanumeric, 1 position; Required. |
|
Updates Address Line 1 in the Store Cross Reference table. Alphanumeric, 32 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
|
Address 2 |
Updates Address Line 2 in the Store Cross Reference table. Alphanumeric, 32 positions; Optional. |
Address 3 |
Updates Address Line 3 in the Store Cross Reference table. Alphanumeric, 32 positions; Optional. |
Address 4 |
Updates Address Line 4 in the Store Cross Reference table. Alphanumeric, 32 positions; Optional. |
Updates City in the Store Cross Reference table. Alphanumeric, 25 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
|
Updates State in the Store Cross Reference table. The state code must be defined for the SCF associated with the postal code. Alphanumeric, 2 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
|
Updates Postal Code in the Store Cross Reference table. The postal code must be at least 5 characters and its first three positions must exist in the SCF table. Alphanumeric, 10 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
|
Updates Country in the Store Cross Reference table. Alphanumeric, 3 positions; Required when updating an existing record whose Ship for Pickup flag is selected. |
|
Updates Telephone # in the Store Cross Reference table. Alphanumeric, 14 positions; Optional. |
Sample record in Store file:
STORE#777 THIS IS STORE#777 NAME/DESCRIPTION YSTORE#777 STREET ADDRESS LINE 1 STORE#777 STREET ADDRESS LINE 2 STORE#777 STREET ADDRESS LINE 3 STORE#777 STREET ADDRESS LINE 4CITY MA01468 USATELEPHONENUMBR
Use the Work with File Uploads (WUPL) menu option to upload the Store file to the Order Management System application server.
Note: Using the File Storage API to upload stores is not currently supported.
Use the following setting in the CWDirectCP Server Properties File for the Store Upload.
Setting |
Description |
The directory on the Order Management System application server the Store Upload Process monitors for new Store files to process. Note: The name of the file must start with ST and have a .TXT file extension; for example: ST00001.txt and ST00002.txt. An example directory on the application server is /domain/conf/OMSFiles/File/Store/, where domain is the WebLogic domain directory for Order Management System. |
STRUPLD Upload Store Periodic Function
Use the STRUPLD periodic function to submit the Store Upload Process.
Function: |
STRUPLD |
Description: |
|
Program name: |
PFR0110 |
Company |
The Company flag must be selected. The Store Upload process creates records in the Store Cross Reference table using the company you entered when you submitted the STRUPLD periodic function. |
5. The STRUPLD periodic function is delivered with the system. Use the Working with Periodic Functions (WPER) menu option to review it.
6. Use the Working with Periodic Processes (WPPR) menu option to assign the STRUPLD periodic function to a periodic process.
7. Once you have created the periodic process, you can use the Execute Periodic Process screen (located in the Working with Periodic Processes (WPPR) or Executing Periodic Processes (EPRO)) to define a schedule for the job. See Defining the Job Schedule.
For more information: See Scheduling Jobs for more information on How to Schedule a Job.
Store upload process flow:
When you submit the STRUPLD Store Upload periodic function, the system performs the following steps.
1. |
Looks in the directory defined for the STORE_FILE_PATH property for new Store Files to process. If a file exists in the STORE_FILE_PATH directory whose file name begins with ST and has a .TXT file extension, the system selects the file for processing. |
2. |
Validates each record in the file. • The system includes records that do not pass validation on the Store Update Errors Report. • The system continues to the next step for records that pass validation. |
3. |
Creates or updates records in the Store Cross Reference table for the company you entered when you submitted the STRUPLD periodic function. The system uses the Store # in the Store File to determine if the record is an add or a change. • If the Store # matches a Store # in the Store Cross Reference table, the system updates the existing record. Note: When updating an existing store cross reference record, the system overlays the existing values for the record with the values that are passed in the upload. For example, if the upload record does not include a Phone, the system updates the Telephone # field in the Store Cross Reference table to blank. • If the Store # does not match a Store # in the Store Cross Reference table, the system creates a new record. You can review the store cross reference records that have been created and updated in the Work with Store Cross Reference (WSCR) menu option. |
4. |
Once all of the records in the Store file are processed, the system changes the file extension of the file from .TXT to .PRC to indicate that the file has been processed. It is your responsibility to delete files with the .PRC file extension. |