Working with File Uploads (WUPL)
Purpose: Use this menu option to upload a file to a specified table in the Order Administration database.
For more information: See Working with File Imports.
Work with File Upload Screen
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 Administration 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 |
---|---|
File Name |
The file to upload to the Order Administration database. Select Browse to locate and select the file to upload. Required. |
File Type |
The type of upload to perform. Valid values are:
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. |
Status |
The status of 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:
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. |