Purpose: Use this menu option to upload a file to a specified table in the Order Management System database.
For more information: See Working with File Imports.
Purpose: Use this screen to process a file upload.
RMFCS integration: You cannot use this 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 Management System Cloud Service for a process overview. However, you can review uploads from RMFCS on this screen.
How to display this screen: Enter WUPL in the Fast path field at the top of any menu or select Work with File Uploads from a menu.
When you first advance to this screen, processed file uploads display on the screen in descending date sequence.
Column sort: You can sort on any column except Date on this screen by clicking the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.
Field |
Description |
The file to upload to the Order Management System database. Select Browse to locate and select the file to upload. Required. |
|
The type of upload to perform. Valid values are: • ACS Tape • Catalog Requests • Cust Price Group Exclusions • MBS Tape • PO Layering • Price Codes • Promotions • Retail Integration Items • Sales Associates • Set Components • Source Codes • Stores • USPS Zip Codes • Vendors See Available File Uploads for more information about each upload. Note: You cannot use this screen to upload item or offer information from RMFCS; however, completed RMFCS imports are listed at this screen. See Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration for background. Required. |
|
An upload history record displays for each file upload that you have begun processing by populating the staging table, or completed processing: |
|
Date |
The date and time when the file upload occurred. A record is written regardless of whether the upload was submitted from the screen or through a periodic function that submitted the file data for processing. Enter a full or partial date and time to review upload history records whose date contains your entry. Optional. |
The status of the file upload. • Submitted = The file upload has been submitted for processing. • Uploading = The file is being moved from the client to the server. • Processing = The file upload is currently being processed. • Completed = The file upload was processed successfully. • Error = A record in the upload file failed to upload successfully. See Troubleshooting the File Upload. Enter a full or partial status to review upload history records whose status contains your entry. Alphanumeric, 10 positions; optional. |
|
File Type |
The type of file processed. Valid values are: • CSACST = ACS Tape file upload. • IXCRIN = Catalog Requests file upload. • CUSTPGEUP = Cust Price Group Exclusions file upload. • CSMBST = MBS Tape file upload. • POLAYR = PO Layering file upload. • PRICECDUPLOAD = Price Codes file upload. • PRMUPLD = Promotions file upload. • RIIUPP = Retail Integration Items file upload. • SALESREP = Sales Associates file upload. • INSCUP = Set Components file upload. • IXSRCE = Source Codes file upload. • STOREUPL = Stores file upload. • MSUSPS = USPS Zip Codes file upload. • VNDUPL = Vendors file upload. Enter a full or partial file type to review upload history records whose file type contains your entry. See Available File Uploads for more information about each upload. Note: You cannot use this screen to upload item or offer information from RMFCS; however, you can use this screen to review RMFCS imports. These uploads are listed with a file type of RIIUPP. See Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) Integration for background. Alphanumeric, 15 positions; optional. |
File Name |
The name of the file that was uploaded. A file path is displayed if the file was uploaded through the screen, rather than through the File Storage API. Enter a full or partial file name to review upload history records whose file name contains your entry. Alphanumeric, 256 positions; optional. |
User |
The user ID of the user that performed the file upload. A user ID of ADMIN is listed if the upload was processed through the File Storage API. Enter a full or partial user ID to review upload history records whose file name contains your entry. Alphanumeric, 10 positions; optional. |
Screen Option |
Procedure |
Process a file upload |
Use the Browse button to select a file for upload, and then select the File Type. See File Upload Process for more information. |
Delete an upload history record |
Select Delete for an upload history record. At the Are you sure you want to delete the upload history? window, select Yes to delete it; otherwise, select No to cancel. You can also use the PURGEUH Purge Upload History Table periodic function (program name PFR0126) to purge all upload history records that are older than the number of days defined in the Parameter field. |
Review the error message associated with an upload history record that is in an Error status |
Select View Error to display a window that contains a description of the error that occurred during processing. The window is blank if no error occurred. |
Refresh the information on the screen |
Select Refresh Page. |
