Working with File Imports
Purpose: Your options for uploading file data to Order Administration are:
-
File storage API: Use the file storage API to import files for most types of imports, as well as deleting files that are no longer needed. See the Available File Uploads for details.
-
The file storage API stages uploaded file data in the FILE_STORAGE database table. Upload processes point to the FILE_STORAGE table when retrieving data to update target database tables. See File Storage API.
-
The file storage API also supports exporting files. See File Storage API.
-
Work with File Uploads (WUPL): You can use this menu option to upload files. When you upload a file through this menu option, if the file contents need to first be placed in a staging database table before processing, the upload process populates the staging table with the file data. However, you cannot use this option for the Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration.
Regardless of how the upload file contents are retrieved or staged, you then need to update the destination table in the Order Administration database with the uploaded data. The file layouts, edits, and periodic processes are the same, regardless of the method you use to upload the data.
In this topic:
File Upload Setup
Before you can use the file upload process, you must complete the required setup.
File Upload Properties
Order Administration uses the following properties to process a file upload.
| Property Name | Description |
|---|---|
|
FILE_STORAGE_MAX_SIZE Located in Working with Customer Properties (PROP). |
The maximum size, in bytes, of a file that can be uploaded to the FILE_STORAGE table. If a file’s size exceeds this maximum, the API returns a 403 error and the upload fails. Uploaded files should be less than 1G in size, so this property should be set to 1073741824 or less. |
|
Located in Working with Admin Properties (CPRP). |
Defines the number of records to process in an upload file at a time. The default setting is 2500, indicating the system inserts records from the upload file into the Order Administration database in batches of 2500. If a record in a batch contains an error, the system does not insert any of the records in the batch into the Order Administration database and places the upload file in an error status. For troubleshooting purposes, you can decrease the UPLOAD_BATCH_SIZE and reprocess the file upload to help you determine which record contains the error. Example: In this example, the CWDIRECTCP_UPLOAD_BATCH_SIZE is 10. You process an upload file containing 30 records. In this situation, the system processes the upload file in 3 batches: the first batch contains records 1-10; the second batch contains records 11-20; and the third batch contains records 21-30. If a record in the second batch fails, the system does not process any of the records in the second batch, but does process all of the records in the first batch and third batch. |
|
Located in Working with Customer Properties (PROP). |
Defines the location of the USPS Zip Codes upload file. |
|
STORE_FILE_PATH Located in Working with Customer Properties (PROP). |
Defines the path used for the Stores upload file. Note: This property is defined by Oracle and cannot be changed. |
File Upload Process
The file upload process includes the following steps:
-
Using the File Storage API or Processing File Uploads through Work with File Uploads (WUPL)
-
Processing staged data: Some uploads, such as Catalog Requests, initially populate an intermediate table in the database. For these uploads, you need to run an additional process to use the contents of the intermediate table to populate the destination table. Uploads that require the use of a staging table are described under Available File Uploads.
Populating the Upload File
The file upload requires you to identify the file containing the data to upload to the Order Administration database. You can create an upload file by:
-
creating your own text file, using a text editor or spreadsheet application, or
-
copying the sample file upload data, pasting the data into a text editor, and saving it with the file extension .txt, unless otherwise indicated. See Sample Upload Data.
Important:
In order to leave any field in an upload file blank, pass a space in an alphanumeric field and a 0 in a numeric field so that the file can be processed without errors. Leaving a field with no space or 0 is interpreted as null in the database and causes errors.
Processing File Uploads through Work with File Uploads (WUPL)
Run or schedule a file upload periodic function (see Available File Uploads) or use the Work with File Upload Screen to upload a file to a specified table in the Order Administration database.
RMFCS integration: You cannot use the Work with File Upload Screen to upload a file for the Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration. See Data Flow from RMFCS and RPCS to Order Administration for a process overview.
Completing the Work with File Upload Screen
-
Use the File Name field to select the file to upload.
-
Use the File Type field to specify the type of upload to perform.
-
Select Submit File Upload.
File Upload Process
The system:
-
Clears all records from the target table in the Order Administration database. Note: The system performs this step for each file type except Retail Integration Items.
-
Moves the upload file to the directory defined in the CWDIRECTCP_UPLOAD_DIRECTORY property (CPRP); however, the USPS Zip Code Upload uses the CWDIRECTCP_ USPS_UPLOAD_ FILE directory, and the Sales Rep Upload uses the ASSOCIATE_FILE_PATH (CPRP).
Note:
When you use Work with File Upload (WUPL), the upload file remains in this folder until you run the periodic function to populate the destination table, as described in the next step. -
Uses a bulk insert to load the records in the upload file into the specified table in the Order Administration database. The CWDIRECTCP_UPLOAD_BATCH_SIZE property defines the batch size used to process the records in the upload file. For example, if this setting is set to 2500, the system inserts records from the upload file into the Order Administration database in batches of 2500.
The Work with File Upload Screen displays the upload history record in the lower portion of the screen.
A Completed Status indicates all records in the file were processed successfully.
-
An Error status indicates a record in the upload batch failed to upload to the database successfully. In this situation, the system does not insert any record in the batch into the Order Administration database. The system places the file upload in an Error status and a description of the first error encountered is assigned to the upload history record so that you can correct the error. Select View Error to display a description of the error that occurred during processing. The error description provides the upload batch number that failed to process.
Important:
If you run the file upload process and an upload file does not exist to process, or if an error occurs during processing, the system will still clear the records in the associated Order Administration upload table. You must correct any errors and run the file upload process again the populate the associated Order Administration upload table.
Processing example: To import Catalog Requests through the file storage API:
-
Create or obtain the Catalog Request file named IXCRIN.txt. See the Sample Catalog Requests Upload Data for sample contents.
-
Use the Work with File Upload Screen to upload the IXCRIN.txt file.
-
This clears populates the Catalog Request Interface table (IXCRIN). Also, the system creates a file upload record, viewable at the Work with File Upload Screen.
-
Use the Work with Catalog Request Interface (WCRU) menu option to process the records in the Catalog Request Interface table; see Working with the Catalog Request Interface (WCRU).
Troubleshooting the File Upload
Logging: During the file upload process, the system writes messages to the Trace log if its logging level is set to Debug or lower.
Example of log entries for successful file upload:
11:39:18,270 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,293 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,293 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:18,316 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:39:18,434 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,814 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,826 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,826 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,840 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:39:48,853 DEBUG TRACE - Upload path and file is /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:39:48,865 DEBUG TRACE - 10 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,897 DEBUG TRACE - 20 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,905 DEBUG TRACE - 30 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,912 DEBUG TRACE - 40 RIItemUpload50Records.txt upload records have been processed so far.
11:39:48,916 DEBUG TRACE - 49 RIItemUpload50Records.txt total upload records were processed.
11:39:48,923 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txtExample of log entries for failed file upload: If an error occurs during processing, the log indicates which batch did not process successfully. Notice in this example, the third batch of records did not process.
11:41:17,811 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,820 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,820 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:17,833 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:41:17,861 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,814 DEBUG TRACE - Upload started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,824 DEBUG TRACE - Upload completed for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,824 DEBUG TRACE - Upload file processing started for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,837 DEBUG TRACE - Upload file is RIItemUpload50Records.txt
11:41:44,847 DEBUG TRACE - Upload path and file is /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txt
11:41:44,863 DEBUG TRACE - 10 RIItemUpload50Records.txt upload records have been processed so far.
11:41:44,871 DEBUG TRACE - 20 RIItemUpload50Records.txt upload records have been processed so far.
11:41:44,957 DEBUG TRACE - 49 RIItemUpload50Records.txt total upload records were processed.
11:41:44,977 DEBUG TRACE - Upload file processing ended for /domain/OMSFiles/File/Uploads/RIItemUpload50Records.txtError processing: If any record in an upload batch is in error, the system does not insert any record in the batch into the Order Administration database. The system places the upload batch in an error status and a description of the first error encountered is assigned to the associated upload history record so that you can correct the error. You can select View Error to display a description of the error that occurred during processing.
If you are unable to determine which record in the upload batch is in error, you can decrease the batch size defined for the CWDIRECTCP_UPLOAD_BATCH_SIZE setting in the CWDirectCP Properties file and reprocess the records in the batch to narrow down the record that is in error. For example, if you normally process a batch size of 2500 records, for troubleshooting purposes, you can temporarily change the batch size to 10 and reprocess. The system will process the records in the upload file in batches of 10 records and fail the upload batch that contains the error. In this example, only 10 records will exist in the batch to help you determine where the error occurred.
Note:
The system places the upload batch in an error status for the first error encountered. When you reprocess the upload file after correcting the error, the file may be placed in an error status again if another error is found during processing.
Error related to large batch size: An upload file is placed in an error status with the error message Stopped waiting for file to upload when a large file does not transfer from a user’s local machine to the Order Administration application server within 20 minutes. To correct this issue, upload the file in smaller sections to accommodate the slow upload speed or get a faster internet connection.
Other possible errors: A file upload might also fail because:
-
There is a blank line at the end of the file.
-
The file is not UTF-8 encoded.
Available File Uploads
Upload steps: You can upload records to the following tables in the Order Administration database. Use the processing steps listed below to upload the data in a text file and then process the file data to populate the target table.
Using file storage API: The steps listed below under To Process for each upload assume that you have used the putFile web service method to upload the file. The file content is staged in the OMS-IMPORT container of the FILE_STORAGE table. See File Storage API for background. You will need to then run the periodic functions listed below for each upload in order to use the record in the FILE_STORAGE table to update to the target table.
Example: After you upload the PO Layering file record to the FILE_STORAGE table, run the UPPOLAY Upload PO Layering File (Program name PFR0134, Parameter POLAYR) periodic function to upload a PO Layering file named POLAYR.txt to the PO Layering table (POLAYR).
Staging table? Some of the uploads listed below initially update a staging table, and require an additional step to use the staged data to update the target table. Others can update the target table directly from the contents of the uploaded file without the use of a staging table.
Periodic processes: Some of file uploads listed below require the use of two periodic functions for processing. For example, to run the Customer Price Group Exclusions upload, you need to first run the CPGIXUP periodic function, and then the CPGIXUP periodic function. You can set up a periodic process to run these two functions.
File Upload screen: Regardless of whether the file storage API is enabled for imports, you can accomplish file uploads from the Work with File Upload Screen for each of the uploads listed below, with the exception of the batch inventory overlay import. In most cases, the upload from this screen also executes the required periodic function to process the uploaded data.
See File Upload Process for instructions on using the File Storage process or the upload from the CWDIRECTCP_UPLOAD_ DIRECTORY.
| File Type | Order Administration Upload Table | To Process | Sample Upload Data |
|---|---|---|---|
|
ACS Tape |
ACS Tape table (CSACST) |
After using the putFile method to upload the file (File Storage API), run the UPACSTP Upload ACS Tape File (Program name PFR0134, Parameter CSACST) periodic function to upload an ACS Tape file named CSACST to the ACS Tape table (CSACST). Note: This step is not necessary if you use the Work with File Upload Screen to upload the ACS Tape file. Update target table: After populating the ACS Tape table, you must use the Process Address Changes (PACS) menu option, selecting an Input File Type of ACS, to process the records in the ACS Tape table; see Loading Address Updates. |
|
|
Batch Inventory Overlay Upload |
N/A: updates the Item Location table directly |
After using the putFile method to upload the file (File Storage API), run the INVOVRL periodic function. Processing File Uploads through Work with File Uploads (WUPL) is not supported for the batch inventory overlay upload. |
See Batch Inventory Overlay Upload For more information see the Order Administration Web Services Guide on My Oracle Support (ID 2953017.1). |
|
Catalog Requests |
Catalog Request Interface table (IXCRIN) |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPCATRQ Upload Catalog Request File (Program name PFR0134, Parameter IXCRIN) periodic function to upload a Catalog Request file named IXCRIN to the Catalog Request Interface table (IXCRIN). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Catalog Request file. Update target table: After populating the Catalog Request Interface table, you must use the Work with Catalog Request Interface (WCRU) menu option to process the records in the Catalog Request Interface table; see Working with the Catalog Request Interface (WCRU). |
|
|
Cust Price Group Exclusions |
Customer Price Group SKU Exclusion Upload Table (CUSTPGEUP) |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPCSTPG Upload Customer Price Group Exclusion File (Program name PFR0134, Parameter CUSTPGEUP) periodic function to upload a Customer Price Group Exclusion file named CUSTPGEUP to the Customer Price Group SKU Exclusion Upload table (CUSTPGEUP). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Customer Price Group Exclusion file. Update target table: After populating the Customer Price Group SKU Exclusion Upload table, use the CPGIXUP Customer Price Group SKU Exclusion Upload periodic function (Program name PFRCPGEXUP) to process the records in the upload table; see Customer Price Group SKU Exclusion Upload. |
|
|
MBS Tape |
MBS Tape table (CSMBST) |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPMBSTP Upload MBS Tape file (Program name PFR0134, Parameter CSMBST) periodic function to upload an MBS Tape file named CSMBST to the MBS Tape table (CSMBST). Note: This step is not necessary if you use the Work with File Upload Screen to upload the MBS Tape file. Update target table: After populating the MBS Tape file table, use the Process Address Changes (PACS) menu option to process the records in the MBS Tape table; see Loading Address Updates. |
|
|
PO Layering |
PO Layering Table (POLAYR) |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPPOLAY Upload PO Layering File (Program name PFR0134, Parameter POLAYR) periodic function to upload a PO Layering file named POLAYR.txt to the PO Layering table (POLAYR). Once the records are uploaded to the PO Layering table, the process uses the newly uploaded records to update the due date and backorder quantity for order lines on backorder. Note: When you run purchase order layering, the system clears the PO Layering table and rebuilds it based on the purchase order records that are uploaded to the table. In order to ensure accurate updates, you must upload the PO Layering table with ALL open purchase orders every time you perform an upload. Note: This step is not necessary if you use the Work with File Upload Screen to upload the PO Layering file. |
|
|
Price Codes |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPPRCCD Upload Price Code File (Program name PFR0134, Parameter PRICECDUPLOAD) periodic function to upload a Price Code file named PRICECDUPLOAD to the Price Code Upload Table (PriceCdUpload). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Price Code upload file. Update target table: You must run the PCUPLD Price Code Upload periodic function (Program name PFPRCCODUP) to process the records in the Price Code Upload table; see Price Code Upload. |
||
|
Promotions |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPPROMO Upload Promotion Code File (Program name PFR0134, Parameter PRMUPLD) periodic function to upload a Promotion file named PRMUPLD to the Promotion Upload Table (PRMUPLD). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Promotion upload file. Update target table: You must run the PRMOUPL Create or Delete Promotions periodic function (Program name PRMOUPL) or use the Work with Promotion Values (WPRO) menu option to process the records in the Promotion Upload table; see Promotion Upload. |
||
|
Retail Integration Items |
Note: You cannot use the UPRITEM Upload Retail Item File (Program name PFR0134, Parameter RIIUPP) periodic function or the Work with File Upload Screen to process imports from RMFCS, although completed RMFCS imports are listed at the Work with File Upload screen. See Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration for background. |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPRITEM Upload Retail Item File (Program name PFR0134, Parameter RIIUPP) periodic function to upload a Retail Integration Item file named RIIUPP to the RI Item Upload Table (RIIUPP). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Retail Integration Item file. Update target table: After uploading the file, run the RIUPLD Retail Integration Item Upload periodic function (Program name PFR0084) or use the Work with Retail Integration Item Upload (RIIU) menu option to process the records in the RI Item Upload table; see Working with Retail Integration Item Upload (RIIU). Note: You cannot use the Work with File Upload Screen to process item information from Oracle Retail Merchandising Foundation Cloud Service (RMFCS). See Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration for information on how to import item information from RMFCS. |
|
|
Sales Associates |
After using the putFile method to upload the file, run the SLSUPLD (Program name PFR0109) periodic function to update the target table; see Salesman Associate Upload. This step is not necessary if you use the Work with File Upload Screen to upload the Salesman Associate file to the ASSOCIATE_FILE_PATH (CPRP). File name: 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. If you use the file storage API for imports, 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. See Salesman Associate Upload for more information. Note: The SLSUPLD periodic function uses the folder defined in the ASSOCIATE_FILE_PATH (CPRP) rather than the CWDIRECTCP_UPLOAD_ DIRECTORY. |
||
|
Source Codes |
Source Upload Table (IXSRCE) |
After using the putFile method to upload the file (File Storage API) or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPSRCCD Upload Source Code File (Program name PFR0134, Parameter IXSRCE) periodic function to upload a Source Code file named IXSRCE to the Source Upload Table (IXSRCE). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Source Code file. Update target table: You must use the Work with Source Code Upload (WSRW) menu option to process the records in the Source Code Work table; see Generating Source Codes Using the Source Upload Table (WSRW). |
|
|
Stores |
File upload: Use the Work with File Upload Screen to upload the Store file to the STORE_FILE_PATH. The file name must begin with ST and have a .TXT file extension; see Store Upload. Update target table: Run the STRUPLD periodic function. This function uses the folder defined in the STORE_FILE_PATH rather than the CWDIRECTCP_UPLOAD_ DIRECTORY. Note: Uploading the Store file through the file storage API is not currently supported. |
||
|
USPS Zip Codes |
USPS Zip Codes Upload |
Use the putFile method to upload the file if you are using the File Storage API; otherwise, place the file in the CWDIRECTCP_ USPS_UPLOAD_ FILE and use the Work with File Upload Screen to upload the USPS Zip Codes file. Update target table: After uploading the file, use the Load USPS Zip Code File (LZPS) menu option to process the uploaded file. The file name must be ctystate.txt, and file name matching is case-sensitive. See Fields in the USPS Zip/City/State Table and Fields in the USPS Zip/City/State Table for background. |
|
|
Vendors |
Vendor Upload Table (VNDUPL) |
After using the putFile method to upload the file (File Storage API), or placing the file in the CWDIRECTCP_UPLOAD_ DIRECTORY, run the UPVENDR Upload Vendor File (Program name PFR0134, Parameter VNDUPL) periodic function to upload a Vendor file named VNDUPL to the Vendor Upload Table (VNDUPL). Note: This step is not necessary if you use the Work with File Upload Screen to upload the Vendor Upload file. Update target table: After uploading the file, run the VNDUPLD Vendor Upload periodic function (Program name PFR0086) or use Working with Vendor Upload (LVUP) to process the records in the Vendor Upload table. |
Purging Upload History
PURGEUP: Run the PURGEUH Purge Upload History Table (program name PFR0126) periodic function to purge Upload History records that are older than the number of days specified in the Parameter field. If the Parameter field is blank or 0, records must be 21 days old to be eligible for purge.
Sample Upload Data
You can use the sample upload data below as a starting point to creating your own upload file by copying the sample file upload data, pasting the data into a text editor, and saving it with the file extension .TXT, unless otherwise indicated.
Important:
In order to leave any field in an 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.
Sample ACS Tape Upload Data
Use the sample data below to create an ACS Tape upload file. See ACS Tape for a setup summary, and Loading Address Updates for processing information.
200000145BXBKCCJ21263204414 200206F 038ANDERSON JEN S 1234 EXAMPLE CIR HALETHORPE MD21227S 123 MARY WAY CT LINTHICUM HEIGHTS MD21090-1754533453 MARY WAY CT XX0000 C
Sample Catalog Requests Upload Data
Use the sample data below to create a Catalog Requests upload file. See Catalog Requests for a setup summary, and Working with the Catalog Request Interface (WCRU) for processing information.
34 SAMPLE STREET|APT123|ADDRESS LINE 2|ADDRESS LINE 3|ADDRESS LINE 4|WESTBOROUGH|01581||MA|US|5085550100||thomasbrown@example.com|O1|R|COMPANY NAME|SOURCE7|7|1150417|207|5085550101||5085550102||MS.|MARY|M|JOHNSON||MARYJOHNSON@EXAMPLE.COM||5085550104|5085550105|5085550106|1|1|O1
Sample Customer Price Group Exclusions Upload Data
Use the sample data below to create a Customer Price Group Exclusions upload file. See Cust Price Group Exclusions for a setup summary, and ../marketing/c_customer_price_group_sku_exclusion_upload.dita#customerpricegroupskuexclusionupload for processing information.
7|1|CPG|RF123SKU4567|ROSE XSML WMNS||
Sample MBS Tape Upload Data
Use the sample data below to create an MBS Tape upload file. See MBS Tape for a setup summary, and Loading Address Updates for processing information.
JOHN SMITH 1 TEST DRIVE WESTBORO MA01581 B I 01581 B 1 TEST DRIVE WESTBORO MA 1 TEST DRIVE APT 2 WESTBORO MA01581 B 12879000|Sample PO Layering Upload Data
Use the sample data below to create a PO Layering upload file. See PO Layering for a setup summary, and Purchase Order Layering for processing information.
7|RF123SKU4567|ROSE XSML WMNS|4|53|1|1080915|20| |Ref#
Sample PCO Price Code Upload Record Type
Use the sample data below to create a Price Codes upload file. See Price Codes for a setup summary, and Price Code Upload for processing information.
Sample PCO Price Code Upload Record Type
7|1|PCO|U|1150416|1234567|PRICE CODE UPLOAD|1|1|5.00|0.00|0.00|0.00|0.00|0.00|ITEM|Y|1150401|1150501|||||0||||
Sample PCC Price Code Customer Upload Record Type
7|2|PCC|U|1150416|1234567||0|0|.00|.00|.00|.00|.00|.00|||0|0|||||55||||
Sample PCD Price Code Detail Upload Record Type
7|3|PCD|U|1150416|1234567||0|0|.00|.00|.00|.00|.00|.00|||0|0|SKU|RED||SOURCE7|0||||
Sample Promotions Upload Data
Use the sample data below to create a Promotions upload file. See Promotions for a setup summary, and Promotion Upload for processing information.
Sample PRM Order Promotion Upload Record
7|PRM|A|1|1150414||PUORDER|PUORDER PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|1|O|PROMOID|5.95||.00|||||1||OA|WEB|4|4|US||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|5.00|.00
Sample PRM Freight Promotion Upload Record
7|PRM|A|2|1150414||PUFRT|PUFRT PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|2|F|PROMOID|6.95|Y|.00|||||1|Y||WEB|4|4|US||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Additional Freight Promotion Upload Record
7|PRM|A|3|1150414||PUADLFR|PUADLFR PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|3|A|PROMOID|5.00||.00|||||1|Y|A|WEB|4|4|US||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Item Category Promotion Upload Record
7|PRM|A|4|1150414||PUITMCT|PUITMCT PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|4|C|PROMOID|5.95||.00|||||1|||WEB|4|0|||N|O|O|1|10.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Tiered Promotion Upload Record
7|PRM|A|5|1150414||PUTIERD|PUTIERD PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|5|T|PROMOID|0||.00|||||0||||0|0||||||1|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM BOGO Promotion Upload Record
7|PRM|A|6|1150414||PUBOGO|PUBOGO PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|6|B|PROMOID|0.00||.00|||||0|||WEB|4|0|||N|O||1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRM Delete Promotion Upload Record
7|PRM|D|7|1150414||PUDELTE|PUDELTE PROMOTION DESCRIPTION|1150401|1150601|POPUP WINDOW MESSAGE 1|POPUP WINDOW MESSAGE 2|POPUP WINDOW MESSAGE 3|POPUP WINDOW MESSAGE 4|7||PROMOID|5.00||.00|||||1|Y|N|WEB|4|4|US|SOURCE7|N|O|O|1|.00|10||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PRB BOGO Promotion Upload Record
7|PRB|A|8|1150414||BOGO1|PUBOGOB PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||SKU|RED|1|1|5.00|.00|.00|Y|N|0|||.00|0|0|0|.00|.00|.00||||||.00|.00||||0||||||0|.00|.00|.00
Sample PBP BOGO by Price Code Promotion Upload Record
7|PBP|A|9|1150414||BOGO1|PUBOGOP PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||101|||50.00|1|101|1|5.00|.00|.00|N|Y|N|||.00|.00||||0||||||0|.00|.00|.00
Sample PMD Discount Promotion Upload Record
7|PMD|A|10|1150414||TG|TG TIER PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00|SKU|PINK||0||||||25.00|.00|.00|.00
Sample PRS Source Promotion Upload Record
7|PRS|A|11|1150414||OP|OPSORCS PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00|||SOURCE7|0||||||0|.00|.00|.00
Sample PRC Customer Promotion Upload Record
7|PRC|A|12|1150414||OP|OPCUSTC PROMOTION DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00||||55||||||0|.00|.00|.00
Sample PIC Item Category Promotion Upload Record
7|PIC|A|13|1150414||ITMCATP|PUITMC PROMO DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00||||0||DFLT||||0|.00|.00|.00
Sample PIE Item Exclusion Promotion Upload Record
7|PIE|A|14|1150414||ITMCATP|PUITMX PROMO DESCRIPTION|0|0|||||0|||0.00||.00|||||0||||0|0||||||0|.00|0||||0|0|.00|.00|.00|||0|||.00|0|0|0|.00|.00|.00||||||0.00|.00||||0||0||DFLT||0|.00|.00|.00
Sample Retail Integration Items Upload Data
Use the sample data below to create a Retail Integration Items upload file (RIIUPP or RIIUPP.TXT). See Retail Integration Items for a setup summary, and RI Item Upload Process for processing information.
RMFCS imports: See Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration for information on importing data from RMFCS.
Sample 01 Item/SKU Item Upload Record
6|1150304|110000|01|A|1|IT|3009|RED S |U|0|0|Y|0|N|0| |0| | | |0|N|0|0|0|N| |0| | | | |0|Y|N|Mens Patterned Long-Sleeve| |N|N|N|0| | |0|11500|0|CLT| |0| | |0|0| |EA|1234|0|0|0| |0| |0|0|Red Small|N|0|0|29.99|0|0|0|0|0|0|0|0|N|0|N|100101|0|100101| | | |0|0|N| |0|0|0|0|0| |N| |0|0|N|0| | |N|0| | |N|29.99|0|0| |0| |1|S010101|02| | | | | | | | |0| | |0|0|N|0|0|0|0|N|0|0|0|N |N|0|0| | | | | | |N|N|0| | | |0|0| |0|0|0| |0|0|0|0|0|0| | | | | | |0| | | |0|0|0|0|0|0|0| | |0|0|0|0|0|0|0| |0| |0| |0| | | |0|0|0|0|0| | | | |0| | | | |Y|https://example.com/is/image/Fry/1001|https://example.com/is/image/Fry/1001|https://example.com/is/image/Fry/1001|https://example.com/is/image/Fry/1001|0
Sample 03 Item Offer Upload Record
7|1150421|84600|03|A|1|IT|RITEST1| | |0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|7|16.99|15.00|Y|5.00|2|100|0.00|N|36.00|3.00|1.50|N|N|0.00|0|F|P|||||N|N|207|||0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 04 SKU Offer Upload Record
7|1150421|84600|04|A|1|IT|RITEST2|AQUA LRGE BABY||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|7|0.00|0.00|N|0|0|0.00|Y|0.00|0.00|0.00|0.00|0.00|0|N|N|||N|N|0|MO||0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 05 Item Price Upload Record
7|1150421|84600|05|A|1|IT|RITEST2| | |0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|7|1150401|1|0.00|50.00|0|0.00|0.00| |0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 06 SKU Price Upload Record
7|1150421|84600|06|A|1|IT|RITEST2|AQUA LRGE BABY||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|7|1150401|1|0.00|45.00|0|0.00|0.00||0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|0|0|0|0|0|||||0
Sample 07 Vendor Item Upload Record
7|1150421|84600|07|A|1|IT|RITEST2|||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|7|7RIITEM1VI|10|7ITEM VENDOR ITEM|2|VENDOR ITEM MESSAGE 1|VENDOR ITEM MESSAGE 2|VENDOR ITEM MESSAGE 3|10|10.0000|1.350|10|45|10||0|0|0|0|0|0|0|0|||||0
Sample 08 Item UPC Upload Record
7|1150421|84600|08|A|1|IT|RITEST2|||0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|E8|65656565|7|0|0|0|0|0|||||0
Sample 09 Item Coordinate Upload Record
7|1150421|84600|09|A|1|IT|RITEST2| | |0|0|0|0.0|0|0|0|0|0|0|0|0.0000|0|0|0|0.000|0|0|0.000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0000|0.0|0|0|0|0|0.00|0|0|0|0.00|0|0|0|0|0|0|0|0|0.000|0|0|0|0|0.000|0|0|0|0|0.0000|0.0000|0.0000|0.0000|0|0|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0|0|0.00|0|0.00|0.00|0.00|0|0|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0|0|0.00|0|0.00|0.00|0.00|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0.00|0.00|0|0.00|0.00|0|0|0|0|0|0|0|0|0|0|0.0000|0.000|0|0|0|0|0|0|0|COORDINATE1|O|coordinate1 message|AQUA LRGE BABY|0|||||0
Sample Sales Associates Upload Data
Use the sample data below to create a Sales Associates upload file. See Sales Associates for a setup summary, and Salesman Associate Upload for processing information.
5555555SALESMAN ASSOCIATE UPLOAD NAMENHOMESTORE SalesmanAssociateEmail@email.com
Sample Set Components Upload Data
Use the sample data below to create a Set Components upload file. See Importing Set Components (WCUP) for processing information.
Sample Type S: Set and Set Detail Upload Record
7|S|SET||||SETCOMP1||||1|50.00|1|0|0||0|
Sample Type VG: Variable Set and Variable Set Group Upload Record
7|VG|VARIABLE||||VARIABLECMP1||||0|0|0|0|1|VARIABLE GROUP 1|2|
Sample Type VI: Variable Set Detail Upload Record
7|VI|VARIABLE||||VARIABLECMP2||||0|0|0|0|1||0|
Sample Source Codes Upload Data
Use the sample data below to create a Source Codes upload file. See Source Codes for a setup summary, and Generating Source Codes Using the Source Upload Table (WSRW) for processing information.
7|SOURCECD7|C|$O|H|D|K|SOURCECD7 SOURCE CODE DESCRIPT|500.00|.00|.00|CD|5.00|DR|N|12.00|5.00|25.00|5.00|1|10000|1150401|5000|7000|POP UP WINDOW MESSAGE 1 |POP UP WINDOW MESSAGE 2 |POP UP WINDOW MESSAGE 3 |POP UP WINDOW MESSAGE 4 |12345|1234567|12.00|12345|123|Y|N|Y|12.00|12.00|150.00|55.00|ALPHANUMERIC 30 POSITIONSUSER1|ALPHANUMERIC 30 POSITIONSUSER2|ALPHANUMERIC 30 POSITIONSUSER3|ALPHANUMERIC 30 POSITIONSUSER4|ALPHANUMERIC 30 POSITIONSUSER5|ALPHANUMERIC 30 POSITIONSUSER6|N|N|07| |007|01|01|123|RCCD|LSTSOURCE|FPOCD|N|CAT|CL|1150601| | |123.00|N|N|
Sample Stores Upload Data
Use the sample data below to create a Stores upload file. See Stores for a setup summary, and Store Upload for processing information.
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
Sample USPS Zip Codes Upload Data
Use the sample data below to create a USPS Zip Codes upload file. See USPS Zip Codes for a setup summary, and Load USPS Zip Code File (LZPS) for processing information.
D00501V13916UHOLTSVILLE PYV13916HOLTSVILLE NA 353910NY103SUFFOLK
D00544V13916UHOLTSVILLE
Sample Vendors Upload Data
Use the sample data below to create a Vendors Upload file (VNDUPL). See Vendors for a setup summary, and Working with Vendor Upload (LVUP) for processing information.
007|7|A|EXAMPLE VENDOR |1234 SAMPLE STREET |SECOND ADDRESS LINE |THIRD ADDRESS LINE |FOURTH ADDRESS LINE |WESTBOROUGH |MA|01581 |US |JOHN SMITH |5085550100| |0|ROBERT JONES |1234 REMIT SAMPLE ST |SECOND ADDRESS LINE |THIRD ADDRESS LINE |FOURTH ADDRESS LINE |SPRINGFIELD |MA|01119 |US |Y|N|Y|P|0|0|N|N|N|N|N |0|.00|.00|.00| |0| |S| |V| |VENDOR@EXAMPLE.COM |REMIT@EXAMPLE.COM |USR1 |USR2 |USR3 | |Y