Salesman Associate Upload
Purpose: The Salesman Associate Upload allows you to upload salesman information from an external system to create or update records in the Salesman table.
You cannot use the Salesman Associate Upload process to delete a record from the Salesman table.
In this topic:
For more information: See Working with Sales Representatives (WSLS) for more information on creating, updating, and deleting sales representatives in Order Administration.
Salesman Associate Upload Setup
The setup required to use the salesman associate upload includes:
Salesman Associate File
Create a Salesman Associate flat file for the salesman 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 SR and have a .TXT file extension; for example: SR99999.TXT, where 99999 is a unique value for each Salesman Associate file. However, you can use the file storage API to upload a zip file that contains a single text file with the same name, for example: SR00001.ZIP containing a text file named SR00001.TXT.
-
Include only one record for each salesman associate you wish to upload. However, if multiple records exist for the same salesman number, the system creates or updates the record in the Salesman table using the information in the last record processed.
-
In order 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.
Field | Description |
---|---|
Associate ID |
Updates SLS Salesman # in the Salesman table. The system performs a modulus 10 check against the salesrep number during the Salesman Associate Upload Process if the Modulus 10 Check on Salesrep Number (E88) system control value is selected. Numeric, 7 positions; Required. |
Associate Name |
Updates SLS Name in the Salesman table. Alphanumeric, 30 positions; Required. |
Associate Status |
Updates SLS Active Flag in the Salesman table. Valid values are:
Alphanumeric, 1 position; Required. |
Home Store |
Updates SLS Store # in the Salesman table. Validated against the Store Cross Reference table; see Work with Store Cross Reference (WSCR). Alphanumeric, 10 positions; Optional. |
Associate Email |
Updates SLS EMail in the Salesman table. During the Salesman Associate Upload Process, the system verifies that:
Alphanumeric, 100 positions (however, only the first 50 positions are uploaded to the Salesman table); Optional. |
Associate Phone |
Updates SLS Phone in the Salesman table. Alphanumeric, 14 positions; Optional. |
Associate Ext |
Updates SLS Phone Extension in the Salesman table. Alphanumeric, 4 positions; Optional. |
Sample record in salesman associate file:
5555555SALESMAN ASSOCIATE UPLOAD NAMENHOMESTORE SalesmanAssociateEmail@email.com
PHONENUMBER EXT
Associate File Path Property: The upload monitors the ASSOCIATE_FILE_PATH defined in CPRP for new Salesman Associate files to process. This property is set by Oracle and cannot be changed.
The name of the file must start with SR and have a .TXT file extension; for example: SR00001.TXT and SR00002.TXT. If there are multiple eligible files, they are processed sequentially based on file name; SR00001 processes before SR00002. You can upload a zip file that contains a single text file with the same name, for example: SR00001.ZIP containing a text file named SR00001.TXT.
Work with File Upload (WUPL)
Use the Work with File Uploads (WUPL) menu option to upload the Salesman Associate flat file to the folder defined in the ASSOCIATE_FILE_PATH property.
SLSUPLD Upload Salesman Associates Periodic Function
Use the SLSUPLD periodic function to submit the Salesman Associate Upload Process.
Setting | Description |
---|---|
Function: |
SLSUPLD |
Description: |
UPLOAD SALESMAN ASSOCIATES |
Program name: |
PFR0109 |
Company: |
The Company flag must be selected. The Salesman Associate Upload process creates and updates records in the Salesman table based on the records in the Salesman Associate File using the company you entered when you submitted the SLSUPLD periodic function. |
-
The SLSUPLD periodic function is delivered with the system. Use the Working with Periodic Functions (WPER) menu option to review it.
-
Use the Working with Periodic Processes (WPPR) me menu option to assign the SLSUPLD periodic function to a periodic process.
-
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.
Salesman Associate Upload Process
Salesman associate upload process flow:
When you submit the SLSUPLD Salesman Associate Upload periodic function, the system performs the following steps.
-
Looks in the OMS-IMPORTS container in the FILE_STORAGE table for the Salesman Associate Files to process.
The name of the file must start with SR and have a .TXT file extension; for example: SR00001.TXT and SR00002.TXT. If there are multiple eligible files, they are processed sequentially based on file name; SR00001 processes before SR00002. You can use the file storage API to upload a zip file that contains a single text file with the same name, for example: SR00001.ZIP containing a text file named SR00001.TXT.
-
Validates each record in the file.
-
The system includes records that do not pass validation on the Sales Rep Update Errors Report.
-
The system continues to the next step for records that pass validation.
-
-
Creates or updates records in the Salesman table for the company you entered when you submitted the SLSUPLD periodic function.
The system uses the Associate ID in the Salesman Associate File to determine if the record is an add or a change.
-
If the Associate ID matches a SLS Salesman # in the Salesman table, the system updates the existing record.
Note:
When updating an existing salesman 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 an Associate Email, the system updates the SLS EMail field in the Salesman table to blank. -
If the Associate ID does not match a SLS Salesman # in the Salesman table, the system creates a new record.
You can review the salesman records that have been created and updated in the Working with Sales Representatives (WSLS) menu option.
-
-
Once all of the records in the Salesman Associate file are processed, the system deletes the record from the FILE_STORAGE table; however, if there were any errors in processing, the system creates a record in the table in a container of OMS-ERRORS.
Note:
The system processes all correct records in the upload file, and creates an error file that contains only any records that could not be processed.